Help on Tele2, tariffs, questions

Surely, you have encountered a situation when a document sent for printing was not printed in the form that you expected: either the table spread over several sheets, or, conversely, wide borders caused the table to be printed, which cannot be read. Today we will look at issues related to setting the print area and displaying only the part of the table that we want to see on the sheet.

Print settings

To open the print settings in Excel, go to the tab File, in the left pane, select Seal. On the left you will see a window with basic settings and a preview of the document that will be sent to the printer.

To print the document, click the button Seal.

What to print?

Let's now deal with the settings that allow you to tell the program what to print. The first setting option allows you to choose from three options: Print Active Sheets, Print Entire Workbook and Print the selection.

Please note, in order to print several sheets of the workbook, select the necessary sheets, hold down the Ctrl key, select the item Print active sheets and click the button Seal.

When choosing an item Print selection, Excel will print those cells that were selected at the time of printing.

Single-sided / double-sided printing

Some printers support duplex printing, which can also be set in Excel preferences.

After several experiments with my printer regarding flipping on a long edge or a short one, I did not see any difference, so I concluded that this choice does not affect the output of my printer. I recommend you experiment with your printers and see what happens.

Sort into copies

Excel has a setting that allows you to collate / not collate documents when printing multiple copies of a single document.

In the first case, copies of documents will be printed sequentially. All pages of the first copy will be printed first, then the second, third, and so on. In the second, all copies of the first page will be printed first, then the second, third, and so on.

Document Orientation

You can switch between portrait orientation(more rows, but fewer columns will fit on a sheet) and landscape (more columns, but fewer rows).

Print margins

To customize the print margins, you can use one of two methods:

1. Select one of the preset margin sizes from the list

2. Manually adjust the margins. To do this, click on the icon in the lower right corner of the preview window. Show fields. After Excel displays the fields, drag and drop as needed.

Scaling

Scaling allows you to adjust the size of printed objects in such a way as to make the most efficient use of paper space. If you want all the worksheet information to fit on one paper sheet, select Fit sheet to one page. This way, Excel will resize the table so that all the rows and columns fit on one sheet.

Part of this option is the ability to fit all columns or rows on one page. In this case, Excel will resize the table to fit the width or height of the printed area on one page.

Please note that you can manually adjust the scaling options. To do this, click on the tab Custom scaling options. In the dialog box that appears Page settings tab Page -> Scale, you can specify the scale percentage, or the number of pages to fit the printout in width or height.

Printing Notes in Excel

To print notes, in the print settings window, select the Page settings. In the dialog that appears, go to the tab Sheet –> Print. Opposite the field Notes select one of the three options for the ability to print Excel notes.

Outcome

Today we have reviewed the basic print settings in Ecxel, having studied which you can make printouts that use the area of ​​the printed sheet as efficiently as possible and at the same time do not lose readability.

You can print whole or partial sheets and books, one at a time or multiple sheets at a time. If the data to be printed is in a Microsoft Excel spreadsheet, you can only print the Excel spreadsheet.

In addition, you can print the book in a file instead of on a printer. This is useful if you want to print a book on a printer other than the one that was originally used for printing.

Preparing for printing

Before you print data in Excel, remember that there are many options available for optimal print quality. See Printing in Excel for more information.

Important: Certain types formatting, such as colored text or cell shading, may look good on the screen, but not as expected when printed on a black and white printer. In addition, you can print a sheet with a grid: as a result, the data, rows and columns will be better highlighted.

Printing one or more sheets

Printing one or more books

All book files that you want to print must be in the same folder.

Open the menu File and select command Open.

Hold down the CTRL key and click the names of the books you want to print, and then click Seal.

Printing all or part of a sheet

Printing an Excel spreadsheet

Printing a book to a file

Important: If you print the saved file on a different printer, page breaks and font spacing may change.

Sheet printing

