(Excel Tip-1) Print Titles
Let’s say you have headings on your table, and you want to print those headings on every page you print. In this case, you can fix “Print Titles” to print those headings on each page.
- Go to “Page Layout Tab” ➜ Page Set Up ➜ Click on Print Titles.
- Now in the page setup window go to the sheet tab and specify the following things.
- Print Area: Select the entire data which you want to print.
- Rows to repeat at the top: Heading row(s) which you want to repeat on every page.
- Columns to repeat at the left: Column(s) which you want to repeat at the left side of every page (if any).
(Excel Tip-2) Page Order
Specifying the page order is quite useful when you want to print large data.
- Go to File Tab ➜ Print ➜ Print Setup ➜ Sheets Tab.
- Now here, you have two options:
- The First Option: To print your pages using a vertical order.
- The Second Option: To print your pages using a horizontal order.
(Excel Tip-3) Print Comments
If you add comments to your reports then you can print them as well. At the end of all printed pages, you can get a list of all the comments.
- Go to File Tab ➜ Print ➜ Print Setup ➜ Sheets Tab.
- In the print section, select “At the end of the sheet” using the comment dropdown.
- Click OK.
(Excel Tip-4) Scale to Fit
Sometimes we struggle to print entire data on a single page. In this situation, you can use the “Scale to Fit” option to adjust the entire data into a single page.
- Go to File Tab ➜ Print ➜ Print Setup ➜ Page Tab.
- Next, you need to adjust two options:
- Adjust % of normal size.
- Specify the number of pages in which you want to adjust your entire data using width and length.
Instead of using the page number in the header and footer, you can also use a custom header and footer.
- Go to File Tab ➜ Print ➜ Print Setup ➜ Header/Footer.
- Click on the custom header or footer button.
- Here you can select the alignment of the header/footer.
- And the following options can be used:
- Page Number
- Page Number with total pages.
- Date
- Time
- File Path
- File Name
- Sheet Name
- Image
(Excel Tip-6) Center on Page
Imagine you have less data to print on a page. In this case, you can align it at the center of the page while printing.
- Go to File Tab ➜ Print ➜ Print Setup ➜ Margins.
- In “Center on Page” you have two options to select.
- Horizontally: Aligns data to the center of the page.
- Vertically: Aligns data to the middle of the page.
Before printing a page,, see the changes in the print preview.
(Excel Tip-7) Print Area
The simple way to print a range is to select that range and use the option “print selection”. But what if you need to print that range frequently, in that case, you can specify the printing area and print it without selecting it every time.
Go to the Page Layout Tab, click the Print Area drop-down, and then click the Set Print Area option.
Quick Read – How to Print Selected Cells in Excel
(Excel Tip-8) Custom Margin
- Go to File Tab ➜ Print.
- Once you click on print, you’ll get an instant print preview.
- Now from the bottom right side of the window, click on the “Show Margins” button.
It will show all the margins applied and you can change them just by dragging and dropping.
(Excel Tip-9) Error Values
You can replace all the error values while printing with a specific value (three other values to use as a replacement).
- Go to File Tab ➜ Print ➜ Print Setup ➜ Sheet.
- Select the replacement value from the “Cell error as” dropdown.
- You have three options to use as a replacement.
- Blank
- Double minus sign.
- “#N/A” error for all the errors.
- After selecting the replacement value, click OK.
I believe using a “Double minus sign” is the best way to present errors in a report while printing it on a page.
Related: Ignore All the Errors
(Excel Tip-10) Custom Start Page Number
If you want to start the page number from a custom number let’s say 5. You can specify that number and the rest of the pages will follow that sequence.
- Go to File Tab ➜ Print ➜ Print Setup ➜ Page.
- In the input box “First page Number”, enter the number from where you want to start the page number.
- In the end, click OK.
This option will only work if you have applied the header/footer in your worksheet.