Excel - Page numbers in depth Tutorial

In this video, you will learn about page numbers in depth in the Microsoft 365 environment.
The video covers how to effectively use page numbers in your documents and demonstrates the various options and settings available.
This will help you create professional-looking documents and navigate through them easily.

3:06
3470 views

Available in Microsoft365

Objectifs :

This video tutorial aims to teach users how to add and configure page numbers in the headers and footers of an Excel worksheet, including how to customize page numbering and manage different headers and footers for odd and even pages.

Chapitres :

Introduction to Headers and Footers
Adding page numbers to a worksheet is a common use of headers and footers in Excel. This feature helps organize printed documents and makes it easier for readers to navigate through multiple pages.
Inserting Page Numbers
To add page numbers, follow these steps: - Go to the Insert tab. - Click on the Header and Footer button. - On the Design tab, select either the header or footer button. - Choose an option from the dropdown list, such as 'Page 1 of', to insert page numbers into the header or footer.
Understanding Predefined Headers and Footers
Be aware that using predefined headers and footers will overwrite any existing ones. By default, Excel numbers and prints pages from top to bottom and then left to right. For instance, if a table does not fit on the first page, the second page will be to the right.
Adjusting Page Layout
To ensure pages are numbered correctly: - Click on the Page Layout tab. - Select Print Titles. - In the Page Setup dialog box, navigate to the Sheet tab, select 'Over, then down', and click OK. This adjustment will correct the page numbering.
Customizing Page Numbering
If you want the page numbers to start at a number other than 1 (for example, 3): - Double-click the section with the page number after the right square bracket. - Type a '+' sign followed by the number you want to start from (e.g., '2' for starting at 3). - Click anywhere in the worksheet, and the page numbers will now start at 3, resulting in a first page number of 12, followed by 2.
Different Headers and Footers for Odd and Even Pages
Excel allows for different headers and footers on odd and even pages. For example, you might want even page numbers on the left side and odd page numbers on the right side: - In the Design tab, check the option for different odd and even pages. - On page one, select the right section in the header or footer and click page number. - On page two, select the left section and click page number again.
Conclusion
In this video, you learned how to use the ribbon to add and configure page numbers in the headers and footers of a worksheet. For other sheet types, such as chart sheets, headers and footers can only be inserted through the Page Setup dialog box. For more information, refer to the article 'Headers and Footers in a Worksheet' on Office.com.

FAQ :

How do I add page numbers to my Excel worksheet?

To add page numbers, go to the Insert tab, click on the Header and Footer button, and select a predefined option from the dropdown list, such as 'Page 1 of X'.

Can I start page numbering from a number other than 1?

Yes, you can start page numbering from a different number by double-clicking the page number section in the header or footer and typing the desired starting number.

What is the difference between odd and even page headers and footers?

Odd and even page headers and footers allow you to customize the content displayed on odd-numbered pages versus even-numbered pages, such as placing page numbers on different sides.

How do I configure print titles in Excel?

To configure print titles, click on the Page Layout tab, then click on Print Titles in the Page Setup dialog box, where you can specify rows or columns to repeat on each printed page.

Can I add headers and footers to chart sheets in Excel?

Headers and footers can only be added to chart sheets and embedded charts through the Page Setup dialog box, not through the ribbon.

Quelques cas d'usages :

Creating Professional Reports

When preparing a professional report in Excel, adding page numbers in headers and footers ensures that the document is organized and easy to navigate, especially for multi-page reports.

Printing Financial Statements

For financial statements that span multiple pages, using the Print Titles feature allows key information to be repeated on each page, while page numbers help in referencing specific sections.

Designing Academic Papers

Students can use headers and footers to include their names and page numbers in academic papers, adhering to formatting guidelines required by educational institutions.

Creating Marketing Materials

In marketing materials, using different headers and footers for odd and even pages can enhance the visual appeal and provide a professional touch, such as placing a logo on one side and page numbers on the other.

Organizing Project Documentation

For project documentation that includes multiple worksheets, adding consistent headers and footers with page numbers helps keep the documents organized and makes it easier for team members to reference specific pages.

Glossaire :

Header

A header is a section at the top of each page in a document that can contain text, images, or page numbers.

Footer

A footer is a section at the bottom of each page in a document that can contain text, images, or page numbers.

Page Layout Tab

A tab in Excel that allows users to adjust the layout settings of a worksheet, including print titles and page numbering.

Print Titles

A feature in Excel that allows users to specify rows or columns to repeat on each printed page.

Page Setup Dialog Box

A window in Excel where users can configure various settings for printing, including headers, footers, and page layout.

Odd and Even Pages

Refers to the distinction between pages that are numbered as odd (1, 3, 5, etc.) and even (2, 4, 6, etc.), allowing for different headers and footers on each.

Predefined Headers and Footers

Standard header and footer options provided by Excel that can be quickly applied to a worksheet.

00:00:04

common uses of headers and footers.

00:00:08

You can use a predefined header or footer option to add page numbers.

00:00:13

On the Insert tab, click the header and footer button,

00:00:18

on the Design tab, click the header or footer button.

00:00:23

There are many options and they're the same for header and footer.

00:00:28

Click an option from the dropdown list, such as Page 1 of ?

00:00:34

and page numbers are added to the header of footer of the worksheet.

00:00:37

As you probably noticed,

00:00:39

predefined headers and footers overwrite existing headers and footers.

00:00:44

By default, Excel numbers and prints pages from the top down,

00:00:49

and then left to right on the worksheet.

00:00:52

In this example, page 2 should be the page to the right,

00:00:56

since the table couldn't all fit on page 1.

00:01:00

To fix this, click the Page Layout tab,

00:01:05

and click Print titles.

00:01:08

In the Page Setup dialog box, on the sheet tab,

00:01:12

click Over, then down and click OK.

00:01:18

And the pages are now numbered correctly.

00:01:21

If you want page numbers to start at a number other than 1,

00:01:24

3 for example,

00:01:27

double click the section with a page number,

00:01:30

after the page right square bracket, type a + sign,

00:01:36

the number you want to increase the pages by,

00:01:39

2 in this example and a space.

00:01:43

Click anywhere in the worksheet and the page numbers now start at 3.

00:01:48

If you don't type the space,

00:01:51

in this example you'll get a first page number of 12,

00:01:55

page 1 followed by the number 2.

00:02:00

You can have different headers and footers on odd and even pages.

00:02:04

For example, you might want to show even page numbers on the left side,

00:02:09

and odd page numbers on the right side of printed pages.

00:02:14

In the Design tab, check different odd and even pages.

00:02:20

On page one in the header or footer,

00:02:23

select the right section and click page number.

00:02:28

On Page 2, in the header or footer,

00:02:32

select the left section and click page number again.

00:02:38

In this video, you saw how to use the ribbon to add and

00:02:42

configure page numbers in the headers and footers of a worksheet.

00:02:47

For other sheet types such as chart sheets

00:02:50

and for embedded charts, you can insert headers and footers

00:02:54

only by using the page setup dialog box.

00:02:58

For information about this, see the article:

00:03:01

Headers and Footers in a Worksheet on office.com.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

2503 Views

Video Training Microsoft Excel - Intermediate level

Increase your scope of action with our intermediate tutorials dedicated to formulas, advanced visual enhancement and data analysis with pivo...

ALL COURSES