Please Note: This article is written for users of the following Microsoft Excel versions: 2007 and 2010. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Hiding Graphics when Filtering.
by Allen Wyatt
(last updated July 4, 2016)
James has a worksheet that has graphics on top of cells that explain what is in the cells. The graphics sort with the cells just fine, but when he applies filters to the cells, the graphics bunch up at top of cells that are visible. James wonders if there is a way to have graphics hide when filtering data within cells.
The answer has to do with how you have the properties for the graphics set up. You need to make sure that the graphics are set to resize when the row height changes. Here's what you do:
Figure 1. The Properties tab of the Size and Properties dialog box.
It is step 5 that does the trick here. Since your graphics are sorting properly when you sort the worksheet, chances are good that you had the Move but Don't Size with Cells check box selected. This is what caused the graphics to bunch up—they couldn't resize when filtering hid the rows with which they were associated.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (11763) applies to Microsoft Excel 2007 and 2010. You can find a version of this tip for the older menu interface of Excel here: Hiding Graphics when Filtering.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!
A common way of representing data is to use a Venn diagram. Unfortunately, Excel doesn't have a precise way of creating ...Discover More
Macros are a great way to process information in a worksheet. Part of that processing may involve moving graphics around ...Discover More
Need to make sure that someone cannot delete a graphic in a worksheet? The ability to protect the graphic depends on ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.