banner



How To Get Rid Of Picture In Excel Background

In Microsoft Excel, you can use a picture every bit a sheet background for display purposes only. A sheet background is not printed, and it is not retained in an private worksheet or in an item that you salvage as a Web page.

Because a sheet background is non printed, it cannot be used every bit a watermark. However, you lot tin can mimic a watermark that volition be printed by inserting a graphic in a header or footer.

  1. Click the worksheet that you want to display with a sheet background. Make sure that only one worksheet is selected.

  2. On the Page Layout tab, in the Page Setup grouping, click Background.

    Excel  Ribbon Image

  3. Select the pic that you want to use for the canvass groundwork, and then click Insert.

    The selected picture is repeated to make full the sheet.

  • To improve readability, you can hide prison cell gridlines and apply solid color shading to cells that contain information.

  • A sheet background is saved with the worksheet data when you save the workbook.

To utilize a solid colour as a sheet background, you can apply cell shading to all cells in the worksheet.

  1. Click the worksheet that is displayed with a sheet groundwork. Make sure that only one worksheet is selected.

  2. On the Folio Layout tab, in the Page Setup group, click Delete Groundwork.

    Excel  Ribbon Image

    Delete Groundwork is available but when a worksheet has a sheet background.

Watermark functionality is not available in Microsoft Excel. However, yous can mimic a watermark in one of two means.

Yous can display watermark information on every printed page — for example, to signal that the worksheet data is confidential or a draft re-create — by inserting a motion-picture show that contains the watermark information in a header or footer. That film then appears backside the worksheet data, starting at the top or bottom of every page. Yous can also resize or calibration the picture show to fill the whole page.

Y'all tin also employ WordArt on top of the worksheet data to bespeak that the data is confidential or a typhoon copy.

  1. Click the worksheet location where yous want to display the watermark.

  2. On the Insert tab, in the Text grouping, click WordArt.

    Excel  Ribbon Image

  3. Click the WordArt style that you want to utilize.

    For instance, use Fill - White, Drop Shadow, Fill - Text one, Inner Shadow, or Fill - White, Warm Matte Bevel.

  4. Type the text that y'all want to use for the watermark.

  5. To change the size of the WordArt, do the post-obit:

    1. Click the WordArt.

    2. On the Format tab, in the Size group, in the Shape Height and Shape Width boxes, enter the size that y'all want . Note that this only changes the size of the box that contains the WordArt.

      You lot can likewise drag the sizing handles on the WordArt to the size that you desire.

    3. Select the text inside the WordArt, and then on the Home tab, in the Font group, select the size yous want in the Font Size box.

      Excel  Ribbon Image

  6. To add together transparency and then that you can run across more of the worksheet information underneath the WordArt, do the following:

    1. Right-click the WordArt, and click Format Shape.

    2. In the Fill up category, nether Fill, click Solid fill.

    3. Elevate the Transparency slider to the percentage of transparency that you desire, or enter the percentage in the Transparency box.

  7. If you lot want to rotate the WordArt, do the following:

    1. Click the WordArt.

    2. On the Format tab, in the Arrange group, click Rotate.

      Excel  Ribbon Image

    3. Click More Rotation Options.

    4. On the Size tab, under Size and rotate, in the Rotation box, enter the degree of rotation that you want.

    5. Click Close.

      You can also drag the rotation handle in the management that yous want to rotate the WordArt.

Note:Yous cannot use WordArt in a header or footer to display it in the background. Nonetheless, if you create the WordArt in an empty worksheet that does not display gridlines (clear the Gridlines check box in the Show/Hide group on the View tab), you can press PRINT SCREEN to capture the WordArt, and so paste the captured WordArt into a drawing program. Yous tin can then insert the picture that you created in the drawing programme into a header and footer every bit described in Employ a moving-picture show in a header or footer to mimic a watermark.

This characteristic is not bachelor in Excel for the spider web.

If you accept the Excel desktop application, yous can utilise the Open in Excel push button to open up the workbook and add a sheet background.

How To Get Rid Of Picture In Excel Background,

Source: https://support.microsoft.com/en-us/office/add-or-remove-a-sheet-background-3577a762-8450-4556-96a2-cc265abc00a8

Posted by: bowyerhunhis.blogspot.com

0 Response to "How To Get Rid Of Picture In Excel Background"

Post a Comment

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel