How do I set the page before printing?

Often you may come up with a situation where you need to print the excel sheet which you have with yourself, containing some important data that needed to be shared as a hard copy. In such cases, you will be strongly in need of page setup. It becomes easy for you to print the pages once you are well aware of how you can do the same under Microsoft Excel. There are several operations involved under page setup like:

Table of Contents Show

How to Setup Page in Excel?
Things to Remember About Page Setup in Excel
Recommended Articles
How do I change the page before printing?
How do you set a page to print?
How do I change the page orientation when ready to print?
How do I set up page settings?

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Setting margins for top, bottom, left and right.
Adding header or footer to the excel sheet you are going to print.
Page views: Portrait, landscape or custom.
Setting printing area etc.

We will go through all the page setup settings and options one by one in this article. It is really very easy under excel to setup the page before printing and previews it to make some amendments as per your need/requirement.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)

Price
View Courses

120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (62,536 ratings)

How to Setup Page in Excel?

Page Setup in Excel is very simple and easy. Let’s understand in detail how to setup page in excel.

You can download this Page -Setup- Excel- Template here – Page -Setup- Excel- Template

#1 – Page Setup Using Excel View Tab

Suppose we have data as shown below:

Note: Not all of the data portion is visible in this screenshot.

We will see how a basic page setup can be done using Excel’s View tab, present under the top ribbon.

Click on View tab under Excel ribbon which is placed at the top of your sheet. You’ll see multiple operations under two options: “Workbook Views” and “Show”. Under Workbook views, you have different view types: Normal view, Page Break Preview, Page Layout, Custom Views.

Click on “Page Break Preview”. It will break your page according to the printing area as shown below.

Click on Page Layout option and it will show you the excel sheet in a page layout. It already has Header option by default (I will add ‘Person wise Sales Data’ as a title). Under Show option, you can check or uncheck different options like Ruler, Gridlines, etc.

#2 – Setting up Margins in Excel

We often come up with a situation where the columns from your printing page are occupying the entire page and still have one column, not fitting into the page and it goes to the next printing page for that document. In order to tackle this issue, we can use the margins button/options present under the Page Layout tab in Excel.

Click on the Page Layout tab in excel. You will see a range of operations available each of them consisting of several options.

Under “Page Layout”, click on the “Margins” button, you will see different margin options. There are ideally 4 of them: Last Custom Settings, Normal, Wide and Narrow margins. You can select anyone as per your requirement.

Click on “Narrow” margins, it will narrow down margins and will have more space to acquire the columns.

#3 – Page Orientation under Page Layout

Sometimes, adjusting margin only will not include all your data columns on one page, in that case, you may need to change the page orientation.

Go to “Page Layout” tab and select the Orientation button situated beside the Margins button.

As soon as you click on the Orientation button, you will see two options: Portrait and Landscape.

By default, the orientation is in Portrait form. Change it to Landscape so that all your columns can be visible in one single printing page.

Note: Though we are making these amendments/layout settings, data used in this example might not need all those page layout settings. It is just that, we wanted to make you aware of all the page layout settings in one single article.

#4 – Adjusting the Size of Printing Page under Page Layout

You can also change the size of the page in order to get a proper printing page. Go to “Page Layout” tab and click on “Size” button under it. This option allows you to set the paper size for your document when it gets printed.

A series of different paper options will appear there. Like Letter, Legal, A4, A3, etc. by default, it will be set to “Letter” page size (As we have changed the orientation to Landscape).

Click on”A4″ to set the page size as A4 (this is the most widely used paper size while printing any document).

#5 – Print Titles Under Page Layout

If your data is long which means it has a large number of rows (say 10,000) it will not fit on one page anyway. It will go on multiple pages. However, the main concern with this is, the column titles are only visible on the first page. What about the next pages where data is populated. It becomes hectic to decide which column is for what. Therefore, having column titles on each page is something which is mandatory while setting page.

Click on “Page Layout” tab and go to “Print Titles” button. Click on that button.

As soon as you click on “Print Titles” button, a new “Page Setup” window will pop up under which “Sheet” option is active (As you have clicked on Print Titles).

Under it, click on “Rows to repeat at the top option”. This option allows you to add the rows with a title on each page. Once you click on it, you will be in nee q d to select the row ranges which you want to print at the top of every printing page. In our case, it is $A$1:$D$1. Here, in this Sheet option, we also can set the printing area, columns that we want to repeat at the top, etc. Click on OK once done with the amendments.

This is how we setup page before printing in Excel. Let’s wrap the things up with some things to remember.

Things to Remember About Page Setup in Excel

You can also add custom margins under Page Layout in Excel.
Print titles and report header, both are different. Print Title prints the title of each column on multiple pages whereas the report header is the header of the report/main title of the report.
If you want to remove the print titles, go to Page Setup under Print Titles section, select the Sheet tab, and remove the rows provided under Print Titles section.

How do I change the page before printing?

Scale the sheet size for printing.

On the Page Layout tab, select Page Setup..

On the Page tab, select the Fit To check box..

In the Page wide by box, enter 1 (for one-page wide)..

In the Tall box, enter 0 so that the number of pages tall is unspecified..

On the File menu, click Print..

How do you set a page to print?

Set one or more print areas.

On the worksheet, select the cells that you want to define as the print area. Tip: To set multiple print areas, hold down the Ctrl key and click the areas you want to print. ... .

On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area..

How do I change the page orientation when ready to print?

Change the page orientation when you are ready to print In the Print dialog box, click Properties. In the printer properties dialog box, in the Layout tab, under Orientation, click Portrait or Landscape, and click OK. When you are ready to print, click Print.