I have a very long table, over 25,000 records.
I added a new column with a formula created in the second row (below the heading).
How do I copy the formula to the remaining rows? Instead of dragging the corner of the cell with formula down to the last row, is there any shortcut to do this?
Or more generally, how do I navigate quickly to a cell in the sheet without scrolling?