Print knowledge in Excel large collection of skills

Source: Internet
Author: User
Tags exit range

Excel worksheets should preview before printing, print preview to see what is not visible in normal view, avoid errors, improve print quality, and quickly change many print settings. When the page is previewed, the margins will be displayed as dashed lines to facilitate adjustment. Small series to Excel2003 as an example, describes the general method of printing the Excel file, the purpose is to enhance the readability of the file.

1. Create headers and footers

The headers and footers of worksheets contain a lot of useful information, such as page numbers or worksheet headings in a report, and so on, the user simply clicks the Page Setup command on the File menu to open the Header/Footer tab of the Page Setup dialog box. If you need to use a built-in header and footer, open the header or footer Drop-down list and choose from Page 1th, page 1th, total page, and so on. If you need to create your own headers and footers, open the dialog box by clicking Custom Header or Custom footer. The layout and functionality of the two are exactly the same, with 10 buttons arranged between them. The leftmost button is used to format the text, the rightmost button to set the size of the picture, and the eight buttons in the middle from left to right can be inserted into the page number, date, time, and so on.

2. Make each page print out header row

A table of multiple pages that typically requires a header row to be printed on each page: to perform the file → page setup, open the Page Setup dialog box, click the Sheet tab, and in the box following the top header row, enter: (This assumes the 2nd and 3rd behavior headings, and the $ symbol in the English state, With the SHIFT+4 key combination input), to determine the exit, and then print, the system will automatically add a header row for each page. If you enter the column heading area in the box after the left header column, you can add the above headings to each page.

3. Make all data visible

If the text or number in a cell is outside the column width, the printed text is truncated and the printed number appears as "######." To do this, you must make sure that all the data in the worksheet is visible before printing. If you find that a column is not wide enough, simply place the cursor on the right side of the column column, double-click the line after the cursor becomes a bidirectional cursor, and automatically increase the column width to fit the length of the data. You can also click the Cells command on the Format menu. Opens the Alignment tab of the Cells dialog box, and automatically wraps the data to fit the column width by selecting wrap in text control.

4. Use easy to see format

A variety of domestic reporting habits to set gridlines, we can open the sheet tab of the Page Setup dialog box and select grid lines under Print. You can also select all the cells that you want to set gridlines for, click the Border Drop-down button on the Excel Formatting toolbar, and open the dialog box to select the border style you want. In addition, the on-screen display of a good format does not necessarily have a good printing effect. If the text or table border of the worksheet is set to color, but you use a black-and-white printer to print the report, it is best to use a color with a higher contrast, otherwise the printed content is not clear enough. In addition, you can increase the clarity of color printing by opening the sheet tab of the Page Setup dialog box and selecting Monochrome printing under Print.

5. Center the report

If you use a paper that can hold the entire report, you can set the center horizontally or vertically. The former can open the Margins tab of the Page Setup dialog box, select the horizontal option under centering, and the vertical complex option under center mode is selected. When both are selected, the report uses both horizontal and vertical centering on the paper.

6. Adjust the space around the report

The Excel report is surrounded by six sections of page margins and top and bottom headers and footers. If we need to change the margins or headers and footers, you can open the Margins tab of the Page Setup dialog box and change the values for the top, bottom, left, right, and header, footer. You can also click the Print Preview button in the Excel toolbar to open the Preview window click the Margins button to display the sizing handles for the page margins, and drag to the desired width as needed.

7. Print discontinuous cells (area)

If you just need to print out the contents of some noncontiguous cells (regions), then, while holding down the CTRL key, click the cell (range) you want to print with the left mouse button, select multiple noncontiguous cells (range, such as A2.B2:C8.D10 ...), and then select file → print. Open the Print Content dialog box, select the selected area option under Print content, and press the OK button. At this point, the system separates each contiguous cell (region) that is selected and prints it on a different page (that is, the A2 is printed on a sheet of paper, and the B2:C8 is printed on another piece of paper ...). If you need to print a fixed discontinuous row or column frequently, after the above hidden settings are complete, perform the view → face manager, open the Face Manager dialog box, press the Add button, and enter a name (such as print) in the box following the name of the Add View dialog box that pops up. OK exit. When you need to print later, open the Face Manager dialog box, select the Print view item, press the "Show" button, you can display the set of printed pages, the print operation is OK.

8. Print discontinuous rows (or columns)

Sometimes, you need to print some of the noncontiguous rows or columns of a worksheet. You can hold down the CTRL key while you click the Row (column) label with the left mouse button, select a number of discontinuous rows (columns) that you do not need to print, right-click the mouse, select "Hide" options, hide it, and then perform the print operation on it.

9. Print out the formula

If you want to print a formula in a cell, execute tools → options, and in the View tab, select the Formula option to make sure you exit. At this point, the worksheet contains the cells of the formula, not the results of the calculation of the formula, but shows the specific formula, performing the print operation, you can print the formula.

10. Print multiple worksheets at once

When you hold down the shift (or CTRL) key and click on the worksheet name that you want to print, you can select multiple consecutive (or discontinuous) worksheets for normal print operations to print the selected worksheet once. In the Print Content dialog box, select the entire workbook option under Print content, and then make sure that you print all the worksheets in the entire workbook at once.

11. Fit the worksheet to the page width

If you find that the worksheet is wider than the page when you print the preview, you can try the following methods to fit the worksheet to the page width: First, change the print orientation to landscape. The second is to reduce the size of the worksheet to fit the page. The way is still to open the page tab of the Page Setup dialog box, select Adjust to under Zoom, and enter 1 in the page width box. When you are sure, you can preview the page to see if the font size is appropriate. The third is to reduce the margins and the width of the header (footer). We can open the Print Preview window in the way described above, click the Margins button to display the sizing handles of the margins, and drag them to the desired width as needed. Four is to hide some columns in the report that do not need to be printed. All we need to do is select the columns and click the Hide command under the format → Columns submenu. Other columns in the report occupy the location of the hidden columns so that content that cannot be printed can be printed. After that, you can display the hidden columns by clicking the Unhide command under the format → Column submenu.

12. Quick selection of the print range

Selection of print range: The cursor stays in the upper left corner of the desired print range, first ctrl+shift+→, then ctrl+shift+↓, need to adjust then use shift+↓ and → to increase the line or column without text area.

Wide-width Excel document print settings, you may encounter the need to set the left two columns to a fixed format, you can set the top row and left column in the page setup, the document is defined as multiple pages wide, one page high, you can print a beautiful wide document.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.