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 used to be done by hand can now 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 ways. 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 print options for spreadsheets in Excel?
Like other Office programs, Excel offers some options that can be modified when taking a document from the screen to the paper. Modifying them you can make the impressions come out as planned and don't be surprised when it's too late.
Let's see some characteristics:
- do you copy. This is the first configurable value within the print menu. By default it is always at 1. Increasing it increases the number of copies to be printed. You must take into account that, if your document has 2 sheets, and you decide print 3 copies, the end result will be 6 prints.
- Printer. This dropdown shows the installed devices they 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 leaves" that will send to the printer only the sheets of the document that we are using. "All the book" which will print all the sheets created regardless of their content. AND "Selection" which will do it only with the 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 of turning in short or long edge.
- Order. If your document has multiple sheets and you will print more than one copy, in this section you should indicate the printing order. Interspersed will divide by series and without inserting per page.
- Orientation. Depending on the space shape (width and length) busy, go for the most convenient one.
- Sheet size. It is important that the document matches the sheet size what are you going to use. Since otherwise you could get a unwanted result. Not to confuse the program shows the 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 page edge and content per se.
- Scaling. This option serves to fit document content to selected sheet. What it does is modify the size of the cells until they fit on the sheet.
Steps to print an Excel spreadsheet to have it physically
Now that you know the options available to make a proper impression, it's time to learn how to take the necessary steps to get 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 we provided before.
- Then press "Printer Properties" to choose the color mode.
In black and white
Depending on the printer, the interface of the following window may vary. However, most have a tab "Color". Go there and select "Grayscale". To confirm press "To accept".
Full color
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" inside the controller interface. But if you have one that does, choose the option "Color". As it is unusual for your document to have high definition photos or detailed pictures, we recommend you use the "economic" mode. Thus you will save ink that would otherwise be unnecessary.