For achievement best results when printing a worksheet, use the Print command in Excel Online, not the Print command in the browser. You can print the entire sheet or just the cells you need.

If you want to print a range of cells, select them. To print the entire sheet, do not select anything.

Note: If you're using Excel Web App with SharePoint 2010, see Print a document in Office Web Apps.

Change the selected print area

In Excel Online, you can specify the area you want to print or print the entire worksheet. If you decide to change the selected printable area, here's how you can view the changes:

On the sheet, select the cells you want to print using drag and drop.

On the tab File select item Seal and press the button Seal.

To print only the selected area, in the area Print Options click current fragment.

If the preview shows the data you want, click Seal.

To change the print selection, close the preview window by clicking X, and repeat the previous steps.

To print the entire sheet, click File > Seal > Seal. Make sure the checkbox is checked Whole sheet, and click the button Seal.

If you have the Excel desktop application, you can set additional print options. Click the button Open in Excel and select multiple print areas on a sheet.

Printing a sheet with hidden rows and columns

In Excel Online, when you print a worksheet with hidden rows or columns, the hidden rows and columns are not printed. If you want to include hidden rows and columns, you must display them before printing the worksheet.

You can tell if rows or columns are hidden by missing header labels or double rows, as shown in this picture.

Here's how you can display rows or columns.

Note: Row and column headings are not displayed in print preview and printouts.

book printing

If there is only one worksheet in an Excel Online workbook, you can simply . But if the workbook contains multiple sheets, you need to navigate to them by clicking the sheet tab, and then print that sheet.

Do you know if there are hidden sheets in the book? Here's how to check:

Printing a table

Sometimes you need to print only part of a sheet, such as a table. This can be done in Excel Online if the table contains less than 10,000 cells. On worksheets with more than 10,000 cells, you must use the Excel desktop application.

To print a table, follow the steps below.

Printing page numbers on a sheet

You cannot insert, view, or print page numbers in Excel Online. But if you have the Excel desktop app, you can add page numbers to the sheet at the top or bottom (in the header or footer) and print it out.

Click the button Open in Excel to open the workbook and add page numbers in Page Layout View, and then print the worksheet from Excel. Here's what you need to do for this:

see also

additional information

You can always ask the Excel Tech Community a question, ask for help in the Answers community, or suggest a new feature or improvement on the Excel User Voice website.

Note: This page is translated automatically, so it may contain inaccuracies and grammatical errors. It is important to us that this article is useful to you. Was the information helpful? For convenience also (in English).

Often ultimate goal working on an Excel document is its printout. But, unfortunately, not every user knows how to perform this procedure, especially if you need to print not all the contents of the book, but only certain pages. Let's see how to print a document in Excel.

Before you start printing any document, you should make sure that the printer is properly connected to your computer and the necessary settings have been made in the Windows operating system. In addition, the name of the device on which you plan to print should be displayed through the Excel interface. In order to make sure that the connection and settings are correct, go to the tab "File". Next, move to the section "Seal". In the central part of the opened window in the block "Printer" the name of the device on which you plan to print documents should be displayed.

But even if the device is displayed correctly, this does not guarantee that it is connected. This fact only means that it is correctly configured in the program. Therefore, before printing, make sure that the printer is turned on and connected to the computer via cable or wireless networks.

Method 1: Print the entire document

After the connection is verified, you can start printing the contents of the Excel file. The easiest way is to print the entire document. This is where we'll start.

1. Go to tab "File".



2. Moving on to the section "Seal" by clicking on the corresponding item in the left menu of the window that opens.



3. The print window starts. The next step is to select a device. In field "Printer" the name of the device on which you plan to print should be displayed. If the name of another printer is displayed there, you need to click on it and select the option that suits you from the drop-down list.



4. After that, we move to the settings block located below. Since we need to print the entire contents of the file, click on the first field and select the item from the list that opens. "Print the whole book".



