A header is the information that appears at the top of each printed page and a footer is the information that appears at the bottom of each printed page. By default, new workbooks do not have headers or footers.

Adding Header and Footer

• Choose Page Setup dialog box » Header or Footer tab.

Header and Footer, Page Break and Set Background in Excel

You can choose the predefined header and footer or create your custom ones.
• &[Page] − Displays the page number.
• &[Pages] − Displays the total number of pages to be printed.
• &[Date] − Displays the current date.
• &[Time] − Displays the current time.
• &[Path]&[File] − Displays the workbook’s complete path and filename.
• &[File] − Displays the workbook name.
• &[Tab] − Displays the sheet’s name.

Other Header and Footer Options

When a header or footer is selected in Page Layout view, the Header & Footer » Design » Options group contains controls that let you specify other options −

• Different First Page − Check this to specify a different header or footer for the first printed page.
• Different Odd & Even Pages − Check this to specify a different header or footer for odd and even pages.
• Scale with Document − If checked, the font size in the header and footer will be sized. Accordingly if the document is scaled when printed. This option is enabled, by default.
• Align with Page Margins − If checked, the left header and footer will be aligned with the left margin, and the right header and footer will be aligned with the right margin. This option is enabled, by default.

Insert Page Break in Excel

Page Breaks

If you don’t want a row to print on a page by itself or you don’t want a table header row to be the last line on a page. MS Excel gives you precise control over page breaks.

MS Excel handles page breaks automatically, but sometimes you may want to force a page break either a vertical or a horizontal one. so that the report prints the way you want.

For example, if your worksheet consists of several distinct sections, you may want to print each section on a separate sheet of paper.

Inserting Page Breaks

Insert Horizontal Page Break − For example, if you want row 14 to be the first row of a new page, select cell A14. Then choose Page Layout » Page Setup Group » Breaks» Insert Page Break.

Insert vertical Page break − In this case, make sure to place the pointer in row 1. Choose Page Layout » Page Setup » Breaks » Insert Page Break to create the page break.

Removing Page Breaks

• Remove a page break you’ve added − Move the cell pointer to the first row beneath the manual page break and then choose Page Layout » Page Setup » Breaks » Remove Page Break.

• Remove all manual page breaks − Choose Page Layout » Page Setup » Breaks » Reset All Page Breaks.

Set Background in Excel

Background Image

Unfortunately, you cannot have a background image on your printouts. You may have noticed the Page Layout » Page Setup » Background command. This button displays a dialogue box that lets you select an image to display as a background. Placing this control among the other print-related commands is very misleading. Background images placed on a worksheet are never printed.

Alternative to Placing Background

• You can insert a Shape, WordArt, or a picture on your worksheet and then adjust its transparency. Then copy the image to all printed pages.
• You can insert an object in a page header or footer.

So, this brings us to the end of blog. This Tecklearn ‘Header and Footer, Page Break and Set Background 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

580