Excel Cell alignment

by malthos Jan 24, 2006 8:36PM PST

Howdy everybody,
I use Excel everyday at work, & I prefer to use shortcut keys & hotkeys rather than the mouse, e.g. ctrl + C,V,X or A, alt + tab, winkey + M or L to name a few of the many I employ. Here's something I can't work out:

How do you align the contents of a cell using shortcut keys or hotkeys?

Perhaps there are different combinations or shortcuts for the three alignments, left, right & center, or perhaps there is a single shortcut which you can use and on continuous pressing it will cycle through the alignments.
I realise that this may not actually be possible, but if it is, please help me, I hate having to use the mouse to select one of those buttons.

Discussion is locked

- Collapse -

Re: excel shortcuts

by Kees Bakker Jan 24, 2006 10:33PM PST

http://office.microsoft.com/en-us/assistance/HP052037811033.aspx gives the whole list. And there's no 'alignment' to be found on the page.

However, you'll like the following tip it gives:
"If an action you use often does not have a shortcut key, you can record a macro to create one."

Hope this helps.

Kees

- Collapse -

Allignment as in format cell...

by Papa Echo Jan 25, 2006 5:38PM PST

allignment>Text control ? Warp text, Shrink to fit, merge cells ?

- Collapse -

keystrokes to cell text alignment

by cledwards Jan 28, 2006 2:21AM PST

context key, f, tab - use arrow and enter keys to select alignment options

the context key is between the alt and ctrl keys to the right of the spacebar on full size keyboards

- Collapse -

Alignment

by malthos Jan 29, 2006 5:58PM PST

By alignment I mean text/contents aligned either left right or centre. Using the content key then f is a possibility, but it's really slow. I was hoping that someone might know a quick shortcut or combination, rather than having to bring up the Format Cells Menu.

- Collapse -

No need to bring up...

by Papa Echo Jan 29, 2006 8:38PM PST

the format cell menu. Text allignment can be done at the Formating Toolbar, as in MS Word. It is almost as quick as using short cut or hot keys, if not quicker.

- Collapse -

cell alignment

by linda39 Feb 3, 2006 4:03AM PST

ok. There is another faster way but still through the cell alignment box. There should bea key at the bottom of your keyboard between to the righthand Ctrl and the windows key hit that key when your in the cell you want aligned and then F and the format box will pop up then you tab and use your arrow keys to select your option.

- Collapse -

A way to centralise or left align, but not right align

by richardp123 Jan 30, 2006 8:42PM PST

Hey there,

Not exactly the answer you're looking for I'm afraid (i.e. aren't hotkeys as such) but worth bearing in mind maybe, if the entries you're adjusting are text-only values.

During text value entry into a cell, begin your entry with one of the following characters to force horizontal cell alignment:

' (apostrophe mark) - Left Align
^ (caret/circumflex) - Centre Align
" (quotation/speech mark) - Right Align

cheers
Richard

- Collapse -

Using just the keyboard to do cell alignment in Excel

by linda39 Feb 3, 2006 3:46AM PST

You use Alt/V or Alt/H. This takes you to the toolbar. Use your arrow keys to go to Format. Cell alignment should be the top one. If not, tab down within Format to get to cell alignment Hit Enter. Use arrow keys to go to Alignment tab. Tab down to Horizontal or Vertical. Arrow to go left/right/center ect. Hit enter. Tab again to align the other one. Hit enter and your aligned. Good luck. Let me know if this worked for you.

- Collapse -

Re: alignment using keyboard only

by Kees Bakker Feb 3, 2006 6:10AM PST

Linda,

I still prefer the way Microsoft advised: record a macro (and keep it in personal.xls, your personal macro file). Then, for example, ctrl-shift-R = right align, and same for ctrl-shift-C or ctrl-shift-L. Or use any other shortcut that's free or you don't use and is easy to remember for you.

Recording a macro is fast and easy. No need to know how to program, just point and click and do.

Kees

- Collapse -

Excel Alignment

by hahnwf Feb 26, 2006 3:01PM PST

Dear Sir,

If you do not want to use mouse for aligning cells in excel, do not use mouse. You can align cell in excel with the help of keyboard only. But, for that just press Alt key and then press Ctrl + Tab keys to move among toolbars. Select formating toolbar using this method. Select cell alignment button with the help of arrow keys.

Thanking You,

Vishnu H. Thakor

- Collapse -

marvellous

by richardp123 Feb 27, 2006 3:53AM PST

Only about a month late. Do you work full time for Microsoft support or something?

Excel Cell alignment

CNET Forums

Other Forums

Forum Info