Mystery Cell

[Maxiron]

Hello all. I have a document that has boxes that I can't figure out. The boxes act like a regular cell but they overlay all the "base" cells in the book. I can add text and formulas into these cells. I can move them around but not place them over another (I get a "We can't do that to a merged cell." banner. I cannot resize/reshape them in any way...there isn't an option when I right-click to get the banner or on the ribbon bar. I cannot highlight and press the delete button to get rid of them....I have to open a range of base cells around this overlay cell and 'shift row up' to basically delete it from the page.

I like using these boxes but I don't know what they are or how to make new ones. I've been searching online for days and can't find any video or write-up on what these are and how to make them. Any help please?

 

[davesexcel]

Are they merged cells?

 

[Maxiron]

I would guess they are but what puzzles me is how they overlay the base cell layout. The originator compressed the entire book into compact columns and rows. These boxes are on top of these compact rows/columns.

 

[davesexcel]

You can use the snipping tool, copy and paste the picture into your post.

For example

 

[Fluff]

If you select "design mode" on the Developer tab of the ribbon & then click on one of these "cells" do you see something like

 

[Maxiron]

I did have a pic but here is one...

 

[Maxiron]

Fluff, I tried that originally but to answer you, no. I don't get any kind of border control to resize the box. I do get a green highlight border with a pull-down/right button which adds another cell up, down, right left...(just like if I had a formula in a cell and pulled it down to sequence more cells below).

 

[Maxiron]

davesexcel, your reply is the key! They are merged. I went back and saw the drop-down on the "merge & center" and saw the unmerge cells. THAT WAS IT! I was so stuck on the fact that it looked layered or something. I feel like a fool.

Thanks for the replies guys.