How to Insert Page Numbers to Excel Files When Printing

Date:2019-10-15 Author:Cordelia

Excel is a powerful tool in which you can process a huge amount of data. But if the file you are editing is so large that you must drag the mouse for a while to view all the content, you may want to add page numbers to the Excel file while printing it out to avoid messing the order up. For this purpose, you should:

1. Open the file you want to add page numbers and switch to Page Layout tab.

2. Then click the small arrow in the bottom right corner of Page Setup section.

How to Insert Page Numbers to Excel Files When Printing

3. Switch to Header/Footer tab in the popping out window of Page Setup, you can see the current situation of the Header and the Footer are both (none). The page numbers are usually in the footer area, so click the small arrow of Footer to open the drop-down menu.

How to Insert Page Numbers to Excel Files When Printing

4. Here I choose Page 1 of ? in the list, and then you can see the preview below the select box. If you are satisfied with the result you can hit OK to apply it to your file. Otherwise you can choose other options in the drop-down menu or click Custom Footer… to create a new template according to your actual situation.

How to Insert Page Numbers to Excel Files When Printing

How to Insert Page Numbers to Excel Files When Printing

5. Now in the Print Preview you can see the page numbers you just added. It will not show in the normal view but in the paper you print out.

How to Insert Page Numbers to Excel Files When Printing

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *