Home
MS Office - How to ?
Excel Tutorials
Word Tutorials
PowerPoint Tutorials
Free e-books
VIDEO Tutorials
Office 2007 Guides
Excel 2007 Tutorials
PowerPoint 2007 Guides
Word 2007 Tutorials
MS Office Template
Free Clip Art
Keyboard Shortcut
Tips and Tricks
MS Outlook
MS Publisher
Free Newsletter
MS Windows
Contact Us
Site Map
Google Docs and ...
You and This Site
Resources Page

XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google
 


Excel Alignment Formatting


The Excel alignment formatting options are contained within the Alignment group on the Home tab. For more alignment options, you can click on the Alignment group dialog box launcher to display the Format Cells dialog box.

excel alignment group



To align data between the left and right sides of a cell

  • Select the cell, or cells, you wish to align.
  • On the Home tab, in the Alignment group, click the Align Text Left icon to align data with the left edge of the cell.
  • Click on the Center icon to center data in the cell.
  • Click on the Align Text Right icon to align data with the right edge of the cell.

    To align data between the top and bottom of a cell

  • Select the cell, or cells, you wish to align.
  • On the Home tab, in the Alignment group, click the Top Align icon to align data in the top position of the cell.
  • Click on the Middle Align icon to centralized data vertically in the cell.
  • Click the Bottom Align icon to align data in the bottom position of the cell.

    To change the orientation of data cells

  • Select the cell, or cells, you wish to change.
  • On the Home tab, in the Alignment group, click the Orientation icon. You will see a drop down menu allowing you to format the cell orientation.

    excel alignment orientation


  • Select any one of the command. Experiment with applying some of the other orientation effects.

    To wrap multiple lines of data in a cell

  • Type the text ‘The Ultimate Guide to Excel 2007’ into the cell C5 and press Enter. The entry will appear as one long line that does not ‘fit’ into the cell.
  • Select the cell C5 and then on the Home tab, in the Alignment group, click the Wrap Text icon. The text will wrap as follow:

    excel wrap text


    To merge several cells

  • Select the cells that you wish to merge to become one cell.
  • On the Home tab, in the Alignment group, click the Merge & Center icon.

    To shrink the text into one cell

  • Type the data you require into the cell and press Enter.
  • Right-click on the selected cells, click Format Cells.

    Excel format cells dialog box


  • From the Format Cells dialog box displayed, click on the Alignment tab.
  • Under the Text control section, tick the Shrink to fit check box and click on OK.

    Note: You can also use this right-click method to do the wrap text and merge cells.

    Get FREE ebooks!
    (Click for more info)

    Subscribe to...
    MS Office Tips Newsletter

    E-mail Address:
    First Name:
    Then

    Don't worry -- your e-mail address is totally secure.
    I promise to use it only to send you MS Office Tips.


    Can't find what you're looking for? Try Google Search!

    Google
     

    Back to Top


    Recommended book:

    Revealed! 101 Excel Secrets Revealed! 101 Excel Secrets


    You're viewing the Excel alignment info page, click here to go back to the Home Page


    footer for excel alignment page