Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Using the keyboard
I need to use the keyboard in Excel rather than the mouse for health reasons.
Does anyone know where I can find a list of keystrokes for Excel commands. I'm not so much looking for keyboard shortcuts, it's for things like accessing the "Name" box (above column 'A'), or filling a series with the keyboard instead of the black +. Any help would be very much appreciated. -- Thanks, Rob E. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Using the keyboard
I cannot think of any way to get to the Name box without a mouse
However, there are many other ways of going things that do not require you to get to the Name box Tell us what operation you need to do with the Name box and we can suggest alternative methods best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Rob E" wrote in message ... I need to use the keyboard in Excel rather than the mouse for health reasons. Does anyone know where I can find a list of keystrokes for Excel commands. I'm not so much looking for keyboard shortcuts, it's for things like accessing the "Name" box (above column 'A'), or filling a series with the keyboard instead of the black +. Any help would be very much appreciated. -- Thanks, Rob E. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Using the keyboard
Sun, 26 Aug 2007 03:08:01 -0700 from Rob E
: I need to use the keyboard in Excel rather than the mouse for health reasons. Does anyone know where I can find a list of keystrokes for Excel commands. I'm not so much looking for keyboard shortcuts, it's for things like accessing the "Name" box (above column 'A'), or filling a series with the keyboard instead of the black +. Instead of mousing into the Name box, use Insert | Name | Define. Instead of mousing on the fill handle, use this from Excel help" "To fill in the active cell with the contents of the cell above it (fill downward), press CTRL+D. To fill in with contents of the cell to the left (fill to the right), press CTRL+R." It will be nasty and repetitive, but it will get the job done. -- "First prove what you're saying, then whine about it." -- /The People's Court/ Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Using the keyboard
To access the name box try Alt + e,g
Gord Dibben MS Excel MVP On Sun, 26 Aug 2007 03:08:01 -0700, Rob E wrote: I need to use the keyboard in Excel rather than the mouse for health reasons. Does anyone know where I can find a list of keystrokes for Excel commands. I'm not so much looking for keyboard shortcuts, it's for things like accessing the "Name" box (above column 'A'), or filling a series with the keyboard instead of the black +. Any help would be very much appreciated. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Using the keyboard
Chip Pearson shows a way using a macro to get to the name box. You could assign
your own shortcut key. http://cpearson.com/excel/NameBoxShortcut.htm And F5 or ctrl-g will show the same name as Edit|goto and ctrl-F3 will show the Insert|Name|Define dialog Chip Pearson shares some shortcut keys: http://www.cpearson.com/excel/ShortCuts.htm And David McRitchie has some he http://mvps.org/dmcritchie/excel/shortx2k.htm Rob E wrote: I need to use the keyboard in Excel rather than the mouse for health reasons. Does anyone know where I can find a list of keystrokes for Excel commands. I'm not so much looking for keyboard shortcuts, it's for things like accessing the "Name" box (above column 'A'), or filling a series with the keyboard instead of the black +. Any help would be very much appreciated. -- Thanks, Rob E. -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Using the keyboard
How about
<F5 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Rob E" wrote in message ... I need to use the keyboard in Excel rather than the mouse for health reasons. Does anyone know where I can find a list of keystrokes for Excel commands. I'm not so much looking for keyboard shortcuts, it's for things like accessing the "Name" box (above column 'A'), or filling a series with the keyboard instead of the black +. Any help would be very much appreciated. -- Thanks, Rob E. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Using the keyboard
And F5 or ctrl-g will show the same name as Edit|goto
should be And F5 or ctrl-g will show the same DIALOG as Edit|goto Dave Peterson wrote: Chip Pearson shows a way using a macro to get to the name box. You could assign your own shortcut key. http://cpearson.com/excel/NameBoxShortcut.htm And F5 or ctrl-g will show the same name as Edit|goto and ctrl-F3 will show the Insert|Name|Define dialog Chip Pearson shares some shortcut keys: http://www.cpearson.com/excel/ShortCuts.htm And David McRitchie has some he http://mvps.org/dmcritchie/excel/shortx2k.htm Rob E wrote: I need to use the keyboard in Excel rather than the mouse for health reasons. Does anyone know where I can find a list of keystrokes for Excel commands. I'm not so much looking for keyboard shortcuts, it's for things like accessing the "Name" box (above column 'A'), or filling a series with the keyboard instead of the black +. Any help would be very much appreciated. -- Thanks, Rob E. -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Using the keyboard
"Stan Brown" wrote ...
Sun, 26 Aug 2007 03:08:01 -0700 from Rob E : I need to use the keyboard in Excel rather than the mouse for health reasons. Does anyone know where I can find a list of keystrokes for Excel commands. I'm not so much looking for keyboard shortcuts, it's for things like accessing the "Name" box (above column 'A'), or filling a series with the keyboard instead of the black +. Instead of mousing into the Name box, use Insert | Name | Define. Instead of mousing on the fill handle, use this from Excel help" "To fill in the active cell with the contents of the cell above it (fill downward), press CTRL+D. To fill in with contents of the cell to the left (fill to the right), press CTRL+R." It will be nasty and repetitive, but it will get the job done. I don't think either solution would work very well for what was asked, since they have more specific uses than was asked for, or more to the point doesn't seem to want to make a permanent name. Chip Pearson has a macro and a suggested shortcut of Ctrl+Shift+N (I was thinking along the lines of Ctrl+M that I used for something of less use) http://www.cpearson.com/excel/NameBoxShortcut.htm My page on keyboard shortcuts is http://www.mvps.org/dmcritchie/excel/shortx2k.htm -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Using the keyboard
sorry Dave, didn't look first, and you didn't miss anything either,
I got hung up on trying to see if I could find the equivalent of Insert|Define|Name on Excel 2007, I tried help. The Excel 2007 Help sets searching back more than a decade considering it is but one small database. "Dave Peterson" wrote... Chip Pearson shows a way using a macro to get to the name box. You could assign your own shortcut key. http://cpearson.com/excel/NameBoxShortcut.htm |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Using the keyboard
Sun, 26 Aug 2007 14:48:03 -0400 from David McRitchie
: The Excel 2007 Help sets searching back more than a decade considering it is but one small database. You mean searching is worse than in Excel 2003 help? Then it must be bad indeed. :-( -- "First prove what you're saying, then whine about it." -- /The People's Court/ Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Using the keyboard
"Stan Brown"
You mean searching is worse than in Excel 2003 help? Then it must be bad indeed. :-( Don't know, was using Excel 2002 and brought up Excel 2007 6 days ago on new computer. |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Using the keyboard
<rant
I have the greatest sympathy for new users trying to solve their problems by searching Excel's Help. When I jumped to Excel 2003, I was shocked at the poor search-result ranking algorithms, not to mention certain entries that looked like they had been written at three in the morning by someone with shaky English. And I sorely missed Question Mark help -- the kind that used to take you to the *exact* entry what you had clicked, and not make you comb through a whole page's worth of explanations. </rant On Aug 26, 8:53 pm, "David McRitchie" wrote: "Stan Brown" You mean searching is worse than in Excel 2003 help? Then it must be bad indeed. :-( Don't know, was using Excel 2002 and brought up Excel 2007 6 days ago on new computer. |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Using the keyboard
That's actually called "Context sensitive help" ("What's This" )
and besides clicking on the [?] in the upper right hand corner was also available Shift+F1, and I think there were other applications that had it and dropped it upon switching to web help files. Excel 2007 Ctrl+F1 show/hide ribbon also available as "minimize ribbon" in dropdown (chevron) upper left corner. It becomes very necessary to learn more keyboard shortcuts, for instance, I never remember Ctrl+1 for the format dialogs but you're going to need to know that one with Excel 2007. Tools menus split up to the four winds (somewhere in Developer Ribbon, somewhere in Office button - Excel options, somewhere in Office left sidebar, somewhere on another Ribbon, and if you guess wrong then start over again) "David Hilberg" wrote in message ps.com... <rant I have the greatest sympathy for new users trying to solve their problems by searching Excel's Help. When I jumped to Excel 2003, I was shocked at the poor search-result ranking algorithms, not to mention certain entries that looked like they had been written at three in the morning by someone with shaky English. And I sorely missed Question Mark help -- the kind that used to take you to the *exact* entry what you had clicked, and not make you comb through a whole page's worth of explanations. </rant On Aug 26, 8:53 pm, "David McRitchie" wrote: "Stan Brown" You mean searching is worse than in Excel 2003 help? Then it must be bad indeed. :-( Don't know, was using Excel 2002 and brought up Excel 2007 6 days ago on new computer. |
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Using the keyboard
Last decent help in Excel was 97, then they gradually became less good
although worse might be a better word. -- Regards, Peo Sjoblom "David Hilberg" wrote in message ps.com... <rant I have the greatest sympathy for new users trying to solve their problems by searching Excel's Help. When I jumped to Excel 2003, I was shocked at the poor search-result ranking algorithms, not to mention certain entries that looked like they had been written at three in the morning by someone with shaky English. And I sorely missed Question Mark help -- the kind that used to take you to the *exact* entry what you had clicked, and not make you comb through a whole page's worth of explanations. </rant On Aug 26, 8:53 pm, "David McRitchie" wrote: "Stan Brown" You mean searching is worse than in Excel 2003 help? Then it must be bad indeed. :-( Don't know, was using Excel 2002 and brought up Excel 2007 6 days ago on new computer. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Format Painter - Keyboard Shortcut doesn't work! | Excel Discussion (Misc queries) | |||
Keyboard remapping using pivot tables in excel 2003 on laptop | Excel Discussion (Misc queries) | |||
Keyboard will no work in Excel 2003 | Excel Discussion (Misc queries) | |||
What is the keyboard shortcut to insert a bullet in Excel 2003? | Excel Discussion (Misc queries) | |||
Why Excel 2003 is so slow on keyboard kursor inputs? | Excel Discussion (Misc queries) |