In order for the printing process to be arranged in the correct order of the Excel worksheets, you need to number the pages before printing. However, you do not master all the operations in Excel. And I don’t know how to number pages in Excel quickly and easily for all versions. We will tell you how to number excel sheets The fastest, easiest to handle in the article below.
How to Number Pages in Excel Spreadsheets
Benefits of Page Numbering in Excel
Microsoft Excel is a popular tool used in the office building, especially the accounting department. This tool supports the calculation of business income and expenses, profit and salaries.
Page numbering in Excel is a useful trick for office buildings, especially accountants. Excel sheet numbering gives users and viewers many benefits such as:
-
Viewers can easily check information, use and evaluate Excel documents.
-
The page numbering shows the professionalism of the person setting up the excel sheet.
-
Support neat and orderly arrangement after printing.
-
Page numbering in Excel helps editors avoid confusing data.
The page numbering trick in Excel provides users with many benefits. However, not everyone knows and uses this little trick. So, for efficient use, you can refer to the easy and quick ways to number Excel sheets below.
How to Number Pages in Excel Quickly and Easily
Here are some easy, quick and effective ways to number pages in Excel spreadsheets:
How to Number Pages in Excel with Page Layout
Page numbering with layout
Page numbering in excel with Page Setup, you just need to do a simple operation:
-
Step 1: Open the Layout window, the layout item will appear directly on the toolbar. Then you continue to click open layout.
Open the layout in the Layout tab
-
2nd step: The Header/Footer tab appears on the screen. Here you proceed to setting the number of header/footer pages. Select Custom Header if it’s numbered at the top or Custom Footer if it’s numbered at the bottom.
Set Number of Header/Footer Sheets
-
Step 3: You click where you want to select numbering on the left (Left Section), numbering in the middle (Center Section) or right of the text page (Right Section). Then, by selecting Insert Page Number, the pound symbol is in the middle of the sheet screen.
Insert page number icon
Numbering excel sheets by adding header/footer via Insert toolbar is also quite simple. Just follow these simple steps:
-
Step 1: Open the Insert tab and find the Header/Footer toolbar in the Text group.
Numbered sheets with the Insert tab
-
2nd step: Find and select the position you want to number on the Excel sheet: Number the left, right or middle of the sheet. Then you select the Page Number item to complete the sheet numbering.
Select the page number position and select the Page Number item to complete
How to number pages using the Layout view in the View tab
In addition to numbering the pages of the Excel sheet with the Insert tab, you can manipulate it by selecting the View tab. Follow the steps below:
Page numbering with the View tag
-
Step 1: Select the Layout view in the View tab. In Layout view, you can set more Header/Footer at your desired position.
Select the Layout view in the View tab
-
2nd step: Click the Design tab after selecting the Add Header or Add Footer location. Select Page Number to add the desired number of pages.
Add Header/Footer with View Tab
here are the How to Number Pages in Excel Quick and easy operation for office workers. Hope this useful information will help you to handle faster when working on Excel.
