Page Setup in Excel

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

To make the page comes on a single page, we need to set up the page. To setup, the page follows the below steps in Excel.

To setup, the page follows the below steps in Excel.

  1. Go to the Page Layout tab click on the small arrow mark under the page setup group.


    Page Setup Example 1-5

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


    Page Setup Example 1-6

  3. In the below window, “Fit to 1 Page”.


    Page Setup Example 1-7

  4. Click on print preview in the same window to see the preview of the same.


    Page Setup Example 1-8

  5. Now, we can see the print preview.


    Page Setup Example 1-9

This looks on one page but not able to read properly. In the same print preview window, change the orientation from Portrait to Landscape.

Page Setup Example 1-11

Now our print preview looks like this.

Page Setup Example 1-10

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.

Page Setup Example 1

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, i.e., data range from A1:N32. After selecting the data range, go to PAGE LAYOUT >>> Print Area >>> Set Print Area.

Page Setup Example 1-1

This will set up the print area.

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

Shortcut key to setup

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, 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.

Page Setup Example 1-2

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

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

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

Page Setup Example 1-3
Page Setup Example 1-4

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

The reaming columns M & N will come in the next pages.

Print Rows and Column Headings Along with the Data

Not only the data we can print, 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 as well. Row headings are represented by numbers, and column headings are represented by alphabets.

Heading Example 1

In order to print these rows and columns headers along with the data, we need to make some settings.

Go to the PAGE LAYOUT tab click on the small arrow mark under 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.

Heading Example 1-1

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

Heading Example 1-2

In the above window, click on the “Sheet” tab. Under this tab, we have several options. Check the box “Row and Column Headings,” then click on “Print Preview” to see the view.

Heading Example 1-3

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

Heading Example 1-4

Print Data Headers in all the Pages

Once the data extended to multiple sheets, we don’t get data headers on all the pages; this makes the report reading very difficult. So, in these multiple printing sheets, we need to change the settings to “Repeat the rows.”

In the Page Set up excel window go to the Sheet tab; in this tab, we have an option called “Rows to repeat at top.”

data Example 4

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

data example 4-1

Things to Remember Here

Recommended Articles

This has been a guide to Page Setup in Excel. Here we discuss how to use page setup in Excel along with practical examples and downloadable templates. You may learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>