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
#AI formula generation techniques
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel
#tables
#spill array
#auto fill
#expand rows
#expand columns
#range
#functionality
#modification
#properties
#hidden column
#formula
#workaround
#specific tables
#undo