If you have a huge spread sheet in Excel, you may want to add page numbers. Doing so is simple, as well as you can also include them in the format of “Page X of Y”. Read on to learn exactly how.

To start, click the “Insert” tab.

In the “Text” area, click “Header & Footer”.

The “Design” tab under “Header & Footer Tools” displays. In the “Header & Footer Elements” area, click the “Page Number” button. A header is added to the spreadsheet and the arrow is put inside the header.

The code for the page number is put. Make certain the cursor desires the “& [Web page] message and include words “of”, as revealed listed below.

To add a code that inserts the overall variety of pages in the file, click “Number of Pages” in the “Header & Footer Elements” section of the “Design” tab.

You can likewise put “Page X of Y” into the header by clicking the “Header” button in the “Header & Footer” area of the “Design” tab. Select “Page 1 of?” from the drop-down menu.

The “Page X of Y” message is put into the header as well as the primary spreadsheet automatically becomes energetic once more.

Right here we showed how to insert “Page X of Y” right into the header, however the procedure coincides for the footer.