Continuing the " Very comprehensive guide to all types of data hiding in Excel", TipsMake introduces you to Part 4: Hide Sheet, Sheet tab, Scroll Bar, Workbook
In life and work, there are always secrets that we want to keep a secret, want it to be hidden, and so is in Excel.To continue part 1, part 2, part 3:
TipsMake will show you how to hide Sheet, Sheet tab, Scroll bar, Excel Workbook in Part 4.
1. Hide Sheet (spreadsheet) in Excel
TipsMake, for example, you want to hide a sheet in Excel like the 'Payroll T1 sheet' in the image below:
Follow these steps:
- Step 1: Go to Format in Cells group of Home tab.
- Step 2: Select Hide Sheet in 'Hide & Unhide'.
And here is the result, as you can see, Sheet 'Payroll T1' is gone, leaving only 'Payroll T2' and 'Payroll T3'.
To show the hidden sheets again, just repeat the hidden sheet steps, then select 'Unhide Sheet'.
2. Hide Sheet tabs, Scroll bar horizontally and vertically in Excel
To hide Sheet Tab and Scroll bar according to the above example, follow these steps:
- Step 1: Go to Microsoft Office Button in Office 2007 version or go to File in other Office versions, then select 'Excel Options'
- Step 2: Go to the following address: Advanced - Display Options for This Workbook (remember to select the Workbook name) then uncheck the following items:
+ Show horizontal scroll bar: display the horizontal scroll bar
+ Show vertical scroll bar: display vertical scroll bar.
+ Show sheet tabs: hide tabs containing spreadsheets.
And here is the result, as you can see, there is no tab to select the sheet anymore, even the vertical and horizontal scroll bars disappear.
3. Hide Workbook in Excel
To hide Workbook in Excel, go to the View tab on the Ribbon, then select Hide as shown below:
And here is the result, to show you again select Unhide in the View tab
Part 4 - Hide Sheet, Sheet tab, Scroll Bar, Workbook in the 'Extremely useful guide to all types of data hiding in Excel' series is over. If you have any questions or suggestions please leave us a comment . TipsMake wish you success and see you in the following sections, promising many interesting things!