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 # 16
  • 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 # 16

    How to Merge Cells in Excel 2007 and Vice-Versa?


    Name:  sample-worksheet.gif
Views: 265
Size:  9.0 KB

    If you look at Row 2, you'll see that the "Items Price" heading stretches across three cells. This is not three separate cells, with a color change for each individual cell. The B2, B3 and B4 cells were merged.
    To merge cells in Excel 2007


    • Type the words "Items Price" into cell B2 of a spreadsheet.
    • Highlight the cells B2, B3 and B4
    • On the Home tab, in the Alignment group, locate the Merge and Center icon.
    • Click the down arrow to see the following options:

    Name:  excel-2007-merge-and-center.gif
Views: 616
Size:  10.0 KB

    • Click on Merge & Center. The three cells will then become one - B2, to be exact!


    To unmerge cells in Excel 2007








    • Click on the cell B2 (the cell that merged before).
    • On the Home tab, in the Alignment group, click on the down arrow next to the Merge and Center icon.
    • Select Unmerge Cells. The cell B2 is now separated into 3 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
  •