Email
Share

We Rock Your Web Forum » Software » Office Applications

Excel 2010 - Merge Cells?

(4 posts)
  1. JeffNox

    member
    Joined: Aug '09
    Posts: 24

    How do I merge cells in Excel 2010? I'm used to doing it in open office, where you can simply highlight two cells and then merge them. For the life of me I can't find this option in the new Excel 2010 menu?

    Posted 1 year ago #

  2. Posted 1 year ago
  3. cwd

    senior admin
    Joined: Jul '09
    Posts: 225

    You can merge cells by using the concatenate command as follows:

    CONCATENATE(A1,” ”, A2)

    In this case we insert a " " (space" in between the content, so the merged content doesn't get squished together. The content in cells A1 and A2 is merged (concatenated).

    Posted 1 year ago #
  4. Anonymous



    you can watch this tutorial, its very simple to do:

    http://www.thebestdata.com/zoom.aspx?menutype=1&auto=2189

    <a href="http://www.thebestdata.com/zoom.aspx?menutype=1&auto=2189" >
    Merge cells in Excel 2010
    </a>

    Posted 9 months ago #
  5. Anonymous



    Highlight the cells you want to merge, right-click, choose the Format Cells option, then choose the Alignment tab, then tick the Merge Cells box.

    Posted 8 months ago #

RSS feed for this topic

Reply

(required)

Allowed markup: BBcode blockquote code em strong ul ol li font strike center u hr.
You can also put code in between backtick ( ` ) characters.