Microsoft is one of the operating systems with the most tools in the world, since it offers dozens of programs that will help you both in your day-to-day life and in your work life. One of these programs is Microsoft Office, which includes several types of applications to create documents, such as Word, PowerPoint and Excel, the latter being widely used when making spreadsheets.
However, many users have reported difficulties when printing any spreadsheet within Excel , so below, we will show you how to do it in a few minutes.
Index( )
What should you know before printing any page of an Excel document?
When printing an Excel document, sheet or table, when downloading the program it is necessary to take into account certain characteristics that will make your printing successful and without any errors. Whether the numbers are moved or the table is incomplete, they are inconveniences that could ruin your Excel page when printing it.
Know the size of sheet you are going to use
To avoid inconveniences when printing a well-prepared Excel table, it is important to know what size the table will be displayed on paper and that the size of the sheet is appropriate for the table, whether it is A4, Letter, Legal, etc. ., for this you just have to follow these steps:
- Enter the Excel document you want to print and click on ‘File’, located on the toolbar offered by the program.
- Next, you must click on the ‘Print’ section, located in the menu that you will find on the left side, in order to observe the printing settings.
- Finally, you have to locate the box referring to the size of the sheet and select the option you want to use, you can choose from A4, letter, tabloid, official, executive, A3, among others.
How to print any sheet within an Excel document?
To print an Excel sheet you need to verify certain characteristics that, although the Excel program configures them automatically, these may not be established according to how you want to print your document. Therefore, it is important to know and adjust these settings to your preferences.
Selecting page width and orientation
When you want to print a document, whether from Excel or from any other program, it is very important to establish the margins or width and the orientation of the page to be printed . This will help you so that the information you are going to print does not exceed the limits of the sheets or the tables are cut, to establish these settings follow these steps:
- Enter your Excel document, where you must go to the ‘Files’ option,located on the toolbar, so that a settings menu is displayed.
- Already in the settings menu you can see the ‘Print’ option, which you must select to enter Excel’s print settings.
- In the settings you will see different sections, including width and orientation settings. There you will select if you want your Excel document to have narrow, normal or wide margins, in addition to being able to configure the orientation that you want the document to have, whether you want it vertical or horizontal.
Manually select the print area
On the other hand, if you want to print a specific area of your Excel document , be it a table or chart, you can select it manually, so that only that specific area or area is printed. This procedure is very simple to do and will only take a few seconds, you just have to follow these easy steps:
- Go to the Excel document you want to print, and highlight the specific table, page, or spreadsheet you want to print.
- Next, go to the toolbar and click on the option named ‘Page Layout’to open the settings area.
- Now, you must select the ‘Print area’ section, so that some options are displayed, where you will click on ‘Set print area’.
- Finally, you must go to ‘File’, followed by ‘Print’, and you will click on the print section and change the default settings from ‘Print active sheets’ to ‘Print selection’.
Choosing a specific scale
If at the time of printing your document in Excel you do not want the table to fit the sheet or you want to change the settings or scale of the table you want to print , you can do it easily by changing the scale. This tool helps you to adjust the scale of your document or spreadsheet to the sheet or as you wish, to do it you just have to follow these simple steps:
- Enter your Excel document and go to the toolbar, then select the ‘File’ option and click on ‘Print’.
- Now, you only have to select the type of scaling that you want to establish for your document in the corresponding section, whether you want to fit the page to a sheet, fit all the columns to a page, without scaling or another option.
Once all the configurations corresponding to your wishes have been completed, you will be able to proceed with printing your Excel sheet with all the personalized settings to your liking, so that it does not present problems when it comes to obtaining it physically.
However, if you want to see how the Excel page will look like when printed, you can make use of ‘Preview’ , which is a tool provided by all Microsoft Office software.
