Are there shortcut keys in Excel for Cell Alignment?
I'm heavy on the keyboard shortcuts, and I hate having to switch over to the
mouse to align the text inside my cells? Does anyone know if there are shortcut keys for alignment in Excel? I couldn't find them in the MS Office help, neither on-line or in Excel. Thanks! |
Are there shortcut keys in Excel for Cell Alignment?
Thanks for the link, Dave! Kind of a bummer, but I guess I'll have to Build
My Own! Appreciate it! "Dave F" wrote: http://www.bettersolutions.com/excel...T216312221.htm Scroll to the bottom; there don't seem to be any shortcuts. Maybe you can program one? "Meg" wrote: I'm heavy on the keyboard shortcuts, and I hate having to switch over to the mouse to align the text inside my cells? Does anyone know if there are shortcut keys for alignment in Excel? I couldn't find them in the MS Office help, neither on-line or in Excel. Thanks! |
Are there shortcut keys in Excel for Cell Alignment?
If you toggle a setting, you can use special characters when you enter the text.
Tools|Options|transition tab|check Transition navigation keys ^asdf (will center asdf in the cell) "asdf (will right justify asdf in the cell) I'd uncheck that setting when I was done with the data entry. It changes the behavior of other keys. (Try Home and ctrl-Home, for example.) Meg wrote: I'm heavy on the keyboard shortcuts, and I hate having to switch over to the mouse to align the text inside my cells? Does anyone know if there are shortcut keys for alignment in Excel? I couldn't find them in the MS Office help, neither on-line or in Excel. Thanks! -- Dave Peterson |
Are there shortcut keys in Excel for Cell Alignment?
You can use Ctrl+1 which will take you to the "Format Cells" box and then
Ctrl+PgDown will take you to the "Alignment" tab and then you can just tab thru to the different alignment positions. Red.MnM "Meg" wrote: I'm heavy on the keyboard shortcuts, and I hate having to switch over to the mouse to align the text inside my cells? Does anyone know if there are shortcut keys for alignment in Excel? I couldn't find them in the MS Office help, neither on-line or in Excel. Thanks! |
Are there shortcut keys in Excel for Cell Alignment?
Press Alt and then press Ctrl+tab twice, and then use the right arrow key to
move along. "Red.MnM" wrote: You can use Ctrl+1 which will take you to the "Format Cells" box and then Ctrl+PgDown will take you to the "Alignment" tab and then you can just tab thru to the different alignment positions. Red.MnM "Meg" wrote: I'm heavy on the keyboard shortcuts, and I hate having to switch over to the mouse to align the text inside my cells? Does anyone know if there are shortcut keys for alignment in Excel? I couldn't find them in the MS Office help, neither on-line or in Excel. Thanks! |
All times are GMT +1. The time now is 03:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com