1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Is there a way to stop only specific excel tables from automatically adding columns (but not rows)?

I want to place a spill array in the column right next to the table, but whenever I do that I have to undo both the auto fill and the table automatically expanding its range to include that spill formula. Naturally that's pretty annoying, but I do want to keep that functionality otherwise. However, I would like to maintain the table's functionality to expand rows, and I don't want to prevent other tables from expanding both rows and columns

I get the feeling I can't even modify specific tables with what I want, but I figured I would ask anyway. I'm aware of the workaround of adding a hidden column in between my formula and the table, but I'd prefer to modify the table's properties directly.

submitted by /u/I_P_L
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com