Forum Discussion
Excel filter
Hey, I'm new to excel. Is there a way to filter a table without hiding other shapes and textboxes outside the table? I'm trying to get a shape to show up when I use a table text filter.
Right-click each of the shapes and text boxes in turn, and select Format Shape... from the context menu.
Click the Size & Properties button:
If necessary, expand Properties, then select 'Don't move or size with cells'.