5. In the next field, you can choose which type of printout to produce:
   • Single-sided printing;
   • Double-sided with a flip relative to the long edge;
   • Double-sided with a flip over the relatively short edge.

   Here you already need to make a choice in accordance with specific goals, but the first option is set by default.



6. In the next paragraph, you have to choose whether we parse the printed material into copies or not. In the first case, if you print several copies of the same document, all sheets will be printed immediately in order: the first copy, then the second, and so on. In the second case, the printer will print all copies of the first sheet of all copies at once, then the second, and so on. This option is especially useful if the user is printing many copies of the document, and makes it much easier to sort its elements. If you print one copy, then this setting is absolutely unimportant for the user.



7. A very important setting is "Orientation". This field determines whether printing will be in portrait or landscape orientation. In the first case, the height of the sheet is greater than its width. In landscape orientation, the width of the sheet is greater than the height.



8. The next field defines the size of the printed sheet. Choice this criterion, primarily depends on the size of the paper and the capabilities of the printer. In most cases, the format is used A4. It is set to default settings. But sometimes you have to use other available sizes.



9. In the next field, you can set the size of the margins. The default value is "Regular Fields". With this type of settings, the size of the top and bottom margins is 1.91 cm, right and left - 1.78 cm. In addition, it is possible to install the following types field sizes:
   • Wide;
   • Narrow;
   • Last user value.

   Also, the field size can be set manually, we will discuss how to do this below.



10. In the next field, the scaling of the sheet is configured. The following options are available for this option:
    • Current(print sheets with actual size) - by default;
    • Fit sheet to one page;
    • Fit all columns on one page;
    • Fit all lines on one page.



11. In addition, if you want to set the scale manually by setting a specific value, but without using the above settings, you can go to "Custom Scaling Options".

    

    How Alternative option you can click on the caption "Page settings", which is located at the very bottom at the end of the list of settings fields.



12. With any of the above actions, a transition occurs to a window called "Page settings". If in the above settings it was possible to make a choice between predefined settings, then here the user has the opportunity to customize the display of the document as he wants.

    In the first tab of this window, which is called "Page" You can adjust the scaling by specifying the exact percentage, orientation (portrait or landscape), paper size, and print quality (default 600 dots per inch).



13. In the tab "Fields" fine-tuning the margins. Remember, we talked about this possibility a little higher. Here you can set the exact, expressed in absolute values, parameters of each field. In addition, you can immediately set the horizontal or vertical centering.



14. In the tab "Headers and Footers" you can create headers and footers and customize their location.



15. In the tab "Sheet" you can configure the display of through lines, that is, lines that will be printed on each sheet in a specific place. In addition, you can immediately configure the order in which sheets are output to the printer. It is also possible to print the sheet grid itself, which is not printed by default, row and column headings, and some other elements.



16. Once in the window "Page settings" all settings are completed, do not forget to click on the button OK at its bottom in order to save them for printing.



17. Back to section "Seal" tabs "File". The preview area is located on the right side of the window that opens. It displays the part of the document that is output to the printer. By default, if you have not made any additional changes in the settings, the entire contents of the file should be printed, which means that the entire document should be displayed in the preview area. To verify this, you can scroll the scroll bar.



18. After the settings that you consider necessary to set are indicated, click on the button "Seal" located in the same section of the tab "File".



19. After that, the entire contents of the file will be printed on the printer.

There is also an alternative option for printing settings. It can be done by going to the tab "Page layout". Print display controls are located in the toolbox "Page settings". As you can see, they are almost the same as in the tab "File" and are governed by the same principles.

To go to the window "Page settings" you need to click on the icon in the form of an oblique arrow in the lower right corner of the block of the same name.

After that, the parameter window already familiar to us will be launched, in which you can perform actions according to the above algorithm.

Method 2: Printing a Range of Specified Pages

Above we looked at how to set up printing of a book as a whole, and now let's look at how to do this for individual elements if we do not want to print the entire document.

