Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Multiple sheet Unhide option..

Unhiding multiple sheets is a painful task, you have to go one by one. There should be an option to unhide multiple sheets at once.

Please bring in this feature.

Thanks.

88 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

4 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Pablo commented  ·   ·  Flag as inappropriate

    yes, definitely yes. Have it so can have same select options as you do for visible sheets. Using Ctrl or Shift

  • Carol commented  ·   ·  Flag as inappropriate

    Here's a workaround for Office 2016 until--yeah right--Microsoft addresses the problem.

    Open the VBA screen with Alt F11. In the Immediate window at the bottom of the screen, type in

    For Each s In Sheets: s.Visible = True: Next

    and hit Enter. I've saved this coding in a Word document so I just copy and paste whenever I need it. Hope this helps.

Feedback and Knowledge Base