Merged Cells and Copying Problems

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Hi,
Has anyone got a way of finding merged cells in a
spreadsheet and restoring them to normal cells?
When I try to copy part of the spreadsheet into another
spreadsheet I get an error message about merged cells and
the destination being the same shape. Tried running the
cursor down the columns to find merged cells (they show up
as a different width) but with no result.
Maybe some formula that looks for merged cells?

Thanks for your help.

Paul
 
Hi
one (lazy) way:
- select the entire spreadsheet / or the rows/columns of interest
- goto 'Format - Cells - alignment' and uncheck 'Merge cells'
 
Paul
To add to Frank's response: Think of merged cells as having advanced
plague. Don't even thing of putting them in your spreadsheet. They come
with a lot of baggage as you just found out. HTH Otto
 
Back
Top