Those. Can I hide the B2:D4 cells so that the B1,C1,D1,A2,A3,A4 cells remain visible. Those. I need to hide B2:D4 , but so that it does not affect the size, visibility, appearance of the surrounding cell vertically or horizontally.

I know it sounds a little different from how the tables work, nonetheless.

The point, in fact, is that I have several sheets, and on one of them I need to add controls (drop-down lists, mostly) when I click on the 'Add' button. You can do this dynamically, but this is due to a bunch of macros and the cells on the final sheet refer to these cells. Moreover, when adding controls, I also need to 'add' fields to the final sheet. At the same time, under the fields on the final sheet (and also on the left and on the right) there are still other filled cells. Therefore, an idea came to my mind: to add it all at once, but first to hide it, so that later I could show it as needed. If there is a better solution, I will gladly accept it.

    1 answer 1

    It does not work out. take a leaf into the cell and try to hide such a range.

    The idea is initially wrong. Need to change the approach.

    this is due to a bunch of macros and these cells are referenced by fields on the final sheet.

    If VBA is used, you can generally exclude references in cells, counting everything in the code or using sheet events.

    It is possible to work around: the values ​​in the range are temporarily not displayed, closed by any object ... But these are crutches. More correctly - to solve the problem more correctly)