ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Are there shortcut keys in Excel for Cell Alignment? (https://www.excelbanter.com/excel-discussion-misc-queries/105637-there-shortcut-keys-excel-cell-alignment.html)

Meg

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!

Meg

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!


Dave Peterson

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

Red.MnM

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!


Iqbal

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