Changing Object View Settings

After drawing or inserting different types of objects on your worksheet, you might find it difficult to work with the information on the worksheet. You can change view settings in Excel to show or hide objects on your worksheets. You can also show objects as placeholders . A placeholder is an empty box that takes the place of the object.

Change View Settings for Objects

Click the Tools menu, and then click Options.

Click the View tab.

Click the view setting options you want.

Click OK.