How to Remove Background in Excel (2 Practical Cases)

The Excel sheet is used mainly for creating datasheets and performing quick calculations without using a calculator. So, a previously added background may cause distractions to your usual work. Sometimes you may need to work on a previously made Excel sheet that contains an inserted background rather than the default one. This article will show you how to remove the background in an Excel worksheet.


Download Practice Workbook


Background in Excel

Usually, the default background in an Excel sheet is set to rectangular cells of equal width and height separated by gridlines. The default width and height of a cell are 15 and 8.43 respectively with the default font of Calibri. You can customize the row height and column width on your demand.

Background in Excel

However, Excel allows you to change the background of your worksheet if you like. You can also insert pictures/shapes/icons/3D models into your background. Even you can turn off the gridlines of your working sheet.


2 Cases to Remove Background in Excel

In this section, you will find 2 easy and effective ways for removing background in Excel. So, let’s check them out!


1. Remove Sheet Background

Let’s say, we have got a dataset of sales of the sales assistants of a shop over a certain period of time in an Excel worksheet. But the sheet has a background which makes it a distraction to read the dataset.

Dataset for Removing Background in excel

We want to remove the background from this sheet. And to do so, just follow the steps below:

  • First of all, go to the Page Layout tab> click the Delete Background option. The Delete Background option will only be noticeable when there will be an inserted background.

Remove the Background in Excel

  • Hence, you will get the background removed. After removing the background, you will notice that the Delete Background option is no more on the tab.

Remove Background in Excel

So easy, isn’t it? You will be able to remove the background of your working sheet in the blink of an eye!

Read More: How to Remove Background Color in Excel (5 Ways)


Similar Readings


2. Remove Picture Background

You may have pictures/stickers/icons/3D models inserted into your worksheet. And you want to remove the picture from your background.

Dataset to Remove Picture Background in Excel

For doing so, just follow the steps below:

  • First of all, click on the picture.
  • Then, go to the Picture Format tab> click the Remove Background icon.

  • Then, Background Removal options will show up.

  • Now, click Mark Areas to Keep if you want to keep some portions in the background.  Mark the areas you want to keep.

  • After that, click Keep Changes to show the changes you made.

  • Hence you will see the marked portion in the background.

  • Again, you can also select Mark Areas to Remove to remove the portion you want. If you want the whole object removed, mark the whole area and click Keep Changes.

  • And you will get the picture removed from the background.

  • Again, you can also just click on the picture and hit Delete. Your background picture will be removed.

By following the above way, you can quickly remove the background picture/icon/shape from your Excel sheet.

Read More: How to Make Picture Background Transparent in Excel (2 Methods)


Things to Remember

  • Background in Excel can not be used like the watermark. It will not show up after printing the sheet.
  • You can remove the background if it distracts you from reading the datasheet. Sometimes, if the background is needed, you can also change the fill color of the datasheet to read the data easily without removing the background.
  • Excel allows you to keep some of the portions of an image/icon and remove some of the portions from the background.
  • You can’t keep some portions of the sheet background and some portions removed. You have to remove it totally if you want to do so.

Conclusion

In this article, you have learned how to remove background from an excel worksheet. I hope, from now on you can easily remove the background in Excel. If you have any better methods or questions or feedback regarding this article, please share them in the comment box. This will help me enrich my upcoming articles. For more queries, kindly visit our website ExcelDemy. Have a great day!


Related Articles

Rafi

Rafi

Hey there! I am Md. Rafiul Hasan. Currently I am working as an Excel & VBA content developer. I like new ideas and want to explore the field of innovation. Excel has saved our worktime and made it easy for us to quick calculations. I am trying to make it easier for you to overcome the obstacles you face while working on Excel. Stay connected!

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo