We certainly live in a digital age, in which technology covers more and more space in our life. So much so that many activities that were previously made by hand, today can be done from the comfort of a computer.
This is the case of templates, accounting sheets and other administrative papers. To make them, they were completed by hand or with typewriters and stored in furniture and cardboard folders. Today all this has changed … or almost everything.
Although to a lesser extent, paper is still a requirement in many respects. Legal contracts, forms signed or formal presentations. They all need a physical backup. It is because of that Excel offers the print tool. Learn more below.
What are all the spreadsheet printing options in Excel?
Like other Office programs, Excel offers some options that are possible to modify when taking a document from screen to paper. By modifying them you can make the prints come out as you planned and do not get a surprise when it is too late.
Let’s see some features:
- do you copy. It is the first configurable value in the print menu. By default it is always in 1. Increasing it increases the number of copies to be printed. You must bear in mind that, if your document has 2 leaves, and you decide print 3 copies, the final result will be 6 prints.
- Printer. This dropdown shows the installed devices that can print the document, either connected to our computer or on the same network. If you have installed a program for editing or reading PDF, it may also be shown here as an alternative.
- Inside section “Setting” We will first find the area of the document that we can print. Possibilities include “Active sheets” that will send to the printer only the sheets of the document that we are using. “All the book” which will print all the created sheets regardless of their content. Y “Selection” which will do it only with selected cells.
- The next menu is “Pages” where you should indicate which are the ones you need to print.
- Pages per sheet. Here you will have to choose (if your printer allows it) if the sheet you are going to use will use one or two faces Of the same. Also having in the last option the possibility to turn on short or long edge.
- Order. If your document has several sheets and you will print more than one copy, in this section you must indicate print order. Interspersed divide by series and without interleaving per page.
- Orientation. Depending on the space shape (width and length) busy, opt for the most convenient.
- Sheet size. It is important that the document matches the size of the sheet what are you going to use. Since otherwise you might get a unwanted result. So as not to confuse the program show size in cm of each format.
- Margins. Like the previous two options, can be modified within the work interface. The latter determines the white space between the edge of the page and the content per se.
- Scaled. This option is for fit document content to selected sheet. What it does is resize cells until they fit on the sheet.
Steps to print an Excel spreadsheet to have it in physical
Now that you know the options available to make a proper impression, it’s time to learn how to perform the necessary steps to obtain a perfect impression.
Let’s see the steps to follow:
- The first thing you should do is go to the tab “Archive” and then to the section “To print” or press “Ctrl + P” (the latter may vary depending on the language).
- Once there, you will see a preview of the document that you are going to print, keep in mind that you can modify parameters with the information that we provide you before.
- Then press “Printer properties” to choose the color mode.
In black and white
Depending on the printer, the interface of the next window may vary. However, most have a tab “Colour”. Head there and select “Grayscale”. To confirm press “To accept”.
It is important that you know that not all machines From the market can make color prints. Thus, you may not find the tab or section “color” within the controller interface. But if you have one that does, choose the option “Colour”. As it is unusual for your document to have high definition photos or detailed pictures, we recommend that you use the “economy” mode. Thus you will save ink which would otherwise be unnecessary.
If you have any questions, leave them in the comments, we will answer you as soon as possible, and it will surely be of great help to more members of the community. Thank you! 😉