LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 33
Default Copying data down 29,000+ cells---Shortcut

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shortcut for copying the cell above sophie_b Excel Discussion (Misc queries) 4 January 8th 08 12:21 AM
copying data to different Cells Auz Excel Worksheet Functions 1 April 28th 06 02:28 PM
Shortcut in copying a formula that links 2 workbooks cthanson Excel Discussion (Misc queries) 0 April 26th 06 03:56 PM
Shortcut for copying formulas referencing different worksheets bhigdon Excel Discussion (Misc queries) 1 July 1st 05 11:09 PM
Is there a quick shortcut to swap the data in two cells? eburris Excel Discussion (Misc queries) 1 January 13th 05 11:38 PM


All times are GMT +1. The time now is 05:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"