How do I unmerge cells?

G

GregB

I need to unmerge cells - went to format cells, alignment, but merge cells
box is unchecked already - just highlighted.
 
R

Rick Rothstein \(MVP - VB\)

Just like any other formatting option, you have to select the merged cell(s)
before going to the Format Cells dialog.

Rick
 
S

Sandy Mann

Perhaps they are not merged, perhaps they have been "Center across
Selection" in the Horizontal selection box of the alignment dialog.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

unmerge cells 6
How do I locate merged cells in my Excel worksheet? 7
Merge Cell Cut & Paste 1
Deleting blank cells AFTER an UNMERGE 1
How do you unmerge cells 1
Problems sorting spreadsheet - Please Help 6
Pasting into merged cells 1
Retain value of merged cell in all unmerged cells 3

Top