【Print Excel Spreadsheet】Step by Step Guide ▷ 2022

We certainly live in a digital age, in which technology covers more and more space in our life. Such is the case that many activities What used to be done by hand can now be done from the comfort of a computer.

This is the case of the 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, signed or formal submissions. 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 can be modified when taking a document from screen to paper. By modifying them you will be able to make the impressions come out as you planned and not be surprised when it is too late.

Let’s see some features:

• do you copy. This is the first configurable value within the print menu. By default it is always on 1. Increasing it increases the number of copies to be printed. You should bear in mind that if your document has 2 leavesand you decide print 3 copies, the final result will be 6 prints.
• Printing machine. This dropdown shows the installed devices that can print the document, either connected to our computer or on the same network. If you have a PDF editing or reading program installed, it may also show up here as an alternative.
• inside section “Setting” We will first find the area of ​​the document that we can print. Among the possibilities are “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 sheets created regardless of their content. Y “Selection” which will do it with only the selected cells.
• The next menu is “Pages” where you must 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 on short or long edge.
• Order. If your document has several pages and you will print more than one copyin this section you must indicate print order. interspersed will divide by series and without interleaving per page.
• Orientation. Depending on the space shape (width and length) busy, choose 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. In order not to confuse the program shows the size in cm of each format.
• margins. Like the two previous 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 used to 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 physically

Now that you know the options available to make a successful print, it’s time to learn how to perform the necessary steps to get a perfect print.

Let’s see the steps to follow:

• The first thing you should do is go to the tab “File, 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 gave you before.
• Then press “Printer Properties” to choose the color mode.

In black and white

Depending on the printing machine, 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 print in color. Thus, you may not find the “color” tab or section 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 that you use the “economy” mode. Thus you will save ink that would otherwise be unnecessary.