Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Hiding Graphic Objects in Excel 2007

The Selection and Visibility task pane in Excel 2007 enables you to control whether various graphic objects in the worksheet are hidden or displayed. Hiding objects can make it easier to select other objects that are hidden or partially hidden behind them.

The way you open the Selection and Visibility task pane depends on the type of graphic object you’ve selected in the worksheet:

  • Charts: Click the Selection Pane button in the Arrange group of the Chart Tools Format tab.

  • Text Boxes and Shapes: Click the Selection Pane button in the Arrange group of the Drawing Tools Format tab.

  • Clip Art and Pictures: Click the Selection Pane button in the Arrange group of the Picture Tools Format tab.

  • SmartArt: Click Selection Pane button in the Arrange group of the SmartArt Tools Format tab.

After you open the Selection and Visibility task pane, you can temporarily hide any of the graphic objects listed by clicking its eye check box (to remove the eye icon). To remove the display of all the charts and graphics in the worksheet, click the Hide All button at the bottom of the Selection and Visibility task pane instead.

Use the Selection and Visibility task pane to hide graphic objects in the worksheet.
Use the Selection and Visibility task pane to hide graphic objects in the worksheet.

To redisplay a hidden graphic object, simply click its empty eye check box to put the eye icon back into it. To redisplay all graphic objects after hiding them all, click the Show All button at the bottom of the task pane.

blog comments powered by Disqus
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!