Excel - how to autofill thousands of cells quickly
Edit|goto
Type:
A1:A35000
(or whatever the address of that range is)
This will select that range
Then type your formula for the top cell, but hit ctrl-enter to fill all the
cells in the selection.
Dennis H wrote:
I have a spreadsheet with 35000 rows. Is there an easy way to autofill a
formula for all of the rows instead of dragging down all 35000 rows?
--
Dave Peterson
|