How to Set up Page in Excel? (5 Easy Steps)

To make the page come on a single page, we need to set up the page. First, we must follow the steps below to set up the page in Excel.

It looks on one page but is not able to read properly. Change the orientation from “Portrait” to “Landscape” in the same print preview window.

  • First, go to the “Page Layout” tab and click on the small arrow mark under the “Page Setup” group. Once you click on a small arrow mark, it will open up the below dialog box. In the below window, in”Fit to:” write 1 page. Click on “Print Preview” in the same window to see the same preview. Now, we can see the print preview.

Now, our print preview looks like this.

How to Change the Default Page Setup in Excel?

Below are the steps to change the default page setup in Excel.

Step #1 – Setup Print Area

The first thing we need to do while printing is to set the print area. For example, look at the below data in a worksheet.

First, select the print areaPrint AreaIn Excel, the print area is the portion of the workbook or worksheet that we wish to be printed rather than the entire workbook or worksheet. From the page out tab, we can set up a print area. In addition, a single worksheet can contain numerous print areas.read more; data range from A1:N32. After selecting the data range, go to PAGE LAYOUT »> Print Area »> Set Print Area.

It will set up the print area.

The shortcut key to set up the print area is ALT + P + R + S.

Step #2 – Page Break View

Once the print area is set up, we cannot simply print the data because the data is not in order. For example, we must press Ctrl + P to see the Print previewPrint PreviewPrint 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.

As we can see in the above image, data is not coming in order from column A to column L. Instead, it is coming on one page, and the remaining portion is coming on other pages.

So, if we print like this, we cannot read the report properly.

To check which data is coming in the first sheet and which is coming in the second sheet, go to the VIEW tab and click on “Page Break Preview.”

In the above image, we can see the “Page Break Preview.” The blue line (next to column L) is the indication that column A to column L belongs to Page 1.

The remaining columns, M and N, will come in the next pages.

Not only can we print the data, but we can also print excel rows and columnsExcel Rows And ColumnsA cell is the intersection of rows and columns. Rows and columns make the software that is called excel. The area of excel worksheet is divided into rows and columns and at any point in time, if we want to refer a particular location of this area, we need to refer a cell.read more headings. Numbers represent row headings, and alphabets represent column headings.

We need to make some settings for printing these rows and column headers along with the data.

Go to the “PAGE LAYOUT” tab and click on the small arrow mark under the “Page Setup” group in ExcelGroup In ExcelThe “Group” is an Excel tool which groups two or more rows or columns. With grouping, the user has an option to minimize and maximize the grouped data.read more.

Once you click on the small arrow mark, it will open up the below dialog box.

In the above window, click on the “Sheet” tab. Under this tab, we have several options. First, check the “Row and column headings” box, then click on “Print Preview” to see the view.

As shown in the below image, we can see row and column headings.

Once the data is extended to multiple sheets, we do not get data headers on all the pages. It makes the report reading very difficult. So, in these numerous printing sheets, we need to change the settings to “Repeat the rows.”

In the “Page Setup” Excel window, go to the “Sheet” tab. This tab has an option called “Rows to repeat at top.”

In this option, a cursor inside the box chooses the data header row to repeat the headers in all the print pages. Click on “OK.” It will repeat the row at the top in all the sheets.

Things to Remember Here

  • We must first set up the print area.It depends on the data size. But, first, we need to choose an orientation style.We can repeat excel row headersExcel Row HeadersExcel Row Header is the grey column on the left side of column 1 in the worksheet that contains the numbers (1, 2, 3, etc.). To hide or reveal row and column headers, press ALT + W + V + H.read more and column headers.We can also repeat data headers in all the printing sheets.

This article is a guide to Page Setup in Excel. We discuss using page setup in Excel, practical examples, and downloadable templates. You may also learn more about Excel from the following articles: –

  • Print Preview in ExcelInsert Page Break in ExcelPrint Titles in ExcelPrint Excel GridlinesExcel Shortcut for Merge and Center