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

This updated guide explains how to Part 4: Hide Sheet, Sheet Tab, Scroll Bar, Workbook through clear steps, practical examples, and important checks that help prevent common errors.

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 may need to hide a sheet in Excel like the 'Payroll T1 sheet' in the image below:

Part 4: Hide Sheet, Sheet Tab, Scroll Bar, Workbook — 1. Hide Sheet (Spreadsheet) in Excel screenshot 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 — 1. Hide Sheet (Spreadsheet) in Excel screenshot 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 — 1. Hide Sheet (Spreadsheet) in Excel screenshot 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 — 1. Hide Sheet (Spreadsheet) in Excel screenshot 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 — 2. Hide Sheet Tabs, Scroll Bar Horizontally and Vertically in Excel - 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 — 2. Hide Sheet Tabs, Scroll Bar Horizontally and Vertically in Excel

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 — 2. Hide Sheet Tabs, Scroll Bar Horizontally and Vertically in Excel

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 — 3. Hide Workbook in Excel screenshot 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 — 3. Hide Workbook in Excel screenshot 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!

social shareand social share

FAQ

What is the easiest way to Part 4: Hide Sheet, Sheet Tab, Scroll Bar, Workbook?

Start with the requirements in this guide, then follow each step in order. Check the result after every major change so problems are easier to identify.