Go to bottom of column

  • Thread starter Thread starter Jerome Ranch
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Single column to multiple columns 5
I copied Visible Cells Only, but it pastes only the first cell 1
Modify Code to work on Sheets with different names 5
Excel Cannot delete empty cells/rows 4
Moving a bunch of data 1
making cells uncopyable 1
Cannot sort blanks to bottom of table 2
Quick way to fill formulas? 2

Back
Top