Copying data down 29,000+ cells---Shortcut

P

PSULionRP

I have to copy a cell contents for the entire spreadsheet of 29,000+ rows. I
thought <CTRL><SHIFT><Arrow down key> would highlight all the cells for the
29,000+ rows that contain data. But this instead took me to the end 65,536.
What are the shortcut keys for highlighting the cells for just these 29,000+
rows to copy the data rather then sitting on my cursor and highlighting all
the rows???

Thanks for your review and hopeful for a reply.

Thanks!

PSULionRTP
 
L

L. Howard Kittle

Hmmmm,

Ctrl+Shift+Down Arrow works for me...???? Excel 2002.

Of course this is no help for you, but that's the drill for what you ask.

Regards,
Howard
 
G

Gord Dibben

If the column is blank, ctrl + shift + downarrow will select to row 65536

With data in A1 I would type A1:A29000 and Enter in name box.

CTRL + D to copy down.


Gord Dibben MS Excel MVP
 

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