Method 3: Print individual pages

But what if you need to print not one range, but several page ranges or several individual sheets? If in Word sheets and ranges can be specified separated by commas, then in Excel this option does not exist. But still, there is a way out of this situation, and it lies in a tool called "Print Area".

By the way, in the same way, by setting the selection area, you can print not only individual sheets, but also individual ranges of cells or tables inside the sheet. The principle of selection remains the same as in the situation described above.

As you can see, in order to set up printing of the necessary elements in Excel in the form in which you want it, you need to tinker a little. It's not so bad if you need to print the entire document, but if you need to print its individual elements (ranges, sheets, etc.), then difficulties begin. However, if you are familiar with the rules for printing documents in this spreadsheet, you can successfully solve the problem. Well, this article tells about the solutions, in particular by setting the print area.

It often happens that when sending an Excel document for printing, we get an unexpected result at the output: either the table does not fit in length, or it spreads over several sheets in width. Let's figure out how to properly print an Excel sheet and how to print only the necessary part of the table. Do not forget about - calling the Print Excel sheet menu.

Printing options are adjusted using the "File" menu function - the upper left round button. We find the item "Print" on the left. A window will open on the left side, where the main settings options and the type of document in which it will be sent for printing will be displayed. In order to send the document to the printer, click "Print".

select print area

To tell the program which part of the document we want to print, consider the primary print settings. There are three options here:
- print the whole book;
- print active/dedicated sheets;
— print the selected fragment/range.

If you need to send certain Excel sheets for printing, click on each sheet you need, while holding down Ctrl (so select the sheet group), then we find in the menu " Print active sheets"And click on the button" Print». A group of sheets between two sheets can be selected by holding Shift.

To print a specific fragment of the sheet, select the desired cells and select "Print the selected range" from the menu.

How to set the orientation document (landscape or portrait format)

In Excel, you can choose between portrait and landscape orientation, depending on how many rows and columns we plan to fit on the sheet. With a large number of rows, the book version is more suitable, and if you need to fit many columns, choose the landscape format.

Go to the Ribbon Page Layout - section Page Setup - Orientation

How to set print margins correctly

There are two options for setting print margins:
- choose the appropriate size from the proposed options;
- make settings manually by clicking on the button " Show fields", located at the bottom of the window preliminary viewing from the right side ; then place the fields that appear in the correct order.

Printing an Excel sheet. How set scale?

By using scaling You can adjust the document size for optimal use of print space. If we want to fit all the workspace data on one paper page, we need to select the tab " Fit sheet on one page». Then both rows and columns of the table will be placed on one page. With this option, you can also place all rows or all columns of the document on one printed sheet in order to place it in a user-friendly form.

The scale can be set manually. This is done using the "Custom Settings" item. scaling". When a dialog box with parameters appears, select in the tab "Page" the option "Scale", where you can set the scale as a percentage or the number of pages horizontally and vertically, on which you want to place all the elements of the printed area.

How to print notes

If there is a need to print notes, in the print settings, select the icon " Page Setup". Then in the window we find the tab " Sheet", Where we select" Print". Next to the field " Notes"A list of three options for printing notes will appear. Choose the one you want and print. Read more.

In Excel ovenattack you can separate pages of the table, the entire table, selected range, data after filtering, notes in cells, table header on each page, etc. First you need to prepare the document for printing, set up print options in excel- fields, set the print area sheet size and orientation, etc. This will save time and money (paper) :)
There are many ways to prepare and print a spreadsheet.
First option.
Before printing, it is better to view the document in preview mode. Here you can see how the document will look on paper. Whether the whole table will enter or only part of it. What fields are obtained, etc. In preview mode, you can immediately make changes to the document. We will talk about this now.
So, preview in excel.
In the upper left corner, click the "Office" button. ce " and select "print", then - "Preview".

Section "Page" Page Setup dialog box .