how to add page numbers on excel for mac

Add Page Numbers On Excel How To Insert Page

In both methods, the page number can only be inserted as a header or footer.

Furthermore, the page number (as headerfooter) is not visible in the normal mode.

In the design tab, the Header Footer Tools will also be displayed.

To add the footer in the left side, click on the left section box.

To add the footer on the right side, click on the right section box.

To add the footer in the center, click in the center section box.

You can skip clicking Page number and add Page to the section where you want the page number to appear on the page.

To do this, go to the View tab, and click on Normal given in the Workbook Views group.

There will be a preview that will show how the page number will appear.

Suppose you have two worksheets in which you want to add the page numbers firstly, select both the worksheets.

In method 1, you can directly specify on which side the page number is to be displayed.

Also, you do not want to display Page and only want the page number.

In the Left section, add the title you want to display and in the Center section, add Page (or select the box containing ) to display the page number.

If there are a total of two pages, it will display Page 1 of 2.

Auto option starts numbering pages from 1 (for the first page of the print job) or from the sequential number of the print job.

In this case, we have the names of the students and the marks they have obtained in five different subjects.

You may wish to have all these marks and students names be displayed in a single page.

On the Page tab in the dialogue box, change the First-page number.

Add Page Numbers On Excel How To Insert Page

Here we discuss how to Insert Page Numbers in Excel with examples and downloadable excel templates.

CFA And Chartered Financial Analyst Are Registered Trademarks Owned By CFA Institute.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

How To Add Page Numbers On Excel For Mac