Spreadsheet printing

The printing of spreadsheets is one of the main features of Excel, allowing users to have a physical copy of the information contained in their spreadsheets. To print a spreadsheet, there are several configuration options that can be applied to ensure that the final result is as accurate as possible.

Setting up printing

Before printing a worksheet, it is important to configure the print options to ensure that the final result is as accurate as possible. Some of the most important settings include:

• Margins: define the spacing between the worksheet content and the page borders;
• Orientation: defines whether the print should be made in portrait (vertical) or landscape (horizontal) mode;
• Paper size: defines the paper size on which the worksheet will be printed;
• Zoom: allows you to adjust the size of the worksheet so that it fits on the page;
• Print Area: allows you to define exactly which worksheet cells should be printed.

Previewing the print

Before printing a spreadsheet, you can preview how it will print using the "Print Preview" option. In this view, you can see how the worksheet will be distributed on the pages, as well as apply some additional settings, such as inserting headers and footers, for example.

Printing the worksheet

Once you've set the print options and previewed how the spreadsheet will print, it's time to print the document. To do this, just click the "Print" button on the Excel toolbar. Before printing, it is important to ensure that the printer is set up correctly and that there is enough paper and ink available for the print.

Conclusion

The printing of spreadsheets is an essential feature of Excel, allowing users to have a physical copy of the information contained in their spreadsheets. To ensure that the final result is as accurate as possible, it is important to correctly set the print options and preview how the spreadsheet will print before printing the document.

Next page of the Free Ebook:

22Tips and tricks to increase productivity

2 minutes