How to make the background of the table

1. How to set the background picture of WPS table and how to use the picture as the background of the table.

There are many ways to set the picture background in WPS table.

Don't limit your thoughts to the "background map", after all, all roads lead to Rome.

As far as I know, there are four methods, and the detailed operation steps with pictures can be viewed by clicking on the last resource:

Method 1: Add the background image directly (applicable to WPS Office 20 19):

Click "Page Layout" in the menu bar-> Click "Background Picture" again, so you can set the background picture.

Method 2: Set the background picture through the header and footer (it will only be displayed when the preview page is printed):

Click Print Preview-> Header and Footer-> Custom Header-> Insert Picture in the shortcut toolbar to open the picture you selected-> OK-> OK. At this time, we can find that the background picture has been inserted.

References:

How to insert and set the picture background with WPS table

2. How to set the background picture of WPS table and how to use the picture as the background of the table.

Click the print preview icon in the WPS table toolbar to enter the page view. Then click the page setup icon on the print preview toolbar to open the page setup window and switch to the header/footer tab. Click the "Customize Header" button, click the "Insert Picture" icon in the opened "Header" window, select the required background picture in the "Open" window, and insert the picture into the header. At this point, the input cursor is displayed in the title edit box.

“& amp； [Picture] "(Figure 1), you can see the picture background effect of the table immediately after confirming the settings.

2. Position adjustment

The pictures inserted in the header usually exceed the table, so we have to make some position adjustments. Also in print layout view, click Margins in the toolbar to display margin lines, and then set the top

You can drop down the horizontal dotted line of "Header Position" to directly adjust the up and down position of the picture. As for the right and bottom, you can adjust it by modifying the size of the picture. Click in the Title window to position the input cursor.

“& amp； In the edit box where [Picture] is located, click the "Format Picture" button to set the height and width of the picture in the pop-up window, and you can trim and adjust the color of the picture under the "Picture" tab (Figure 2). After setting, click the print preview icon again to restore the normal worksheet view. Normal view can't see the graphic background, but as long as you print or print preview, there will be a graphic background.

In addition, only the cell area with no fill color can see the background picture in the worksheet, so we can freely adjust the display area of the picture background by setting the cell area to white or other fill colors (Figure 3).

3. Multiple background images

The header of WPS table is divided into left, middle and right cells. We can insert different pictures in each cell, so that we can use three different background pictures at the same time. The insertion positions of the pictures in the three grids are aligned left, middle and right respectively, and the bottom layer, middle layer and top layer are stacked in turn. Using these characteristics, as long as the sizes and positions of the three pictures are properly adjusted, different background pictures can be set for the table area, such as dividing the table into three parts: left, middle, right, top, middle and bottom, or inside, outside and inside (Figure 4).

However, if you want to adjust the upper and lower positions of the three pictures separately, you can't just drag the title line to adjust. In the title window, we can click &; ; [Picture] "Enter before inserting a blank line to move the background picture down. exist

“& amp； [Picture] "Insert a space on the left and move the picture to the right. As for moving the picture to the left, the WPS table will automatically ignore a large number of spaces on the right, so it should start with "&"; ; Insert a point ". "Right side of [picture]", and then insert a dot "&; ; Insert a space between [picture] "and". "to move the picture to the left (Figure 5).

Using spaces and enter to adjust the position is mainly to accurately set the position of each background image. If you just want to set a simple background of top, bottom, left, middle and right pictures, you only need to set the height and width of the three pictures according to the characteristics of the stacking order, and you don't need to adjust them by spaces or press enter.

3. How to add a background picture in Excel?

Format->; Worksheet-Background

This can't be printed If you want to print it, use the following method.

Excel background printing method

In Excel, you can set the background of the worksheet (format → worksheet → background), but these backgrounds cannot be printed. There are two ways:

First, the header method (this method is only applicable to Excel2002 and subsequent versions).

1. Prepare a picture as the background, and set the size to 650* 1000 pixels;

2. Start Excel2003 and open the workbook that needs to add background effect;

3. Insert a picture in the header settings. (View → Header and Footer → Custom Header)

Second, photography methods

1. Execute the tool customization command and open the customization dialog box;

2. Switch the Commands tab, select the Tools option under Category, and then drag the Camera option under Commands to the appropriate position on the toolbar and close it;

3. Select the cell to set the background, and click the "Camera" button just added on the toolbar;

4. Switch to an empty worksheet, click it, and a photo will appear in the worksheet immediately;

5. Select a picture, execute the "Format → Picture" command, open the "Format Picture" dialog box, and select a background picture in "Fill Effect".

4. How to change the background of EXCEL to the size of the background picture?

Insert the size of the background picture into the EXCEL background as follows:

1. Open excel, insert the background picture, click the page layout and select the background.

2. In the pop-up dialog box, select options from the file, select the inserted background picture, and click Insert.

3. Insert the background picture and display it as a full document and a separate table.

4, keyboard ctrl+A select all, click start, find the paint bucket at the red arrow, and select white.

5. The document cell is white, select the table content, click Start, and then find the paint bucket icon.

6. Select the paint bucket, select "No Fill" at the red arrow, and then click the mouse.

7. The background picture appears in the table content of the excel interface document, and the table is successfully inserted with the background picture.

5. How to set the picture background wall in Excel?

First, find the background in the page layout.

Click on the background, we can see the source of several pictures, you can see your own choice, here are the photos stored in the computer as the source,

Click Insert to get the renderings as shown in the figure below.

Second, choose the appropriate area and background.

Use the shortcut key ctrl+A to select the whole table, click Start, and select the first color in the first row, white, background 1, so that the background is temporarily covered.

Select any cell that contains content and press ctrl+A here. This time, the selected cell will be the part containing the content. Click here to start, fill the color, and choose not to fill the color, so that the background will only be displayed in the departments with content.