Excel’s Table object, while powerful, does have a few limitations. For that reason, I’d like to introduce one more possibility — one that’s more difficult to implement after the fact.

How to Keep Excel From Expanding Cells When Sorting. ... Click the "AutoFormat as You Type" tab. Remove the check box next to the "Include New Rows And Columns In Table" option.

A pivot table is a must-have tool for power Excel users. It lets you see the bigger picture, where you can make sense of ...