"Cannot change part of merged cell"

  • Thread starter ExcelHelpNeeded
  • Start date
E

ExcelHelpNeeded

Need help!

I have created a pivot table in Excel and now trying to add another field
that appears in the field list. When I drag it over the pivot table to drop
it, I get this error: "cannot change part of merged cell", I did not receive
this error message for the other fields that I had selected.

Please help. Thanks in advance.
 
S

silver

ExcelHelpNeeded said:
Need help!

I have created a pivot table in Excel and now trying to add another
field
that appears in the field list. When I drag it over the pivot table to
drop
it, I get this error: "cannot change part of merged cell", I did not
receive
this error message for the other fields that I had selected.

Please help. Thanks in advance.
Click to expand...

Is it indeed merged? Click on the cell you're wanting to paste to, go
to Format Cells then Alignment and uncheck the Merge box.
 
Top