Forum Discussion
Solved
autofill formula across large spreadsheet with sequenced cell references
Hi. Is there a way to populate 60k+ cells in a spreadsheet with a properly sequencing formula with mixed absolute and relative cell reference parameters without having to drag the autofill handle ac...
bzude54 Let's say the first cell with the formula is in B2 and you want to copy it down and across to M5000. Select cell B2 and Ctrl-C. Now, enter the rang to paste to in the name box (just above the top left-hand corner of the grid) and type B2:M5000. Press enter and then Ctrl-V.
bzude54 Let's say the first cell with the formula is in B2 and you want to copy it down and across to M5000. Select cell B2 and Ctrl-C. Now, enter the rang to paste to in the name box (just above the top left-hand corner of the grid) and type B2:M5000. Press enter and then Ctrl-V.
Riny_van_Eekelen Your method worked great! Just what I needed! Thank you very much!