Do you know how? page numbering in Excel? Do you know any really quick ways to do this? If the answer is no, then why not read this article right away? GhienCongListen? Guaranteed you will be able to number pages extremely accurately and quickly in less than 30 seconds.
How to number pages in Excel on a sheet
To be able to number pages in Excel on a worksheet, you just need to follow the simple steps below:
Advertisement
Step 1: Switch sheet mode to Page Layout by looking at the bottom right hand side of the sheet, select the 2nd icon:
Advertisement
Step 2: Your sheet will now switch to the view shown below.
Advertisement
Step 3: Above and below the spreadsheet there will be 2 spaces and 2 lines of “Add header” and “Add footer“. If you want to number the pages in Excel at the top of the worksheet, select Add headerotherwise, choose Add footer.
Step 4: When you put the mouse on either of the above two positions, Excel will automatically switch you to the Header & Footer.
Step 5: At this point, choose Page Number.
Step 6: At the location where you double click, you will see the text &[Page]. When exiting mode Page Layout and return to mode thường, the text above will automatically become your page number. If you want to display “Page 1“, please add the word “Page“forward, become”Page &[Page]“.
So with just 6 simple steps, you can manually number pages in Excel on a sheet.
How to number pages in Excel on multiple sheets
The above method can only help you to number pages on a single sheet that you manipulate. If you want to do it only once, but even the other sheets are numbered, then refer to this how to:
Step 1: In the card Homeyou find the item Page Setupselect the arrow to expand the dialog box Page Setup.
Step 2: Selection table Page Setup appears, now look for the card Header/Footer and choose Custom Header or Custom Footer.
Step 3: In this menu, click on one of the three places where you want to number the pages in Excel (left, center or right), then select the icon Insert page number.
Step 4: You will see the symbol &[Page] Dã appears at the position where you originally placed the mouse. Finally, press OK to finish setting up page numbering in Excel.
How to number pages in Excel as desired on the first page
For example, the first page you do not want it to start at number 1 but number 2, number 3, 4 or 5, you can completely adjust and set this up in Excel.
To do this, first open the dialog box Page Setup. Next, at the card Page First, you enter the number you want the first page to start in the blank box at the First page number.
After entering, you just need to press OK to complete. You will see that the next pages will be counted starting from the next number immediately after the number you entered.
Change the order of page numbering in Excel
Unlike Word, when Excel prints your worksheet, it will split into worksheets that are the right size for your paper. You can completely change the page numbering order in Excel for these worksheets with the Page Setup tool. In this tool, select the Sheetfind the item Page order.
There are 2 sort orders that you can choose from: Down, then over (from top to bottom, from left to right) or Over, then down (from left to right, top to bottom).
After choosing, you choose OK to complete the setup.
How to remove page numbering in Excel
If you want to remove page numbering in Excel, the first step you will need to do is open the dialog box Page Setup and find the card Header/Footer. Next, you choose both items Header and Footer to choose (none) and press OK to complete.
Previously marked page numbers will be completely removed after this step.
See more:
Hopefully with the ways to number pages in Excel that GhienCongList introduces, you can already number your sheets and spreadsheets yourself. This absolutely does not take too much time but can help you become a lot more professional.
Source: Pocket immediately 5 ways to number pages in Excel very quickly
– TechtipsnReview