Professor Excel
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?

thumbnail, copy, paste, exact, ranges, exact ranges, persist, preserve

How to Compare Two Lists in Excel

Let’s assume, we have the following (although realistic) challenge: We got two lists which should have the same items in Excel. But they aren’t exactly the same so that we need to compare them. But how do we find out the best way, which items are missing in either one of the lists? Instead of comparing manually, there are some easy steps. […]

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