+3 votes
234 views
How to put page number in Excel 2019

in Office by (552k points)
reopened | 234 views

1 Answer

+4 votes
Best answer

One of the tools we use the most when working with the computer is Office. Thanks to the different programs offered by Microsoft, we can carry out multiple tasks thanks to its diversity of options such as Excel , Word, PowerPoint , etc..

One of the most used is Excel. This spreadsheet allows you to perform different actions as it has great possibilities and options for use. Excel 2019 is loaded with multiple functions that have been developed in order to facilitate and improve the experience of each user at the level of data management in their spreadsheets. We have several options to improve the administration and presentation of our work in Excel 2019 is to add the page numbers of each sheet in order to better manage each workbook.

In Microsoft Excel 2019 it will be possible to insert page numbers in the headers or footers of the pages of the worksheets worked, from the Normal view, the page numbers that we insert in the spreadsheet will not be displayed, these will only be visible in Page Layout view and on printed pages..

TechnoWikis will explain how to add page numbers in Excel 2019.

To keep up, remember to subscribe to our YouTube channel! SUBSCRIBE

Step 1

To do this we go to the sheet where the page numbers will be added, we go to the Insert menu and in the Text group we click on the Header and footer option: image
Step 2

The following window will be displayed: image
Step 3

There we go to the Design menu and in the Header and Footer Elements group we click on the Page Number option: image
Step 4

We enter text in some cells and we will see that the page number is automatically added in the upper central part: image
Step 5

We can go to lower pages and check that the respective page number is added: image

With this simple method, the page numbers in Excel 2019 will be added and, as we have mentioned, this will be visible only in the design view or when the pages of the book itself are printed. In this way it will be easier to detect a specific document on the page..


by (3.5m points)
edited

Related questions

+4 votes
1 answer
asked Mar 7, 2023 in Office by backtothefuture (552k points) | 86 views
+4 votes
1 answer
asked May 13, 2020 in Office by backtothefuture (552k points) | 468 views
+4 votes
1 answer
asked Sep 20, 2019 in Office by backtothefuture (552k points) | 281 views
+4 votes
1 answer
asked May 27, 2021 in Office by backtothefuture (552k points) | 141 views
+3 votes
1 answer
asked Sep 22, 2019 in Office by backtothefuture (552k points) | 266 views
Sponsored articles cost $40 per post. You can contact us via Feedback

Most popular questions within the last 30 days

10,659 questions
10,791 answers
510 comments
3 users