I'll show you how to hide worksheets in Excel so that a user cannot see them but you can still access data on them.
This method is the simplest way to hide a sheet and it will still allow you to easily access it when you need to. This is especially good when you want to hide a source data tab or simply reduce clutter in the workbook.
Result:
Notice that Sheet1 is now gone.
Result:
This is a simple and easy way to hide a worksheet in Excel but it is not secure. Anyone to whom you send this workbook can unhide the worksheet and read what's in it or change what's in it.
This method is good for hiding tabs that don't need to be visible to everyone and that might cause them confusion. For example, you will often want to hide any tabs that contain raw data, because you don't want a user to accidentally corrupt that data; but only use this method to hide the raw data if it's not a big deal if the user does see it.