ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I unmerge cells? (https://www.excelbanter.com/excel-discussion-misc-queries/196361-how-do-i-unmerge-cells.html)

GregB

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

Rick Rothstein \(MVP - VB\)[_990_]

How do I unmerge cells?
 
Just like any other formatting option, you have to select the merged cell(s)
before going to the Format Cells dialog.

Rick


"GregB" wrote in message
...
I need to unmerge cells - went to format cells, alignment, but merge cells
box is unchecked already - just highlighted.



Peo Sjoblom[_2_]

How do I unmerge cells?
 
Click twice in the check box

--


Regards,


Peo Sjoblom

"GregB" wrote in message
...
I need to unmerge cells - went to format cells, alignment, but merge cells
box is unchecked already - just highlighted.




Sandy Mann

How do I unmerge cells?
 
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


Replace @mailinator.com with @tiscali.co.uk


"GregB" wrote in message
...
I need to unmerge cells - went to format cells, alignment, but merge cells
box is unchecked already - just highlighted.





All times are GMT +1. The time now is 06:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com