Sheet Options, Adjust Margins and Page Orientation in Excel

Last updated on Sep 27 2021
Hitesh Doshi

Table of Contents

Sheet Options, Adjust Margins and Page Orientation in Excel

Sheet Options

MS Excel provides various sheet options for printing purpose like generally cell gridlines aren’t printed. If you want your printout to include the gridlines, Choose Page Layout » Sheet Options group » Gridlines » Check Print.

microsoftExcel 80
microsoftExcel

Options in Sheet Options Dialogue

Print Area − You can set the print area with this option.
Print Titles − You can set titles to appear at the top for rows and at the left for columns.
Print −
o Gridlines − Gridlines to appear while printing worksheet.
o Black & White − Select this check box to have your color printer print the chart in black and white.
o Draft quality − Select this check box to print the chart using your printer’s draft-quality setting.
o Rows & Column Heading − Select this check box to have rows and column heading to print.
Page Order −
o Down, then Over − It prints the down pages first and then the right pages.
o Over, then Down − It prints right pages first and then comes to print the down pages.

Adjust Margins in Excel

Margins

Margins are the unprinted areas along the sides, top, and bottom of a printed page. All printed pages in MS Excel have the same margins. You can’t specify different margins for different pages.
You can set margins by various ways as explained below.
• Choose Page Layout » Page Setup » Margins drop-down list, you can select Normal, Wide, Narrow, or the custom Setting.

microsoftExcel 81
microsoftExcel

• These options are also available when you choose File » Print.

microsoftExcel 82
microsoftExcel

If none of these settings does the job, choose Custom Margins to display the Margins tab of the Page Setup dialog box, as shown below.

microsoftExcel 83
microsoftExcel

Center on Page

By default, Excel aligns the printed page at the top and left margins. If you want the output to be centered vertically or horizontally, select the appropriate check box in the Center on Page section of the Margins tab as shown in the above screenshot.

Page Orientation in Excel

Page Orientation

Page orientation refers to how output is printed on the page. If you change the orientation, the onscreen page breaks adjust automatically to accommodate the new paper orientation.

Types of Page Orientation

Portrait − Portrait to print tall pages (the default).
Landscape − Landscape to print wide pages. Landscape orientation is useful when you have a wide range that doesn’t fit on a vertically oriented page.

Changing Page Orientation

• Choose Page Layout » Page Setup » Orientation » Portrait or Landscape.

microsoftExcel 84
microsoftExcel

• Choose File » Print.

microsoftExcel 85
microsoftExcel

So, this brings us to the end of blog. This Tecklearn ‘Sheet Options, Adjust Margins and Page Orientation in Excel’ blog helps you with commonly asked questions if you are looking out for a job in Microsoft Excel. If you wish to learn Excel and build a career in Business Intelligence domain, then check out our interactive, Microsoft Power BI Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Microsoft Power BI Training

Microsoft Power BI Training

About the Course

Microsoft Power BI Training at Tecklearn will help you achieve expertise in business analytics Our best online training course teaches you all important concepts like Power BI Desktop, Mobile, Power Query & Power Pivot, Data modelling, visualization, creating dashboards and reports, DAX, etc. As part of this program, you will work on real-world projects. Also, our Power BI course curriculum will equip you with all the key skills that are required to clear the Microsoft Power BI Certification exam (70-778).

Why Should you take Microsoft Power BI Training?

• The average annual pay for a Power BI Professional is $114,000 . -PayScale.com.
• Cognizant, Dell, KPMG, Hitachi, Wipro, Avanade, Annik Inc, Brillio and 45,000 MNCs across 185 countries use Power BI and it has a market share of around 7% globally.
• Microsoft Power BI has been ranked at No.1 position in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms for 13 consecutive years.

What you will Learn in this Course?

Introduction to Microsoft Power BI
• Microsoft Power BI Introduction
• Power BI Products
• Power BI Architecture
• Installing Power BI
• Connecting to Data Sources
Power BI Workflow
• Key features of Power BI workflow
• Power BI Vs MSBI
• History of Power BI
• Power BI Products
• Data modelling and relationships
Power Query for Data Transformation
• Power Query for Data Transformation
• Learning about Power Query for self-service ETL functionalities
• Working with Excel data
• Introduction to Query Editor
• Data transformation
• Pivot and UnPivot
• Merge Join, relational operators, date, time calculations, working with M functions
• Summary Tables
• Writing custom functions and error handling
• M advanced data transformations
Filters and Drill Down Report
• Visualization Filter
• Page Level Filter
• Report LEVEL Filter
• DRILL Through Filter or Report
• BookMark Report
Power Pivot for Data Modelling
• What is SSAS
• Data Modelling
• Star Schema
• Snowflake Schema
• Introduction to MDDB and Tabular
• Data Access Modes
• Tabular with DAX
• Power BI with DAX
• DAX Functions
Data Analysis Expression – DAX Queries
• TABULAR with DAX
• Power BI with DAX
• Calculated Members, Row, Filter & Evaluation Context
• Cumulative Charts
• Calculated Tables, ranking and rank over groups
• DAX advanced features
Power BI Desktop & Administration
• Reports and Visualization
• Learning about data modelling and data relationships
• Deploying data gateways
• Reports and Dashboards
• On Premises Data Gateway
• Gateway Clusters
Introduction to Power Q & A
• Power Service
• Power Q & A best practices
• Integrating with SaaS applications
• Gateway

 

 

0 responses on "Sheet Options, Adjust Margins and Page Orientation in Excel"

Leave a Message

Your email address will not be published. Required fields are marked *