+ Reply to Thread
Results 1 to 4 of 4

combined cells

  1. #1
    Registered User
    Join Date
    02-06-2008
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    71

    combined cells

    two cells, one on top of the other have become one cell and i cannot figure out how to make them back into two separate cells.

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: combined cells

    they weren't merged were they?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: combined cells

    Most likely two cell are merged and you need to unmerge them. You can do this by clicking on Merge and Center and select Unmerge
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: combined cells

    Select the cell(s)

    Right click>Format Cells>Alignment tab>uncheck: Merge cells>OK out
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to return with combined value from different cells with same name?
    By dshwangbo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-19-2013, 06:03 AM
  2. [SOLVED] Combine cells to have all possibilities of the combined cells
    By soroh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-30-2012, 04:46 AM
  3. Reading combined cells
    By brunobene in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2012, 11:18 AM
  4. [SOLVED] Formatting combined Cells
    By [email protected] in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-05-2005, 12:06 PM
  5. Formatting Combined Cells
    By Betty Csehi in forum Excel General
    Replies: 5
    Last Post: 03-29-2005, 10:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1