Read the Beforeitsnews.com story here. Advertise at Before It's News here.

By Stock Kevin (Reporter)
Contributor profile | More stories

Story Views
Now:
Last hour:
Last 24 hours:
Total:

Excel Tip #12 - Unhide All Sheets From View At One Time

Wednesday, February 12, 2014 21:37

% of readers think this story is Fact. Add your two cents.

How to Unhide More Than One Sheet in Excel At A Time

If you work in auditing, finance, accounting, or work with a lot of modeling, you are constantly dealing with Excel workbooks that have multiple tabs or sheets. We are constantly changing our workbooks by adding more tabs or taking tabs away. Sometimes we don’t want to delete a sheet because we fear that we will need it later, so we hide it. While nine out of ten times we end up not needing that tab, there is that one out of ten chance when we want to recall that tab we hid last week and also the other twenty we hid a month ago.

Microsoft Excel did not do a great job of building in a function to unhiding multiple tabs at once. In fact it is non-existent in Microsoft Excel 2010. One way we can unhide all twenty tabs is manually right-clicking on the tabs and select ‘Unhide’. Alternatively you can right-click and then hit “U” to unhide. This is okay if we want to unhide one tab, but to have to do this twenty times can be cumbersome. Who has time to unhide all the sheets in a workbook one at a time?

Macro solution to unhiding all the tabs instantaneously

Refer to the below five step process:

1) Hit Alt + F11 (this will open the VBE Window)

2) From the ‘Insert Menu’ select ‘Module’ and paste the code below.

Sub UnhideAllSheets()

Dim wks As Worksheet

For Each wks In ActiveWorkbook.Worksheets

If wks.Visible = False Then

wks.Visible = xlSheetVisible

End If

Next wks

End Sub

3) Select ‘References’ from the ‘Tool Menu’ and make sure ‘Microsoft Forms 2.0 Object Library’ is selected. If it’s not listed then click ‘browse’ and select ‘Fm20.dll’

4) Close the VBE window

5) Hit Alt + F8, select ‘UnhideAllSheets’, click ‘Options’ and set your shortcut key.

Source: http://www.stockkevin.com/2014/02/excel-tip-12-unhide-all-sheets-from.html

Before It’s News® is a community of individuals who report on what’s going on around them, from all around the world.

Anyone can join.
Anyone can contribute.
Anyone can become informed about their world.

"United We Stand" Click Here To Create Your Personal Citizen Journalist Account Today, Be Sure To Invite Your Friends.

Please Help Support BeforeitsNews by trying our Natural Health Products below!

Order by Phone at 888-809-8385 or online at https://mitocopper.com M - F 9am to 5pm EST

Order by Phone at 866-388-7003 or online at https://www.herbanomic.com M - F 9am to 5pm EST

Order by Phone at 866-388-7003 or online at https://www.herbanomics.com M - F 9am to 5pm EST

Humic & Fulvic Trace Minerals Complex - Nature's most important supplement! Vivid Dreams again!

HNEX HydroNano EXtracellular Water - Improve immune system health and reduce inflammation.

Ultimate Clinical Potency Curcumin - Natural pain relief, reduce inflammation and so much more.

MitoCopper - Bioavailable Copper destroys pathogens and gives you more energy. (See Blood Video)

Oxy Powder - Natural Colon Cleanser! Cleans out toxic buildup with oxygen!

Nascent Iodine - Promotes detoxification, mental focus and thyroid health.

Smart Meter Cover - Reduces Smart Meter radiation by 96%! (See Video).

Comments

Online:
Visits:	1,601,119,728
Stories:	8,143,328