Un-Merge a merged cell

S

Suil

I have taken a table from a document and transfered it to
Excel. I cells now appear as 3 cells merged into one how
can i bring these back to one cell? There is no need for
3 merged cells as the content of each cell is not big.

Thanking you in advance Suil.
 
B

Bob Umlas

Format/Cells/Alignment tab, uncheck the Merge cells checkbox
If you have XP or later, the toolbar button which merges cells is a toggle
and clicking it again will unmerge them.
Bob Umlas
Excel MVP

I am leading a free 1-hour seminar on the web on Excel tips & tricks.
Tuesday, 9/21, from 3-4PM est.

This is the 2nd one -- the first one filled up (100 people) & is closed.

To sign up, go to http://www.iil.com, click on the orange box on the left
side saying "try a free webinar",
then click "Microsoft Excel 'Tips and Tricks'"
then click the link to sign up.
 

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

Top