How do I print a document or spreadsheet in Excel?

The Microsoft Excel application is one of the most popular in the Microsoft Office suite. It is often necessary to print the results. But how to print Excel? This program has its own peculiarities.

• Before you start printing, review the data,that they are completely visible on the screen. The digits or text that is not in the cell will be replaced with the characters "##" when printing. Therefore, in advance expand the required columns or increase the height of the rows.
• Enable page preview: Click the "File" tab and in the opened menu, click the "Print" command. In the lower left corner of the resulting window, we see the "Preview" button, with which we get the layout of the desired sheet. Here you can also view the next or previous pages (if the document contains more than one sheet). To exit this mode, select the "Close" tab at the top of the window.

How to print a table in Excel

If the data is in the table, go to it by clicking on one of the cells in this table.

• Set the boundaries of the desired area, i.e. Select the cells that you want to print.
• Via the "File" tab, go to "Print", and then - to "Preview".
• Choose the appropriate settings:
  • page orientation (portrait or landscape);
  • scale of the table;
  • set the margins on the sheet;
  • set the number of pages for information.

How to print a document in Excel

Let your results be placed on several sheets, which are required in hard copy.

• Select the desired sheets by clicking on thefirst, then, with the SHIFT key pressed, on the last (if it's adjacent sheets). If you select non-adjacent sheets, select them by holding down the CTRL key all the time.
• Enter the "Print" through the "File" and print the document, without forgetting all the same about the preview.

Important note! In Excel 2003, when printing, there may be distortions in the size of graphs, shapes, objects. Take this into account when defining settings. In Excel 2007 and Excel 2010, such problems are not observed.