View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
James D. Connelly James D. Connelly is offline
external usenet poster
 
Posts: 7
Default Move to bottom of Column

Nigel

You can do it this way. Select the first cell at the top of your data
column (first cell with Data in it), then press CTRL - Shift - Down Arrow
(all those keys held simultaineously). Then when all the data is
highlighted (as it will be) you can either right mouse click and select
copy, or use the CTRL - INSERT keystroke (both simultainously again) and you
have copied the entire column of data to the clipboard. You then select the
first cell where you want to paste the data (or paste to another
application) same as always.

ONE CAVEAT. You cannot have any empty cells in the data column, so if you
have breaks between data in the column it will only go to the first empty
cell.

James D. Connelly
----------------------------------------
116 Rice Ave
Hamilton, ON L9C 5V9
Phone (905) 575 0284
----------------------------------------
Primary Web Site - http://home.moutaincable.net/~csctraders/cardznutz
Secondary Mirror Site = http://www.freewebs.com/cardznutz
Proud Member of CSCT (Canadian Sports Card Traders) Group
"Nigel" wrote in message
...
There are key combinations to select the the data from a cell to the end

of
the spreadsheet, are there any key combinations to select all the data in

a
colum, not the whole column just down to where the data ends

thanks