Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Insert Page Numbers On Worksheets. Select all your sheets click on Sheet1 tab press Shift and click on last sheet tab. Insert page numbers on a single worksheet.
3 from encrypted-tbn0.gstatic.com
In Excel there are two methods to insert page numbers in excel. Open the worksheet to which you would like to add sequential numbering and select the Insert tab from the text group. You can insert page numbers on multiple worksheets in your workbook by using.
You can insert page numbers on multiple worksheets in your workbook by using.
In both methods the page number can only be inserted as a header or footer. You can insert page numbers on multiple worksheets in your workbook by using. Another way is via macro but I really think this would suit better. Insert page number function starts from 1 at each new worksheet.