back to top

How To Print In Excel Tables And Spreadsheets Correctly

Get it printed and show exactly the area, cells, columns or rows that need a document created in Excel. How to display gridlines, adjust and reduce the size of a table. Using the options in the Preview window. Solving common mistakes.Microsoft Excel is the most widely used program to create and print spreadsheets and charts. Many of those who use it professionally confront problems when printing. There are several conflicts, no gridlines are shown, not the desired area is printed, missing columns, tables are split incorrectly, etc. At the request of some readers in this article we deal simply with practical examples, the most common printing spreadsheets, charts and documents and how to fix problems, those who are not professional.

Posted on

Print in Excel

By default , Excel Printing the page area containing data, ie from the first to the last cell.

For that the program uses some default parameters:

• The paper size, or physical dimensions (A4, Letter, Legal, etc.)

• The page orientation (Portrait or Landscape)

• Margins (spaces around)

The following image shows an example, a page with only two cells: "data1" and "data2".

The "data2" cell is outside the printing area since in this example the page orientation is Portrait and A4 paper is used. It will be printed on another sheet.

How to print a document in Excel?

To print a spreadsheet or a table on the tab File use "Print", the Preview window opens.

This window allows us to see how stay exactly the printed document and make the necessary adjustments in case of errors.

Also we can open it using the keys: CONTROL + P. The commands in the sidebar Preview window allow us to make adjustments for printing is successful.

How to print correctly in Excel table

#The first step is to open the Page Layout tab and choose the "Orientation" and "size" of the sheet in the printer. Select the table area to be printed.

For that we click in the first cell and the Shift (Shift) key pressed select the last cell. We click on the "Print Area" icon and the menu select "Set Print Area".

We will now see heavy dotted line surrounding the area.

If another thin points within said area appears, indicating that we exceeded we leaf area is printed or not we need physically be printed.

Set the print result in the Preview window

Use the CONTROL key + P.

To our surprise in the preview window gridlines not shown.

We must enable the option manually.

That gives clicking on the "Page Setup" link in the Sheet tab check the box: "Print gridlines".

Now in the "Scaling" option gives a click and from the menu select: "Adjust sheet on a page"

You'll see that now correctly show all columns.

Options in the Preview window

Some of the options in the Preview window are self- explanatory (Select Printer, pages to print, collating, etc.)

The Scaling option is most helpful to adjust the format:

Without scaling. Print the spreadsheet or table without changing the size or format, cells that are outside are printed on another sheet.

Adjust sheet on a page. Reduces the overall size so that it is on a page.

Adjust all columns on a page. Reduces the width.

Adjust all rows on a page. Lowers.

Configuration option opens a window in which to set some basic parameters of printing.

Page Breaks

Sheets that need multiple pages Excel marks the boundaries of the area that corresponds to each one of them with broken lines.

However , you can specify exactly where you should start each page, so that you use the "Hops" option.

Check the cell where you want to start a page.

Give a click on the "Hops" icon and choose in the menu: "Insert Page Break".

Now on the sheet dashed lines appear that mark the jump.

This post was created by a member of BuzzFeed Community, where anyone can post awesome lists and creations. Learn more or post your buzz!