If you are using Office 2013 and above just tick show All objects.Ĥ. Then, check the box to enable the placeholder. Locate the show placeholders feature under advanced options, use the check box next to it to control whether excel uses the placeholder. by clicking on the Option button on this screen.ģ. Once you've open the more options button, you'll be able to see the options then open the option dialogue box. Choose More options from the Tools menu.Ģ. Locate and click on the Tools menu on your excel screen. To turn on placeholders, follow the following steps:ġ. To use this feature of excel placeholder, the user is required to turn it on first. This means that excel does not have to redisplay the complete graphic, and therefore your graphic will be much faster.

This defect can, however, be controlled by the use of placeholders. If you are working with a big worksheet with many graphics or working on a document that the user can add and delete previous details, excel slows in its operation and displays the graphics. Placeholders can be easily created on excel.

How to insert a citation placeholder