From the course: Excel Quick Tips

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Organize Excel Workbooks by hiding or unhiding sheets

Organize Excel Workbooks by hiding or unhiding sheets - Microsoft Excel Tutorial

From the course: Excel Quick Tips

Start my 1-month free trial Buy for my team

Organize Excel Workbooks by hiding or unhiding sheets

“

- [Instructor] A workbook containing multiple sheets can be hard to navigate and it wastes time. In Excel, you can hide specific sheets. All you have to do is right-click on a sheet and then click on Hide. Note that the sheet is still active in the sense that if some formulas are related to this sheet, they still work and these formulas are not broken. To make the sheet reappear again, you can just right-click on any of these sheets, click on Unhide, and then you will have a list of all of your hidden sheets. And if you just double-click on them, the sheet will just reappear. And now you can enjoy a clean workbook.

Contents