As you do that a new tab will open, on this tab select the option Place in This Document from the left side panel. Next, select any cell on the sheet and right click on it to open the options menu. Now you can change the name of the sheet by clicking on it and then select Rename option from the menuģ. ![]() For inserting a new sheet press shift+F11, as you do that a new page will be added to your worksheet.Ģ. Now, to create an index you will have to insert a new blank page to your already created worksheet. Launch Excel on your computer and open the worksheet in which you want to create a table of content. Method 1: Create A Table Of Contents In Excel Using Hyperlinksġ. By using the hyperlink you can make it easy to navigate to a particular sheet/content in the workbook by just clicking on its link. To create an index in your worksheet you can make use of hyperlinks.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |