Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2777

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2791

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2777

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2791

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2777

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2791

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2777

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2791
MS Excel 2007 Lecture # 12
  • The Facebook Platform

Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2010
    Location
    Lahore, Pakistan
    Age
    25
    Posts
    3,818
    Points
    6,772.51
    Rep Power
    10000

    Default MS Excel 2007 Lecture # 12

    Excel Alignment - Effectively Used the Formatting Options Available in Excel 2007


    The options allow you to change alignment of the text in a cell or cells, text orientation, merge several cells together and so on.
    For more alignment options, you can click on the Alignment group dialog box launcher to display the Format Cells dialog box.

    Name:  excel-alignment-group.gif
Views: 274
Size:  3.1 KB

    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

    Name:  excel-alignment-orientation.gif
Views: 334
Size:  7.3 KB

    • 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:

    Name:  excel-wrap-text.gif
Views: 307
Size:  4.9 KB
    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


    Name:  format-cells-dialog-box.jpg
Views: 346
Size:  23.4 KB


    • 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.
    Find Me On Social Networks

    Facebook | Twitter | Google+



 

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •