How do you remove the Page 1 background in Excel 2010?

Remove a sheet background

1. Click the worksheet that is displayed with a sheet background. Make sure that only one worksheet is selected.
2. On the Page Layout tab, in the Page Setup group, click Delete Background. Delete Background is available only when a worksheet has a sheet background.

How do I get rid of no watermark in Excel?

Hide page number watermark with Normal view If you just want to hide the page number watermark, you only need to switch Page Break Preview to Normal View. Click View > Normal, and then the page number watermark is hidden. Also, you can click Normal button in the status bar to quickly switch to Normal view.

Where is the watermark in Excel 2010?

Open the worksheet on which you want to add watermark, click the Insert tab from the Ribbon. then Header and Footer. Under Header and Footer tools, select Design and click on Picture from Header and Footer elements. Browse the image you want to use as your watermark.

How do I remove highlighting in Excel 2010?

Press “Ctrl-A” to select all highlighted text from all cells, right-click one of the cells in the Excel document and select “Clear Contents” from the context menu to delete the highlighted text.

How do you make a background transparent in Excel?

Make sure the Format tab of the ribbon is displayed. In the Adjust group click the Recolor tool or the Color tool (depending on your version of Excel). Excel displays a series of options. Click Set Transparent Color.

How do I remove background color in Excel?

To remove any background colors, patterns, or fill effects from cells, just select the cells. Then click Home > arrow next to Fill Color, and then pick No Fill.

How do you add a watermark to page 1 in Excel?

Create a watermark

1. Select Insert > Header & Footer.
2. Tap on the header and on the Header & Footer Elements tab on the ribbon, click Picture.
3. Select one of the available options to insert your image. In the header, you’ll see & [Picture].
4. Tap anywhere outside the header to see the watermark.

How do I clear in Excel?

1. Highlight the portion of the spreadsheet from which you want to remove formatting.
2. Click the Home tab.
3. Select Clear from the Editing portion of the Home tab.
4. From the drop down menu of the Clear button, select Clear Formats.

How do I clear all formulas in Excel?

Select the cell or range of cells that contain the formula. Press Delete….Delete an array formula

1. Click a cell in the array formula.
2. On the Home tab, in the Editing group, click Find & Select, and then click Go To.
3. Click Special.
4. Click Current array.
5. Press DELETE.

How do you get rid of watermark in Excel?

Remove your watermarks. You can remove watermark from the list using the Delete icon at the top of the pane. To erase it from your Excel file, click the Remove watermark button at the bottom of the pane.

How do you insert a watermark into Excel?

Open Microsoft Excel. Click on the Insert Tab. From the Insert option ribbon, click on the Text option which reveals further other options. From there select the Header & Footer. Now from the menu select the option Picture. A pop-up window will appear. Upload the picture that you want to insert as a watermark in Excel.

How do you remove a background in Excel?

To remove a background image, click the Delete Background button on the Page Layout tab of the Ribbon (which replaces the Background button when you assign a background image to a worksheet). Excel immediately clears the image from the entire worksheet.