how to insert page numbers on excel

How to Add Page Numbers in Excel

By Richard Martinez
AD

Ever needed to present a series of calculations or data analyses on Excel, only to find yourself wanting to make your document look more authoritative or professional with page numbers? Fear not, as adding page numbers to your Excel sheets is a quick and simple process that can enhance the quality of your presentations.

Before we dive into the step-by-step guide, let's address a common misconception. Unlike Word documents, Excel sheets don't inherently have a page number feature. But, with a little bit of creativity and the use of the INSERT -> TEXT -> BUILD A TABLE option, we can achieve similar results.

The Building Blocks: Tables in Excel

Tables in Excel offer robust tools for data manipulation. They provide sorting and filtering functions, as well as the ability to add totals and averages at the bottom of your data range. Once your data is inside a table, adding page numbers is a breeze.

AD
How to Insert Page Numbers in Excel (Easy Step-by-Step)
How to Insert Page Numbers in Excel (Easy Step-by-Step)
How to Insert Page Number in Excel (7 Easy Methods) - ExcelDemy
How to Insert Page Number in Excel (7 Easy Methods) - ExcelDemy
How to Insert Page Number in Word from Specific Page
How to Insert Page Number in Word from Specific Page

Here's how to insert a table: Select your data, then click on the 'Home' tab. In the 'Styles' group, click on 'Format as Table'. Choose a table style, and ensure 'My table has headers' is checked if yours does. Click 'OK' to insert the table.

Formatting Page Numbers in Excel Tables

Once your data is inside a table, add a new column for page numbers. In the first cell of this new column (for instance, A1), type "=ROW()". This Excel function automatically numbers the row where you placed it. Drag this cell down the column to apply the numbers to all rows.

How to Insert Page Number in Excel (7 Easy Methods) - ExcelDemy
How to Insert Page Number in Excel (7 Easy Methods) - ExcelDemy
Word 2016 - Page Numbers Starting from Specific Number - How to Add Insert Start Put on Pages in MS
Word 2016 - Page Numbers Starting from Specific Number - How to Add Insert Start Put on Pages in MS

Your numbers might look like "1", "2", "3", etc., but we want them to appear as classic page numbers. To fix this, select the entire column of numbers, right-click, and select 'Format Cells'. In the 'Number' tab, choose 'Custom'. In the 'Type' field, input "0;0;;0". This sets the numbers to start from 1 and count up accordingly.

Appending "Page" to Your Page Numbers

While we now have successful page numbers, we might want to prefix them with the word "Page". Insert a new column next to the one with your page numbers, and type "Page " in the first cell. Drag this cell down the column to apply it to all rows.

AD

Select the entire column with "Page ", and the entire column with your page numbers. Go to the 'Home' tab, click on 'Merge & Center'. This merges the two columns into one, resulting in "Page 1", "Page 2", and so on.

Formatting Page Numbers for Long Documents

If your document stretches across multiple Excel sheets, you'll need to add page numbers to the filenames. This is done by switching to the 'Home' tab, clicking on 'Sort & Filter', then 'Options'. In the 'Sort by' dropdown, select '(no sort)', then in 'Using' select '(not sorted or filtered)', and 'Sort left to right'. Click 'OK'.

Right-click on the tab of your document, select 'Move or Copy', and check 'Create a copy'. Name your new sheet with the correct page number in the filename. Repeat this process for all your sheets, ensuring each one has a unique page number in its name.

AD

Now, whenever you print out your Excel documents, you'll have beautifully formatted page numbers, enhancing the professionalism of your presentations and reports. Happynumbering!

AD