Use Excel Quick tabulation to reject carelessness

Office Print tables use Word to print and find ID duplicates a lot

Had to find a little online Excel 2003 data Learning Small

① Quick Make Table

Create a new Excel file.

In new Excel, select the number of table rows you want with your mouse, then right-click, set cell format-border, and in presets, select the outline , inner border, as needed.

Add borders as needed. If it is the title, you can cancel the outer border, merging the horizontal or vertical table. The method is also to select the table you want to set (the first row), then right-click on "Format Cells"--"align", and then select " merge Cells ".

Set a fixed header footer and page number in Excel

Top header row, you can set "file-page Setup" in Page Setup-Worksheet

Bottom content cannot refer directly to the table, you can set the number of pages and the total number of pages in the page Setup-header footer question mark drop-down option

in Excel enables printing of fixed lines per page

Print preview-Settings-page

Scaling, such as 30 rows of data with headers and headings per page, is 140%

Selected active area print for Excel

Select what you want to print, file-print area-set print area.

ID ordinal column to note sort

Determine if the expected effect is achieved after a print preview

Remember to check at least three times before you start printing

Use Excel Quick tabulation to reject carelessness