Did you know you can add a background image to your excel data? Excel has unique features that allow its users to insert a background image on their data. The background image helps in making the data have an interesting.
Two methods can be used to insert a background image on your Excel document. These are;
- Using the excel background feature
- Using the Kutools Add-ins feature
Let's discuss each of the above methods.
Using the Excel background feature
Using the Excel background feature is one of the simplest and most commonly used methods. However, when this method is used, some workaround and steps are involved. Here are the steps to be followed;
1. Open your Excel application, and then open a new document or an existing one that you want to add a background image.
2. Then, on the top bars, click on the "Page Layout" tab.
3. From the "Page set-up" section, locate and click on the "Background" button. The Excel background feature allows you to add an image or a picture from your gallery.
4. After clicking the "Background" button, you will be prompted to search for an image from your device. Go ahead and locate the image you want to add as your background image.
5. On clicking, the image's directory name will appear on the "Filename" bar. Click the "Insert" button and the image will appear behind the Excel cells.
Note: when choosing the background image, it is advisable to go for the more transparent one. This is to make the content within the cells visible.
How to delete the background image
To delete the background image inserted using this method simply follows these steps;
1. On the main page, click on the "Page Layout" tab.
2. Then, locate the " Delete background" button found within the "Page Set-up" section, and click on it. By doing so, the image will be removed.
Using the Kutools Add-ins feature
Kutools add-ins feature can also be used to add a background image on your Excel document. here are the steps to do so;
1. Firstly, you have to download and install the tools feature on your Excel. To download kutools, visit https://www.extendoffice.com/en/download/kutools-for-excel.html. After downloading, follow the installation process and connect it with your Excel.
2. Once you're done with the installation process, go ahead and add a background image using it.
3. To add a background, click on the "Kutools" tab on your Excel.
4. Then, click on the "Insert" drop-down menu and choose "Insert watermark."
5. On clicking, an "Insert Watermark dialogue box opens. Kutools allows you to add either picture or text as your background image.
6. If you want to add an image, toggle on the button next to "Picture watermark" and then click the "Select picture" button.
7. From your gallery, select the picture you want to use as the background and finalize by clicking the "Ok" button.
To delete the background image using Kutools
To delete the background image inserted using this method simply follows these steps;
1. Click the "Kutools" tab.
2. Then, click the "Delete"m drop-down menu and click the "Delete watermark" button.