Excel Guides

Leading Zeros in Page Numbers in Excel

When you create a new workbook in Excel, the default page setup for the worksheet is to have no leading zeros in page numbers. This means that if you have a three-page worksheet, the page numbers will be 1, 2, and 3. You can easily change this setting so that page numbers always display with leading zeros.

To do this, open the Page Setup dialog box by going to the File tab and selecting Print. In the Page Setup dialog box, select the Sheet tab. Then, in the Print section, click on the down arrow next to Page Number and select Custom from the drop-down menu. In the Custom Page Numbering dialog box, select 0 from the Type list and click OK.

Now when you print your worksheet, the page numbers will always display with leading zeros. For example, if you have a three-page worksheet, the page numbers will now be 001, 002, and 003.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.