Forum Discussion
copy formula on a huge spreadsheet
I suggest first following Twifoo suggestion of selecting the cell with the formula, then doubleclicking the little green square at bottom right corner of the selection marquee. It will stop copying down when it encounters the first blank cell in the column to its left.
Should that approach not take you down all 40,000 rows, the next easiest way of copying down the formula is to use the Address Bar just above the intersection of the row numbers and column letters. Type the range of cell addresses where you need the formula (e.g. B2:B40000), then hit Enter. This will select all those cells for you. Next, type the formula in the formula bar, and hit CTRL + Enter. That will copy down the formula in all those cells, making adjustments for any cell addresses with relative addresses for row numbers (i.e. no $).