How does one see a merged cell?

K

kevs1

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

I can't sort becuase my some cells have been merged by an intern.
The workbook rows and columns look perfect to me. How can I track down these rogue merged cells? thanks.
 
B

Bob Greenblatt

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

I can't sort becuase my some cells have been merged by an intern.
The workbook rows and columns look perfect to me. How can I track down these
rogue merged cells? thanks.
Click to expand...
One way would be to select all the cells by clicking on the diamond at the
intersection of the row and column headings. The go to Format Cells and
select alignment. Then click the merge cells box until it is clear. Then
press OK.
 

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

Column of Names upper case: I wanted upper lower 5
Spreadsheet dimensions 2
Why rows get larger when move a column? 1
identically sizing cells 1
How to "return" in a merged cell. 3
cell display 2
Pasted text going into other cells 7
What are these sort triangles and the border? 4

Top