Forum Discussion

auraone's avatar
auraone
Copper Contributor
Mar 11, 2023

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.

1 Reply

  • auraone 

    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'.

     

Resources