Shortcut keys for copying data down 29,000+ cells

P

PSULionRP

I have to copy data cell contents down my entire spreadsheet of 29,000+ rows.
What are the short cut keys for highlighting all 29,000+ rows in order to
copy the data down all 29,000+ rows??? I thought the shortcut keys were
<CTRL><SHIFT><Down-Arrow> to highlight all rows being used, but this
highlighted the cells in al 65,536 rows. Can anyone help me with the shortcut
keys so that I don't have to sit here holding my mouse button down to
highlight all these rows???

Thanks for your review. And hopeful for a reply.

PSULionRP
 
D

Dave Peterson

Shortcut keys for selection depend on the data and the location of the active
cell--and the data around that cell.

I like to find the bottom right corner using ctrl-end and then use
ctrl-shift-home to select A1 (or the top left corner if I'm using freeze panes
and then ctrl-shift-up, ctrl-shift-left to get to the cell I want).

If ctrl-end takes you too far past what you believe is the last used cell, you
could try resetting that last used cell using techniques at Debra Dalgleish's
site:

http://contextures.com/xlfaqApp.html#Unused
 
B

Bob I

If you know the last cell you just put it in the Address box in upper
left of sheet area. Example 1:25235 (leave off the letters of columns)
 

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

Top