EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tips Page Setup in Excel
Secondary Sidebar
Excel Functions
  • Excel Tips
    • Recover Document in Excel
    • Excel Shortcut to Select Row
    • Excel Header Row
    • Excel Insert Button
    • Excel Translate
    • Budget in Excel
    • KPI Dashboard in Excel
    • Blank Invoice Excel Template
    • Write Formula in Excel
    • Auditing Tools in Excel
    • Autofit Row Height in Excel
    • Formatting Text in Excel
    • Add Rows in Excel Shortcut
    • Divide Cell in Excel
    • Compare Two Columns in Excel for Matches
    • Excel Troubleshooting
    • Unprotect Excel Workbook
    • Subtract Date in Excel
    • Carriage Return in Excel
    • Negative Numbers in Excel
    • Worksheets in Excel
    • Excel Match Multiple Criteria
    • Exponential Moving Average Formula
    • Sentence Case in Excel
    • Excel Reverse Order
    • Excel Timesheet Template
    • Weighted Average in Excel
    • CTRL Shift-Enter in Excel
    • Excel Expense Tracker
    • INDEX MATCH Function in Excel
    • Percent Change in Excel
    • Drag and Drop in Excel
    • Shade Alternate Rows in Excel
    • Excel Database Template
    • Inverse Matrix in Excel
    • New Line in Excel Cell
    • Format Cells in Excel
    • Excel Text with Formula
    • Project Management Template in Excel
    • Vlookup vs Index Match
    • Embedded in Excel
    • Count Colored Cells in Excel
    • Excel Hacks
    • Column Header in Excel
    • Database Function in Excel
    • Excel Spell Check
    • Linear Interpolation in Excel
    • Convert Excel to CSV
    • Excel Not Responding
    • Delta Symbol in Excel
    • Excel Mortgage Calculator
    • Excel Show Formula
    • Break Links in Excel
    • VLOOKUP Examples in Excel
    • Alternate Row Color Excel
    • Checklist in Excel
    • Microsoft Office Tips
    • Excel vs Access
    • Excel Change Case
    • Count Characters in Excel
    • Formula Bar in Excel
    • Invoice Template in Excel
    • Find and Replace in Excel
    • PowerPivot in Excel
    • Wildcard in Excel
    • Line Break in Excel
    • NULL in Excel
    • Text Formula in Excel
    • Family Tree in Excel
    • Insert Calendar in Excel
    • Page Setup in Excel
    • Search For Text in Excel
    • Switching Columns in Excel
    • 3D Cell Reference in Excel
    • Roadmap Template in Excel
    • Cell References in Excel
    • Excel Automation
    • Matching Columns in Excel
    • Evaluate Formula in Excel
    • How to Find Mean in Excel
    • How to Add Cells in Excel
    • Project Timeline in Excel
    • TODAY Formula in Excel
    • Poisson Distribution in Excel
    • YEAR Formula in Excel
    • REPLACE Formula in Excel
    • Create Spreadsheet in Excel
    • SEARCH Formula in Excel
    • HYPERLINK Formula in Excel
    • Pivot Table with Multiple Sheets
    • COLUMNS Formula in Excel
    • DAY Formula in Excel
    • RIGHT Formula in Excel
    • INDIRECT Formula in Excel
    • Excel IRR Formula
    • Pivot Table Sort
    • OR Formula in Excel
    • Pivot Table Formula in Excel
    • How to Edit Drop Down List in Excel?
    • WEEKDAY Formula in Excel
    • Chart Wizard in Excel
    • Time Difference in Excel
    • Lookup Table in Excel
    • SUBTOTAL Formula in Excel
    • LOOKUP Formula in Excel
    • Themes in Excel
    • Group Worksheets in Excel
    • Excel ISNUMBER Formula
    • 3D Maps in Excel
    • VLOOKUP Tutorial in Excel
    • Moving Columns in Excel
    • Grouping Columns in Excel
    • Excel Formula of Percentage
    • Excel Leading Zeros
    • Timesheet in Excel
    • Nested IF Formula in Excel
    • SUMIF Formula in Excel
    • Concatenation in Excel
    • Excel Insert Page Break
    • LEN Formula in Excel
    • Insert Comment in Excel
    • Excel Print
    • Fractions in Excel
    • Excel Add a Column
    • Borders in Excel
    • Excel Sum by Color
    • Excel vs Google Sheets
    • Calculate Percentage Increase in Excel
    • Excel Format Phone Numbers
    • Excel Search Box
    • Excel vs CSV
    • Excel vs Numbers
    • Excel Concatenate Date
    • Excel Bullet Points
    • Calculate Compound Interest in Excel
    • Find External Links in Excel
    • Excel Comma Style
    • Excel Remove Leading Spaces
    • Combine First and Last Name in Excel
    • How to Calculate Ratio in Excel
    • SUMPRODUCT Function with Multiple Criteria
    • Create Excel Template
    • Excel Greater than or Equal
    • Excel Keyboard Shortcuts
    • Excel Row vs Excel Column
    • Excel Operators
    • Excel Text Compare
    • Excel Uppercase Function
    • Excel Auto Numbering
    • Watermark in Excel
    • Excel Delete Row Shortcut
    • Excel Word Count
    • Row Count in Excel
    • Excel Grade Formula
    • Excel Percentage Difference
    • Excel Rows and Columns
    • Excel Group
    • Excel Move Columns
    • Excel Row Height
    • Excel Sparklines
    • Excel Drawing a line
    • Multiple IFS in Excel
    • Excel Strikethrough
    • Numbering in Excel
    • Share Excel Workbook
    • Excel Shortcut For Merge Cells
    • Excel OneDrive
    • Excel Track changes
    • Excel Hide Formula
    • Excel Filter Shortcuts
    • Excel 3D Reference
    • Protect Excel Workbook
    • Excel Moving Averages
    • Excel Row Limit
    • Excel Absolute Value
    • Excel Print Area
    • Excel Format Painter
    • Excel Separate text
    • Excel Autofit
    • Excel Columns to Rows
    • Excel Paste Shortcut Option
    • Excel Rows to Columns
    • Excel Insert Row Shortcut
    • Excel Extensions
    • Excel Unmerge Cells
    • Divide in Excel Formula
    • Excel Compare Two Columns
    • Not Equal To Excel
    • Excel Remove Duplicates
    • Excel Remove Spaces
    • Excel Calculate Age
    • Copy Excel Sheet
    • Excel Conditional Formatting Based on Another Cell Value
    • Excel Cell Reference
    • Excel Split Cell
    • Excel Circular Reference
    • Highlight Every Other Row in Excel
    • Errors in Excel
    • Excel Delete Pivot Table
    • Excel Pivot Table
    • Subtraction in Excel
    • Count Unique Values in Excel
    • Excel Highlight Duplicates
    • Excel Data Formatting
    • Random Numbers in Excel
    • Basic Excel Formulas
    • Page Numbers in Excel
    • Excel CAGR Formula
    • Excel Combine cells
    • IFERROR with VLOOKUP in Excel
    • Column Sort in Excel
    • Print Comments in Excel
    • Cheat Sheet of Excel Formulas
    • Remove Hyperlinks in Excel
    • Excel Drop Down List
    • Remove (Delete) Blank Rows in Excel
    • Relative Reference in Excel
    • Subscript in Excel
    • Superscript in Excel
    • Excel Insert Multiple Rows
    • Excel Absolute Reference
    • Unhide Columns in Excel
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL COURSE
  • Online Excel Data Analysis Course
  • Excel for Finance Course

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:

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

Start Your Free Excel Course

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

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:

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,725 ratings)

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
Popular Course in this category
All in One Excel VBA Bundle (120+ Courses)
  120+ Online Courses |  500+ Hours |  Verifiable Certificates |  Lifetime Access
4.9
Price

View Course

Related Courses

Excel Training (23 Courses, 9+ Projects)4.9
Excel Data Analysis Training (17 Courses, 8+ Projects)4.8
Excel for Finance Training (18 Courses, 7+ Projects)4.7
0 Shares
Share
Tweet
Share
Primary Sidebar
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

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

EDUCBA
Free Excel Course

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

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

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

EDUCBA Login

Forgot Password?

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

EDUCBA
Free Excel Course

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

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

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

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

Let’s Get Started

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

EDUCBA

Download Page -Setup- Excel- Template

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