Turning on Placeholders

If you are working with a large worksheet that has a large number of graphics, you may have noticed that Excel slows down quite a bit when displaying the graphics. This can be particularly distracting, especially if your graphics are quite detailed or are being loaded across a busy network connection.

You can speed up the display of your worksheet by using placeholders. This results in Excel displaying boxes where your graphics would normally appear. This means that Excel does not have to redisplay the complete graphic, and therefore your display will be much faster. To turn on placeholders, follow these steps:

1. Choose Options from the Tools menu. You will see the Options dialog box.
2. Click on the View tab. (Click here to see a related figure.)
3. Use the Show Placeholders check box to control whether placeholders are used by Excel. Click on the check box to turn the capability on and off; a check in the box means placeholders are enabled.
4. Click on OK.