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
- 4173 views
-
Excel - Insert columns and rows
- 4:16
- Viewed 4616 times
-
Excel - 3D Maps
- 1:41
- Viewed 6774 times
-
Excel - Advanced formulas and references
- 4:06
- Viewed 4952 times
-
Excel - Cell references
- 1:34
- Viewed 4866 times
-
Excel - How things are organized
- 1:58
- Viewed 4734 times
-
Excel - A closer look at the ribbon
- 3:55
- Viewed 5465 times
-
Excel - Start using Excel
- 4:22
- Viewed 5062 times
-
Excel - Print worksheets and workbooks
- 1:07
- Viewed 4416 times
-
Remove a watermark
- 2:20
- Viewed 40358 times
-
Change the default font for your emails
- 1:09
- Viewed 24577 times
-
Collapsible headings
- 3:03
- Viewed 20529 times
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Viewed 20425 times
-
Activate the features of Teams Premium
- 3:48
- Viewed 19798 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 17193 times
-
Create automatic reminders
- 4:10
- Viewed 13207 times
-
Protect a document shared by password
- 1:41
- Viewed 12113 times
-
Morph transition
- 0:43
- Viewed 11286 times
-
Add a sound effect to a transition
- 3:45
- Viewed 10830 times
-
Can you request the deletion of your data ?
- 01:40
- Viewed 4 times
-
GPDR : 4 simple reflexes
- 05:07
- Viewed 7 times
-
is a professional email address considered personal data ?
- 00:07
- Viewed 4 times
-
Is GPDR only for the marketing department ?
- 01:41
- Viewed 4 times
-
GDPR : Explained simply
- 04:44
- Viewed 7 times
-
Block the transfer of a Teams meeting
- 02:40
- Viewed 34 times
-
Control the start of recording and transcription in Teams
- 03:03
- Viewed 34 times
-
Manage access to recordings and transcripts in Teams
- 02:59
- Viewed 27 times
-
Enable voice isolation in Teams
- 02:14
- Viewed 45 times
-
Add a collaborative page to a Teams channel
- 03:06
- Viewed 29 times
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.