Part 4: Hide Sheet, Sheet tab, Scroll Bar, Workbook

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:

Part 4: Hide Sheet, Sheet tab, Scroll Bar, Workbook Picture 1

Follow these steps:

- Step 1: Go to Format in Cells group of Home tab.
- Step 2: Select Hide Sheet in 'Hide & Unhide'.

Part 4: Hide Sheet, Sheet tab, Scroll Bar, Workbook Picture 2

And here is the result, as you can see, Sheet 'Payroll T1' is gone, leaving only 'Payroll T2' and 'Payroll T3'.

Part 4: Hide Sheet, Sheet tab, Scroll Bar, Workbook Picture 3

To show the hidden sheets again, just repeat the hidden sheet steps, then select 'Unhide Sheet'.

Part 4: Hide Sheet, Sheet tab, Scroll Bar, Workbook Picture 4

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'

Part 4: Hide Sheet, Sheet tab, Scroll Bar, Workbook Picture 5
- 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.

Part 4: Hide Sheet, Sheet tab, Scroll Bar, Workbook Picture 6

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.

Part 4: Hide Sheet, Sheet tab, Scroll Bar, Workbook Picture 7

3. Hide Workbook in Excel

To hide Workbook in Excel, go to the View tab on the Ribbon, then select Hide as shown below:

Part 4: Hide Sheet, Sheet tab, Scroll Bar, Workbook Picture 8

And here is the result, to show you again select Unhide in the View tab

Part 4: Hide Sheet, Sheet tab, Scroll Bar, Workbook Picture 9

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!