Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcut keys for copying data down 29,000+ cells
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcut keys for copying data down 29,000+ cells
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 PSULionRP wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcut keys for copying data down 29,000+ cells
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) PSULionRP wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying data down 29,000+ cells---Shortcut | Excel Discussion (Misc queries) | |||
Shortcut Keys - Insert Copied Cells | Excel Discussion (Misc queries) | |||
Shortcut Keys ? | Excel Discussion (Misc queries) | |||
shortcut keys | Excel Discussion (Misc queries) | |||
Selecting cells using shortcut keys not mouse | Excel Discussion (Misc queries) |