Friday, September 30

How to Print an Excel Spreadsheet Successfully | Digital Trends Spanish


You solved all the challenges that Excel put you in the way, you applied the secrets and tricks of the application and, finally, you successfully completed your spreadsheet. But when you thought you had overcome all the obstacles, you realize that there is still one last step left: printing your document. Because you need to know how to print an excel spreadsheet, we guide you step by step.

You will be interested in:

One of the most recurrent problems of Excel users is that when they try to print a spreadsheet, but the information is separated into multiple sheets; or that they lose the headings of the long tables on the following pages. Fortunately, all these problems have a quick fix.

The first thing to do is make sure your printer is connected and then set the options that best suit you, such as scaling the spreadsheet, defining a print area, or changing the orientation. Here are all the steps to successfully print in Excel.

Print a spreadsheet on a single page

You designed the spreadsheet of your life, but you face the most recurring problem: when you print it, the information is separated into multiple sheets. If this issue occurs, you will need to scale the spreadsheet so that the data fits the dimensions of the page.

To achieve this, you must follow the following steps:

  • Click on the tab Page design in the options bar.
  • In the section Adjust print area, in the frame Width, Choose 1 page and in the box High, select automatic.
  • In this way, the columns will appear on one page, although the content of the rows may extend over more than one page.
  • If you want all the information to be contained in a single sheet, you must set the option 1 page in the frame High from the previous example.

Since Excel reduces the size of all content on the page in the scaling process, the text may be unreadable at time of printing.

For the same reason, be sure to verify that the box number Scale not be too low (less than 70%, for example), as in that case you will probably need to change the page orientation from portrait to landscape.

To adjust the orientation, you must do the following:

  • Click on the tab Page design in the options bar.
  • In the section Page setup, click on Orientation and choose the one that best suits you.

If you are sure this is the setting that suits you, press CTRL + P to open the dialog To print and then click To accept to print your document.

Print a selection from the spreadsheet

You don’t need to print the entire Excel document. If you wish, you can print only part of the spreadsheet, for example, the table where the final summary of your expenses is. To do this, you need to define the print area, which encompasses the range or ranges of cells you have selected. To define it, you must follow the following steps:

  • With your mouse, select the elements of the spreadsheet that you want to print. Make sure they are highlighted.
  • Click on the tab Page design in the options bar.
  • In the section Page setup, click on Printing area.
  • Press the option Set Print Area.
  • Your selection will be framed with dashed lines.
  • Press CTRL + P to open the dialog To print and then click To accept.

Print the row or column headings

If you need more than one sheet to print your documents, you may want to keep the row or column headings so that the information is quickly recognized by anyone. In the example, we specify that row 1, where the titles of “Product name”, “Customers” and prices by quarter are, appear on all sheets.

To achieve it on your own, you must carry out the following process.

  • Click on the tab Page design in the options bar.
  • In the section Page setup, click on Print titles.
  • If you haven’t, you can set the Printing area.
  • In section Print titles, select the rows and / or columns that you want to repeat as the header of your selection. Press the icon with a red arrow on the right side of the field to set the selection.
  • If you need, define the print order, and you can preview.
  • If you are sure, press the Print button.

Hide (or show) grids in print

The grid lines on your spreadsheet do not appear by default when you print a document. But if you want to enable them, you must perform the following steps:

  • Click on the tab Page design in the options bar.
  • In the section Grid lines, check or uncheck the box
  • In this section, you can also decide if you want to see or hide it on the screen.

Editor’s Recommendations








es.digitaltrends.com