Shortcut key for aligning data in cell

  • Thread starter Thread starter Sanjay
  • Start date Start date
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.
 
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.
 
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
 
Please note, Gaurav, that this is not a binary newsgroup, so messages here
should NOT have binary attachments.
 
Back
Top