Professor Excel
rename, excel, worksheets, name, sheets

Rename Excel Worksheets: Methods, Rules and Recommendations

You have to rename several worksheets in Excel? Renaming a worksheet can be troublesome, especially when you have to double-click on each sheet name separately.

Hide Worksheets or Set Them to ‘Very Hidden’

There are many worksheets in your workbook, which are old but you are afraid to delete them?

How to Get the Name of an Excel Worksheet

Often, you need to display and work with the sheet name, for example if you are working with the ‘INDIRECT’-formula. If you don’t want to type the sheet name manually – which is very unstable – there are three ways to get a sheet name:
[…]