First of all, we need to prepare watermark and Logo pictures on the computer. It's better to have a light color of the watermark picture, so that the output will not affect the data display of the worksheet.
Let's demonstrate it step by step.
1. Select View | Workbook View | Page Layout, or click the Page Layout button in the lower right corner of the workbook.
2. In the page view, click the middle part of the header, and then you will enter the header editing state.
3. Click the Picture button in Header and Footer Tools | Header and Footer Elements in the title bar. After that, select the locally prepared picture in the dialog box that appears.
4. After selecting the picture, "&; Will be displayed in the title. [picture] ". At this point, we can click outside the header to display the picture content in the worksheet.
5. If the display size and position of the picture are not suitable, you can click the middle part of "Header" again. Select the Format Picture button in the Header and Footer Tool || Header and Footer element. In the Format Picture dialog box, we can adjust the size and color depth of the picture.
If the position is not suitable, we can use "&; Before the word [picture], you can press Enter continuously until the position meets our requirements.
We can add a watermark picture or logo title to the worksheet. Let's see how to do it.
Summary: The above operation adopts the method of adding pictures in the header or footer to realize the operation of adding watermark pictures and Logo headers. I believe that with more practice, my friends will definitely produce standard and standardized worksheet files.
There is another way to insert a background picture in Excel. We can set the background picture of Excel through Page Layout | Page Setup | Background. However, in actual printing, the background image set in this way will not be printed. It can also be seen from here that Excel is specially designed for data tables, and it is not recommended that the interface is too complicated when printed.