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.

"Sanjay" wrote in message
...
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.

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


On Tue, 15 Jul 2008 04:50:01 -0700, Sanjay
wrote:

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.

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

"Gaurav" wrote in message
...
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.

"Sanjay" wrote in message
...
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.