Enter SheetNames into the name field Enter the following formula into the Refers to field =REPLACE (GETWORKBOOK (1),1,FIND ("",GETWORKBOOK (1)),"") Hit the OK button In a sheet within the workbook enter the numbers 1,2,3,etc into column A starting at row 2 and then in cell B2 enter the following formula and copy and paste it down theSyntax SHEET (value) The SHEET function syntax has the following arguments Value Optional Value is the name of a sheet or a reference for which you want the sheet number If value is omitted, SHEET returns the number of the sheet that contains the functionEXCEL METHOD 1 Insert sheet name into footer 1 Select the sheet in which you want to insert the sheet name in the footer Note In this example we have selected Sheet1, which will display this name in the footer 2 Select the Insert tab 3 Select the Text group
Sheet Name Code Excel Download Template Formula Example
