Follow Us on Facebook

Khmer Dictionaries

Follow us on Twitter


Search More Information

Wednesday, March 5, 2014

Hide or Show Worksheet Tabs in Excel

Option 1: Using advance option in the Microsoft Excel
File Menu à Options à Advanced à Scroll down à Display options for this workbook: 
þ Show Sheet Tabs à to show sheet tabs
¨ Show Sheet Tabs à to hide all sheet tabs

Note: When you hide all sheet tabs you are unable to move to other sheets in the workbook. So you need to create links to other sheets before hiding all sheets.

Hide or Show Worksheet Tabs, Excel 2007, Excel 2010, Advanced Excel, 

Option 2: Using Visual Basic Application (VBA)
File Menu à Options à Customize Ribbon à Tick þ Developer à OK 

à Insert à Module à Double click on Module and then copy and paste code below.


Post a Comment

Like Me on Facebook

Donation by PayPal

Blog Archive