You can do this too
Download “The one essential add-in for all Excel users.'”
“Working in Excel will be fun again with all these extra supersmart tools”
ASAP Utilities, description of our Excel tools
Language:
Sheets » Change name of selected sheets to selected cell's value
With this utility you can rename the selected worksheets based on the value in a certain cell.You can rename all selected worksheets by giving them as a name the value of for example cell A1 on each worksheet.
Screenshots
Starting this utility
In the Excel menu choose: ASAP Utilities » Sheets » Change name of selected sheets to selected cell's value« Return to the list of “Sheets” tools.
| « Previous Rename current sheet... | Next » Insert sheet(s) name in selected cell(s) |
 - 750px - ribbon.png "Download ASAP Utitilities")
Download ASAP Utitilities
Additional keywords for this tool:
Tab, Tabs, Sheetname, rename worksheet as cell value, name sheets from cell value, change sheet name, rename sheet name with value in current cell, set name
Tab, Tabs, Sheetname, rename worksheet as cell value, name sheets from cell value, change sheet name, rename sheet name with value in current cell, set name
Follow ASAP Utilities on Facebook
© 1999-2013 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands 
Connect with us and receive our "tip of the week" at:
