how to change page number in excel

How To Change Page Numbers in Excel

By Brian Robinson
AD

Need to adjust the page numbers in your Excel document? Microsoft Excel allows you to customize page layouts, including page numbers, to best suit your needs. Here, we'll guide you through how to change page numbers in Excel, ensuring your documents look professional and polished.

Before we dive in, remember that changing page numbers in Excel is different from adjusting them in Word. In Excel, you'll be working with Print Areas and Page Breaks to control your page numbers.

Understanding Print Areas and Page Breaks

Print Areas and Page Breaks are key to controlling page numbers in Excel. A Print Area is the range of cells that print when you send a document to the printer. Page Breaks, on the other hand, determine how data wraps onto new pages. Let's explore how to manage these to change page numbers.

AD
How to Change Page Number in Excel (With Easy Steps) - ExcelDemy
How to Change Page Number in Excel (With Easy Steps) - ExcelDemy
How to Change Page Number in Excel (With Easy Steps) - ExcelDemy
How to Change Page Number in Excel (With Easy Steps) - ExcelDemy
How to Change Page Number in Excel (With Easy Steps) - ExcelDemy
How to Change Page Number in Excel (With Easy Steps) - ExcelDemy

First, set your Print Area. Select the data you want to print, then click on the 'Page Layout' tab. In the 'Print' group, click 'Print Area' > 'Set Print Area'. This tells Excel where to start printing and sets the range for your page numbers.

Setting Page Breaks

Now, let's insert Page Breaks to control where your data wraps onto new pages. This is where you'll effectively change page numbers. To insert a Page Break:

How to Change Page Number in Excel (With Easy Steps) - ExcelDemy
How to Change Page Number in Excel (With Easy Steps) - ExcelDemy
How to Change Page Number in Excel (With Easy Steps) - ExcelDemy
How to Change Page Number in Excel (With Easy Steps) - ExcelDemy
  • Select the cell below where you want the break.
  • Go to the 'Page Layout' tab.
  • In the 'Page Setup' group, click 'Breaks' > 'Insert Page Break'.

Changing Page Numbers

Finally, let's update your page numbers. Excel automatically generates page numbers based on your Print Area and Page Breaks. To display page numbers:

  • Go to the 'Insert' tab.
  • In the 'Text' group, click the '_page'\_ symbol to insert a page number.
  • To change the appearance of your page numbers, right-click on them and select 'Format Page Numbers'.

Customizing Your Page Numbers

Sometimes, you might need to Number pages differently, like restarting numbering with each section or including chapter names in the page numbers. For this, you'll use the & '[Page]' and & '[Chapter]' codes in your page number.

AD

Suppose you want your page numbers to include the chapter name and restart at 1 for each new chapter. Type & '[Chapter] - ' in your page number, then the text you want for your chapter. For the actual page numbers, use & '[Page]' without parentheses. When you print, Excel includes the chapter name and restarts page numbers at 1 for each new chapter.

That's it! Now you know how to change page numbers in Excel, giving your documents a cohesive, polished look. Ready to format your next report? Excel's got you covered. Happy formatting!

AD