How to Print in Excel?
Print is one of the most common tasks performed in Excel. It is a print of a specific selection on a worksheet, a print area (one or more range of cells), or a range of data.
Top 12 Useful Tips to Consider Before Taking a Print in Excel
Let us look at how to print with multiple options and criteria.
#1- Check Whether the Printer is Connected or Not
Once your printer is installed, ensure it is connected to your computer. Then, you can join or add a printer in Excel using the “File” and “Print” options.
In Excel, click on the “File” > “Print” option.
The printer dropdown menu appears, and click “Add Printer.”
Set your default printer
- Open the “Devices” and “Printers” dialog box.In the “Search” box, type “Devices and Printers,” then click “Devices and Printers.”Under “Printers,” right-click the printer you want as your default printer and click “Set as default printer.”
#2 – Printing a Worksheet Either in Landscape or Portrait Orientation
The below-mentioned steps can do it. But, initially, you must select the worksheet or worksheets for which you want to change the orientation.
You can apply page orientation to multiple or adjacent sheets by clicking the tab for the first sheet. Then, hold down the “Shift” key while you click the tab for the last sheet or other sheets you want to select.
#3 – Setting a Print area
Set a print area where you can define or develop a print area for selected data. In “Print Area” option allows you to choose specific cells on a worksheet that can be printed off separately from the rest of the page based on the selection.
The print area can be done by the procedure below, open an Excel worksheet containing data, and highlight the cells you want to take a printout. Next, click the “Print Area” option on the “Page Layout” tab. Then, in the “Page Setup” section, select “Set Print Area.”
It will save the print area once you save the workbook. Now, whenever you want to take a printout of that worksheet, it will consider only printing the data defined in the print area. Therefore, it is better to clear the print area once you have taken the printout. The below-mentioned steps can do the print area: go to the “Page Layout” tab -> “Print Area” > “Clear Print Area.”
#4 – Page Breaks in a Worksheet
If the document will print over or contains multiple pages, you can control its layout by adding page breaks or deleting page breaks in a worksheet.
Usually, by default, Excel inserts automatic page breaks based on the paper size, scale options, margin settings, and the positions of any manual page breaks you insert.
You can adjust the page breaks if you want to print out an exact number of pages.
In”Page Break Preview,” by default, dashed lines are page breaks that are automatically added. At the same time, solid lines are page breaks that are added manually.
#5 – Page Layout & Print Preview
You have an option to print with or without gridlines in the printed data.
Under the “Page Layout” tab, in the “Gridlines” heading of “Sheet” options, ensure to select the checkbox of “Print.”
Now, when you take a printout of your document, you may get lines between the cells.
Under the “Page Layout” tab, under the heading of “Sheet” options, if you want row numbers and column alphabet to appear, you can select the checkbox of “Print.” Then, when you take a printout of your document, it will appear in the top and left corners.
#6 – Number of Spreadsheet Report Copies
Suppose, if you want to take a printout, “1” copy by default appears. You can make multiple copies by clicking on the arrows next to the copies box. You can take a printout on both sides of the paper or a single side based on the printer you use.
#7 – Collate the Pages of Each Copy (Either collated or Uncollated)
If Excel contains multiple pages, you can switch between “Collated” and “Uncollated” options. E.g., if you want to take a printout of 3 copies, “Collated” may print the entire first copy, then the whole second copy, and the later third one, etc. In comparison, “Uncollated” prints three copies of page 1, three copies of page 2, and later three copies of page 3.
#8 – Change the Paper Size Based on your Requirement
#9 – Change the Page Margins from the Default Normal Margins to Either Wide or Narrow
#10 – Scaling options
Suppose you miss out last rows or columns on a single page, then you can consider “Width,” “Height,” and “Scale” options in “Print” options or the “Scale to Fit” group in the “Page Layout” tab to change these settings.
#11 – Addition of Headers and Footers in a Worksheet
Consider row or column headers on top of every page or not (a header appears at the top of every printed page, whereas a footer appears at the bottom of every printed page).
Here, we have selected Page 1 as a header. Under the “Header” option of “Page Setup,” we can observe at the top of the page when we check the print preview in excelPrint Preview In ExcelPrint preview in Excel is a tool used to represent the print output of the current page in the excel to see if any adjustments need to be made in the final production. Print preview only displays the document on the screen, and it does not print.read more. We can customize it based on the choice.
Similarly, under the “Footer” option of “Page Setup,” we have selected “wallstreetmojo.com”
You can observe it at the bottom of the page when we check the print preview. We can customize it based on the choice.
#12 – Print resolution or Print quality for a worksheet.
It depends on the type of printer you use. However, it will appear in the “Print quality” option under the “Page Setup” window.
Things to Remember
In Excel, we can also take a print of Excel comments. For that, we must select “As displayed on sheet” under the “Comments” section of the sheet in page setup”Page”Toread more.Later you can check the “Print Preview” Excel option, where the comment section appears at the specific cell.
Various print-out options
You can take a printout of an entire worksheet or workbook or make a selection.
Recommended Articles
This article is a guide to Print in Excel. Here, we provide the top 12 useful tips to print an Excel sheet like a pro, including page break, page area, Excel print preview, header and footers in Excel, margins, and more. You may learn more about excel from the following articles –
- Print in VBAPrint Labels From ExcelPrint Comments in ExcelPrint Titles in ExcelFind Links in Excel
