Shortcut key for aligning data in cell
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. |
Shortcut key for aligning data in cell
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. |
Shortcut key for aligning data in cell
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. |
Shortcut key for aligning data in cell
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. |
All times are GMT +1. The time now is 07:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com