Rightclick the worksheet tab and select View Code from the resulting Context menu Excel displays the VBA Editor Paste (or type) the above macro into the code window Close the VBA Editor Locate the XLStart folder on your system (Use the Windows search capabilities to locate the folder) Save the workbook as an Excel template using the nameQuick Tip Add worksheet name to an excel printout Go Excel Details To include the worksheet name on every sheet Start on the first worksheet, and highlight all the others by holding the control button and clicking each sheet name This will apply the footer to all the sheets at once so that you don't have to set each sheet individually1 = CELL("filename") To get the current worksheet's name, you can use the function with or without the optional reference argument, referring to any cell on the current tab 1 = CELL("filename",A1) You can also get information about any other worksheet by referring to a cell on that sheet 1
How To Easily Move Or Copy A Worksheet In Excel 13
