You are currently viewing How to create a placeholder in excel

How to create a placeholder in excel

Placeholders can be easily created on excel. 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. This defect can, however, be controlled by the use of placeholders. This means that excel does not have to redisplay the complete graphic, and therefore your graphic will be much faster.

To use this feature of excel placeholder, the user is required to turn it on first. To turn on placeholders, follow the following steps:

1. Locate and click on the Tools menu on your excel screen. Choose options from the Tools menu.


2. Once you've open the options button, you'll be able to see the options dialogue box. Then, click on the View button on this screen.

3. Locate the show placeholders feature, use the check box next to it to control whether excel uses the placeholder. Then, check the box to enable the placeholder. If you are using Office 2013 and above just tick show All objects.

4. Finally, click the "OK" button to save changes. Thus, you can comfortably proceed and create placeholders on your document.

Once you've turned on the placeholder's features, creating a placeholder on your document is now pretty easier. You need to follow the few steps discussed below.


Steps involved in creating a placeholder in excel:

1. Click on the excel application icon to open it. Then, locate on your storage the document you wish to add the placeholder. Alternatively, you can click the tool menu on the top-left part of the screen to add a new document.

2. Then, click on the Developer bar, located at the top of the page. Then, locate and click on the Macros button, which is under the code section. However, you can override this step by using excel's shortcut to access the macros (alt+F11). This feature makes the operation easier.

3. Set the name of the macro project and hit the "create" button. Ensure you set the "Macros in" setting to "all open worksheets" to enable access to all the worksheets you are working on.

4. Click on the insert tab followed by a module button to insert a module.

5. Write the code shown in the image below into the module. Replacing the "address" word in both lines with the cell address that must have the placeholder and replace the "Test" word with the placeholder. Then, copy the code.

6. Click the file bar followed by the save button (ctrl+s). To save the module and then close the module.

7. Open the worksheet by double-tapping the sheet's name on the VBA window's left side. Paste the copied code on this page.

8. Save the module and close the Macro page. Thus, the placeholder will be created on your sheet. Go back to your sheet and run the macro to load the placeholder.