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: Show Start Your Free Excel Course Excel functions, formula, charts, formatting creating excel dashboard & others
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 120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access 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 TabSuppose 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 ExcelWe 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 LayoutSometimes, 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 LayoutYou 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 LayoutIf 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
Recommended ArticlesThis is a guide to Page Setup in Excel. Here we discuss How to Setup Page in Excel along with practical examples and downloadable excel template. You can also go through our other suggested articles – How do I apply the same print settings to all worksheets?Select [Print] in the [File] menu. You can also select [Print Entire Workbook] in [Settings] to select all the worksheets. On the displayed print screen, select the device you are using → click [Printer Properties]. Select the settings on the print settings screen, as required.
How do I apply a print layout to an entire workbook?Click the File tab. Click on the Print option. In the Print page, click on the Print setting drop-down. Click on Print Entire Workbook.
How do I make all Excel sheets landscape?Change the page orientation in the worksheet. Select the worksheet or worksheets for which you want to change the orientation. How to select worksheets. ... . On the Page Layout tab, in the Page Setup group, click Orientation, and then click Portrait or Landscape.. |