If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copying data down 29,000+ cells---Shortcut
I have to copy a cell contents for the entire spreadsheet of 29,000+ rows. I
thought CTRLSHIFTArrow 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 |
#2
|
|||
|
|||
Copying data down 29,000+ cells---Shortcut
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 "PSULionRP" wrote in message ... I have to copy a cell contents for the entire spreadsheet of 29,000+ rows. I thought CTRLSHIFTArrow 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 |
#3
|
|||
|
|||
Copying data down 29,000+ cells---Shortcut
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 On Tue, 10 Nov 2009 19:25:06 -0800, PSULionRP wrote: I have to copy a cell contents for the entire spreadsheet of 29,000+ rows. I thought CTRLSHIFTArrow 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 |
Thread Tools | |
Display Modes | |
|
|