I have an Excel sheet having nearly 170,000 rows. How can I easily add a column and paste a formula for the entire rows?
Microsoft Excel: I am adding the sum of 40,000 different data into sets of 4 each. In the first row, A1, I use the command =sum(G1:G4). Then when I drag it down, the row A2 has the sum of G2:G5. Infact, I want sum(G5:G8). I need the summary to move to the next set of 4 in the column G. Advice?