Shortcut key for aligning data in cell

S

Sanjay

Hi all,
Can anybody let me know the shortcut key to align the data in cell in excel.
i.e. how to make left/center/right align by using shortcut keys.

Thanking you
Sanjay.
 
G

Gaurav

a.. To quickly left-align, center, or right-align your data, click Align
Left , Center , or Align Right on the Formatting toolbar (toolbar: A bar
with buttons and options that you use to carry out commands. To display a
toolbar, press ALT and then SHIFT+F10.). To quickly increase or decrease the
data indentation, click Increase Indent or Decrease Indent .
b.. To center or align data that spans several columns or rows, such as
column and row labels, first merge (merged cell: A single cell that is
created by combining two or more selected cells. The cell reference for a
merged cell is the upper-left cell in the original selected range.) a
selected range of cells. Then you can select the merged cell and reposition
the text as described in the preceding steps. For information about how to
merge cells, click Merge or split cells or cell contents.
 
G

Gord Dibben

Alt + o,e............let go Alt key ,arrow to Alignment tab

Alt + h.........let go Alt key, arrow to desired option then ENTER, ENTER

Aren't you glad you asked<g>


Gord Dibben MS Excel MVP
 
D

David Biddulph

Please note, Gaurav, that this is not a binary newsgroup, so messages here
should NOT have binary attachments.
 

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