Are there shortcut keys in Excel for Cell Alignment?

M

Meg

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!
 
M

Meg

Thanks for the link, Dave! Kind of a bummer, but I guess I'll have to Build
My Own!

Appreciate it!
 
D

Dave Peterson

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.)
 
R

Red.MnM

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
 
I

Iqbal

Press Alt and then press Ctrl+tab twice, and then use the right arrow key to
move along.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top