Excel Tips 19 - Hide and Unhide Worksheets in Excel

Quickly hide and unhide worksheets in Microsoft Excel 2007. This allows you to clean up the appearance of your workbooks in Excel and to hide raw data. This technique also allows you to reference the data on the hidden worksheet even though you can't see it. You will also briefly see how to link cells between worksheets and how to use the quick-fill handle between separate and hidden worksheets in Excel.

Have a great day!

[vanzypubg]

🙂 all is good and well until you click looking for unhide and it's greyed out because the sheet you hid was protected and now you can't even unprotect it because the sheet is hidden

You just saved me BIG TIME! Thank you so much

[MrsElento]

Thanks !!! You saved my life with this tip!!!

[sujathavenupediredla]

excel is hell. its absolutely true. its giving me real hard time and thanks for your time

[ravikiranch]

How to hide right click option on sheet tabs

Do you really need to do that test in order to hide the tab ?