word-excel-access-help.com logo
Microsoft Office Excel
Home
Word 2007
Excel 2007
Access 2007
Word xp
Excel xp
Access xp

Microsoft Office Excel
Additional Resources






Microsoft Office Excel

Microsoft Office Excel XP | Alignment & Text Direction

Microsoft Excel XP logo
Learn step-by-step how to change the vertical and horizontal alignment of your Microsoft Office Excel worksheet cells. Also learn how to change the text direction of cell content.

Excel Office Helper What's on this page...
Cell Alignment
Text Direction
Indent Contents

Cell Alignment

By default, cell contents appear at the bottom, numbers are right-aligned, text is left-aligned, and logical values are centered in cells.

You can apply the most common horizontal alignment options by selecting the cell or range of cells and then using the alignment buttons on the Formatting toolbar.

Microsoft Office Excel: Left, Center and Right alignment buttons Left, Center & Right Alignment buttons

You can also use the Format Cells dialog box to change the vertical as well as the horizontal alignment of the content in the cells.

Vertical alignment is only noticeable once you make the rows taller.

Microsoft Office Excel: Horizontal & Vertical Alignment example


To use the Format Cells dialog box, follow these steps:

1. Select the cell or range of cells to align.
   
2. Choose Format ► Cells from the menu bar, OR press Ctrl + 1.
   
3. Click the Alignment tab in the Format Cells dialog box.
   
  Microsoft Office Excel: Format Cells dialog box - Alignment tab
   
4. Choose the desired horizontal or vertical alignment option from the drop-down lists.
   
5. Click OK.
 
Back to Top
 
Return to Excel XP from Microsoft Office Excel | Alignment"
 
Excel XP Topics
- Tips
- Excel Screen Layout
- Navigational Techniques
- Working with Workbooks
- Templates
- Working with Worksheets
- Moving Around
- Move Worksheets
- Copy Worksheets
- Insert & Delete Cells
- Insert & Delete Rows
- Insert & Delete Columns
- Resize Row
- Resize Column
- Editing Data
- Content Color
- Cell Color
- Number Formats
- Fonts
- Alignment
- Text Direction
- Indent Contents
- Merge Cells
- Copy
- Move
- Undo & Redo
- Using Zoom
- Freeze & Unfreeze Titles
- Split Worksheet
- Spreadsheet Data
- AutoFill
- AutoComplete
- Comment
- Find
- Replace
- Spellcheck
- Formulas
- Functions
- Print
- Password
- Sorting
- AutoFilter
- Advanced Filter
- Macros
- Charts
- Charting
- Charting Elements
- Gantt Chart
- PivotTable
- PivotTable Calculations
- PivotTable Layout
- PivotTable Format
- PDF to Excel
- PDF-to-Excel Converter
- Excel to PDF Converter