For the printing process to arrange the Excel spreadsheets in the correct order, you must number the pages before printing. However, you have not yet mastered 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 pages The quickest and easiest to use in the article below.
How to number pages in an Excel spreadsheet
Benefits of Page Numbering in Excel
Microsoft Excel is a popular tool used in the office sector, especially in the accounting department. This tool supports the work of calculating sources of income and expenses, profits and salaries of companies.
Page numbering in Excel is a useful tip for office workers, especially accountants. Excel page numbering provides users and viewers with many benefits such as:
-
Viewers can easily check information, use and evaluate Excel documents.
-
The numbering of the pages shows the professionalism of the person setting up the Excel table.
-
Supports organizing process clean and in the right order after printing.
-
Page numbering in Excel helps editors avoid data confusion.
The page numbering trick in Excel brings many benefits to users. However, not everyone knows and can use this little trick. Therefore, to use it effectively, you can refer to the easy and quick Excel page numbering methods below.
How to number pages in Excel quickly and easily
Here are some simple, quick and effective ways to number pages in Excel spreadsheets:
How to Number Pages in Excel Using Page Layout
Number pages using layout
Numbering pages in Excel using Page Layout requires a simple operation:
-
Step 1: Open the Layout window, the Layout section will appear directly in the toolbar. Then continue clicking to open the layout.
Open the layout in the Layout tab
-
2nd step: The Header/Footer tab appears on the screen. Here you proceed to set the header/footer page number. Select Custom Header if you are numbering the top of the page or Custom Footer if you are numbering the bottom of the page.
Set number of header/footer sheets
-
Step 3: You click on the position where you want to select numbering on the left (Left section), numbering in the middle (Center section) or on the right side of the text page (Right section). Next, select Insert Page Number which is the pound symbol located in the middle of the spreadsheet screen.
Insert page number icon
Numbering Excel pages by adding a header/footer via the 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.
Number the sheets using the Insert tab
-
2nd step: Find and select the position where you want to number the Excel page: Number on the left, right or in the middle of the worksheet. Then you select Page Number to complete the numbering of the sheets.
Select the page numbering position and select Page Number to finish
How to number pages using Layout view in the View tab
In addition to numbering pages in an Excel table using the Insert tab, you can do so by selecting the View tab. Follow the steps below:
Number pages using the View tag
-
Step 1: Select Layout mode on the View tab. In Layout view, you can set an additional header/footer at the desired position.
Select Layout mode on the View tab.
-
2nd step: Click the Design tab after selecting the Add Header or Add Footer position. Select Page Number to add page numbers as desired.
Add header/footer using View tag
Above, here are these How to number pages in Excel Quick and easy to use for office workers. Hopefully this useful information will help you work faster when working in Excel.
