excel-flexible print Specific area tips

Source: Internet
Author: User
Tags valid

In Monday, the typist Xiao Wu asked me a question: "How do I make a table in Excel if I just want to print one of those areas?" I recommend the following methods to her, if you are interested, you might as well try.

I. Regional Set-up method

This is the most appropriate way to print a fixed area each time.

Start Excel2003 (please follow the other version), open the appropriate workbook file, select the area you want to print, and perform the "file → print area → set print area" command. Later, when you need to print the area, just click the Print button on the Standard toolbar.

[Friendly reminder] At this point, if you need to print the contents of the entire worksheet, first cancel the print area you set up: Perform the file → print area → cancel print Area command.

Ii. Printing of regional laws

Use this method if you want to print several different areas.

Select the area you want to print, perform the file → print command, open the Print Content dialog box, select the selected area option under Print content, and then make sure you print.

Printer Repair Network Experts remind everyone: ① regardless of whether the print area is set, this method is valid. ② If you select more than one contiguous range of data, the system will only print each contiguous area on one page. ③ in the Print Content dialog box, select the page option under Print Range, and then enter the starting page number in the following box to print the specified page. (in Word, you can also print the specified page, following this action.) )

Third, the visual surface management method

If you often want to print a number of different areas, take the method of two operations, both troublesome and error prone, we recommend that the use of this approach.

Execute the view → View Manager command, open the Face Manager dialog box, click the Add button, open the Add View dialog box, enter a full name (such as "all"), and make sure to exit.

Select the columns (rows) that you do not want to print, right-click the mouse, in the shortcut menu that pops up, select the Hide option, hide the columns (rows) that don't need to be printed, and then open the Face Manager dialog box, add a visual view (such as print Report, and so on), and make sure you quit. Printer Repair Network Experts to remind you to hold down the CTRL key, with the mouse click the corresponding column (row), you can select multiple discontinuous columns (rows), one-time implementation of the above hidden operation.

Open the Face Manager dialog box again, select the All view item, and click the Show button to display the entire worksheet. Then follow the action above to hide the other columns (rows) that do not need to be printed, and then "Add" another "visual View" (such as "poster", etc.) to confirm the exit.

When you need to print an area later, open the Face Manager dialog box, select the appropriate view (such as the Print Report) item, click the Show button, display the appropriate view, and then perform the print operation.

Four, the Macro command law

Start Excel, open the appropriate workbook (, press the "ALT+F11" key combination, go to the Visual Basic Editor state, and in the Project Explorer window on the left, select the project for the above workbook dialog (for example, VBAProject (2004). XLS), executes the Insert → module command to insert a new module ("Module 1"), and then enters the following code into the window to the right:

Sub print ()

Selection.printout

End Sub

When the input is complete, close the Visual Basic Editor window to return.

Select the area you want to print, execute the tools → macros → macros command, open the Macros dialog box, select the macro you just edited (print), and click the Execute button.

Friends remind you that if you select the VBAProject (Personal.xls) option in the Project Explorer window, the macros above are valid for all workbook files.

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.