How to set the picture inserted in EXCEL as the background of the form? (that is, let the picture display at the bottom of the form)

Most users know that you can use a background picture in the worksheet by clicking Menu Format → Worksheet → Background, and then selecting a picture to insert.

Use a background picture in a worksheet

In order to make the background more harmonious with the contents of the worksheet, it is sometimes necessary to turn off the grid line display of the worksheet, because the grid line will be displayed above the background picture, which will destroy the aesthetic feeling. To turn off the display of worksheet gridlines, click Tools → Options, in the View tab of the Options dialog box, clear the gridlines check box, and then click OK.

The worksheet background when grid lines are not displayed.

By default, the background picture is tiled throughout the worksheet and cannot be printed. The following techniques can skillfully break through these limitations and help users exert the power of background images more flexibly.

Displays the background of a specific cell range.

If you don't want the background picture to be tiled throughout the worksheet or only in a specific cell area, you can do the following after inserting the worksheet background.

Displays the background only in a specific cell area.

press

Select the range of cells that need a background, and then press.

76? 2 print background

If you need to print the background and cell contents together, you can do the following.

Using the photography function of Excel, copy the cell area to be printed into a linked picture and paste it on a blank worksheet. This paper introduces the photography function of Excel.

Right-click the linked picture and choose Format Picture from the shortcut menu. As shown in figure 76? Four performances.

Format linked pictures

Select the Colors and Lines tab in the Format Picture dialog box, click the drop-down arrow of the Fill → Color option, and then select Fill Effect.

Set the fill effect of linked pictures.

Click Select Picture in the Fill Effect dialog box, then select a picture and click OK.

Select the picture in the fill effect.

Now you can see the set table background in the print preview.