Go to bottom of column

J

Jerome Ranch

I want to copy and paste a formula into an entire column
I have bunch of these to do and to scroll down takes too darn long..is
there quick way to select the first cell to copy to and then go to
the bottom of the sheet with a select?
Thanks
Jerry
 
E

Eddie

I usually, select entire column, paste the formula to into the column.
Then, if you don't want the formula appear in every cells in column.
you can go to your bottom of your list and use the short cut,
shift+Ctrl+arrow down. By doing that way, you can select all you
unwanted formula at once. then, right click->clear content.

If you already have something in your column that you want to paste,
you can go to first cell and press shift+ctrl+arrow down.
 
Top