| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keyboard Shortcuts
Rather than holding my mouse button and scrolling down to copy a formula to
cells, isn't there a keyboard shortcut that will highlight only the cells with data to copy the formula to??? <CTRL+<SHIFT+<down arrow takes me to end of the worksheet. I only want to go down as far as I have data. Any help would be greatly appreciated. Thanks. wnfisba |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keyboard Shortcuts
<CTRL+<SHIFT+<END takes you to the end of your data, not the spreadsheet.
-- Hope this helps. Matt S. "wnfisba" wrote: Rather than holding my mouse button and scrolling down to copy a formula to cells, isn't there a keyboard shortcut that will highlight only the cells with data to copy the formula to??? <CTRL+<SHIFT+<down arrow takes me to end of the worksheet. I only want to go down as far as I have data. Any help would be greatly appreciated. Thanks. wnfisba |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keyboard Shortcuts
AWESOME!
Thanks Matt...Sorry I wasted your time...Usually don't bring such trivial things to the Newsgroup...just couldn't remember that.... "Matt" wrote: <CTRL+<SHIFT+<END takes you to the end of your data, not the spreadsheet. -- Hope this helps. Matt S. "wnfisba" wrote: Rather than holding my mouse button and scrolling down to copy a formula to cells, isn't there a keyboard shortcut that will highlight only the cells with data to copy the formula to??? <CTRL+<SHIFT+<down arrow takes me to end of the worksheet. I only want to go down as far as I have data. Any help would be greatly appreciated. Thanks. wnfisba |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keyboard Shortcuts
no prob, not a waste of time, always happy to help
-- Matt S. "wnfisba" wrote: AWESOME! Thanks Matt...Sorry I wasted your time...Usually don't bring such trivial things to the Newsgroup...just couldn't remember that.... "Matt" wrote: <CTRL+<SHIFT+<END takes you to the end of your data, not the spreadsheet. -- Hope this helps. Matt S. "wnfisba" wrote: Rather than holding my mouse button and scrolling down to copy a formula to cells, isn't there a keyboard shortcut that will highlight only the cells with data to copy the formula to??? <CTRL+<SHIFT+<down arrow takes me to end of the worksheet. I only want to go down as far as I have data. Any help would be greatly appreciated. Thanks. wnfisba |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| customize keyboard shortcuts | Excel Discussion (Misc queries) | |||
| customizing keyboard shortcuts | Excel Discussion (Misc queries) | |||
| customize keyboard shortcuts | Excel Discussion (Misc queries) | |||
| customize keyboard shortcuts | Excel Discussion (Misc queries) | |||
| How do I display all assigned keyboard shortcuts? | New Users to Excel | |||
Linear Mode
