![]() ![]() ![]() To take the printed output and put it in sequence we use the “Page Setup” option. In the Page Setup section, click the Page Setup button in the lower-right corner. ![]() Select the first cell, then go to Insert and choose Table. Usually this option is used for printing books or large files The dialog box will show the range selected (it will auto select all data up to the first blank row/column so make sure everything is included). 1 go to INSERT tab, and click Header& Footer command under Text group.In Header or footer drop down menu, few preset options areavailable.You can set Header / Footer to “page 1” or “ of?where the ? is for the total number of pages.In the “Page Setup” group click on the dialog box launcher in the bottom right corner.To insert page numbers in Microsoft Excel follow the below mentioned steps. If you need more customized Header/Footers…. 2 click header in your worksheet, and go to DESIGN tab, click File Path and File Name commands under Header& Footer Elements group. When you will take the printout you will get the printed output with the page numbers.After finishing all the steps click on ok.In the dialog box which opens….you will find 3 sections.ī) Some predefined data like page number, time, date or file name by clickingon thebuttons provided.Ĭ) You can add picture/ Company logo also.3 click any cell in your worksheet, and the file path and file name will be inserted into the selected header in your worksheet. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |