Summary of Excel print settings skills

This article brings you relevant knowledge about excel, which mainly introduces some skills about printing settings. The first is to beautify the document as necessary, such as setting the font, font size, Add borders, etc. Let’s take a look at them together. I hope it will be helpful to everyone.

Related learning recommendations: excel tutorial

Today we will talk about how to set up Excel document printing and see how to print from Excel document Become a paper document.

The first step is to beautify the document as necessary, such as setting fonts, font sizes, adding borders, etc. You can freely play with these contents.

The next step is to enter the key steps:

1. Set the paper and page margins

The paper direction is divided into portrait and landscape. If the data table has a large number of columns, then Just select landscape, otherwise use the default portrait.

The page margin refers to the distance between the printed content and the outermost edge of the paper. When printing a multi-page table, the page margin can be set slightly narrower.

2. Print only part of the area

There is a lot of data in the worksheet, but what should I do if I only want to print part of it?

Select the cell area you want and set the [Print Area] under the [Page Layout] tab.

3. Print the same title on multiple pages

If there are multiple pages of data that need to be printed, you can have the same title line on each page. The tables are beautiful and easy to read.

#4. Quickly adjust the printing ratio

You can reduce or expand the printing ratio by combining the page content and paper size. You can also reduce the width or height to a specified number of pages.

5. Drag the mouse to set the page size

Switch to the "Page Preview" view and drag the blue paging line with the mouse to quickly adjust the page Size:

6. Insert page number

When printing multiple pages, it is a good idea to add page numbers:

7. Add headers and footers

There are many items for users to set in the [Page Settings] dialog box. For example, if horizontal centering is set, the printed content will not be offset on the paper.

Under the [Worksheet] tab of [Page Setup], you can also set grid lines, monochrome printing, draft quality, column and column titles, and comments and error values. Display mode, these options are rarely used in actual work. Interested friends can set it up and then click the [Print Preview] button to see what the effect is.

8. Adjust the page margins in the print preview interface.

Before printing the file, you need to preview the printing effect. In this interface, you can also Appropriately adjust the column width and page margins:

First click the [Show Margins] button in the lower right corner, then move the cursor to the position of the adjustment handle, press the left Just hold down the key and drag.

9. Scale all columns to one page

When printing preview, if a column is displayed alone on another page, you only need to set the scaling at this time. Just scale all columns to fit on one page.

10. Print the entire workbook

If you want to print all worksheets in the entire workbook, you can select "Print the entire workbook" during the print preview. ".

Related learning recommendations: excel tutorial

The above is the detailed content of Summary of Excel print settings skills. For more information, please follow other related articles on the PHP Chinese website!