Professor Excel

Insert Sheet Name In Cell: Easy! 3 Methods to Return the Worksheet Name

Often, you need to insert and work with the sheet name in an Excel sheet, for example if you are working with the ‘INDIRECT’-formula. Or, if you want to dynamically change headlines depending on the sheet name. If you don’t want to type the sheet name manually – which is very unstable – there are three ways to get a sheet name

[…]
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.

VERY HIDDEN: How to Hide an Excel Sheet.

Very Hidden: How to 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?