cpeters5
asked on
Bulk copy in Excel
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?
pax
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?
pax
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
2013-07-05-11-25-47-Microsoft-Ex.png