EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Excel Tips Page Setup in Excel

Page Setup in Excel

By Madhuri ThakurMadhuri Thakur

Page Setup in Excel

Page Setup in Excel (Table of Contents)

  • Introduction to Page Setup in Excel
  • How to Setup Page in Excel?

Introduction to Page Setup in Excel

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:

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.

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:

page setup in excel 1

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.

page setup in excel 1-1

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

page setup in excel 1-2

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.

page setup in excel 1-3

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

page setup in excel 2-1

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.

page layout 2-2

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

page layout 2-3

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

Page Orientation 3-1

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

Page Orientation 3-2

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.

Page Orientation 3-3

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.

Printing Page 4-1

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

Printing Page 4-2

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

Printing Page 4-3

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

Print Title 5-1

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

Print Title 5-2

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.

Print Title 5-3

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.

Recommended Articles

This 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 –

  1. Spelling Check in Excel
  2. Excel Insert Page Break
  3. Page Numbers in Excel
  4. How to Print Labels From Excel
MICROSOFT POWER BI Training
48+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
MS Excel & VBA for Data Science
128+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
All-in-One Financial Analyst Masters Training Program
1000+ Hours of HD Videos
43 Learning Paths
250+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
All in One Data Science Bundle (360+ Courses, 50+ projects)
1500+ Hour of HD Videos
80 Learning Paths
360+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Popular Course in this category
MS Excel Course
 223+ Hours of HD Videos
35 Courses
13 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.9
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Excel Course

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

Download Page -Setup- Excel- Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Page -Setup- Excel- Template

EDUCBA

डाउनलोड Page -Setup- Excel- Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Hurry! - Any Learning Path @ $19 | OFFER ENDING IN ENROLL NOW