Feedback by UserVoice

 

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

← Excel for Windows (Desktop Application)

Unhide multiple worksheets at once

We can hide several worksheets at once, but we can only show them individually.

Although the VBA can solve this issue with some lines of code, but it would be a great improvement if you add this capability to Excel as a build in feature.

720 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded  · 

Thanks for logging this suggestion and for voting on it. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

thanx,
Prash
Program Manager Excel

65 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Flag as inappropriate

    https://toanhoc.org - Trang toán học miễn phí cho người mới bắt đầu. Có nhiều bài giảng hay để học sinh tiểu học, THCS, THPT tự học hay giáo viên - phụ huynh học sinh tham khảo để dạy con em mình.

  • John Harvie commented  ·   ·  Flag as inappropriate

    The ideal way would involve three options:
    1) an "all" option
    2) a hold down ctrl key and select from a drop-down or list to pick out non sequential sheets
    3) a hold down shift key to select contiguous sheets as a group
    And while we are about it, how about an option to sort and rearrange sheets by name

  • Anonymous commented  ·   ·  Flag as inappropriate

    I agree to all the comments as to being easy to hide, but a hassle to unhide multiple tabs, this needs to be built in.

  • JLS commented  ·   ·  Flag as inappropriate

    It’s ridiculous that this hasn’t already been available

  • Anonymous commented  ·   ·  Flag as inappropriate

    While a macro can be used to unhide all sheets, it would be most helpful if I could select and unhide multiple random sheets from the list without it having to be an all-or-one proposition. I would like to see a selection process similar to selecting multiple sheets for any other purpose: "Ctrl + click + click + click" to select any sheets from the list, or "Ctrl + Shift + click" to select several consecutively-listed sheets.

  • Anonymous commented  ·   ·  Flag as inappropriate

    There is a macro to unhide all sheets. While helpful I do agree that we should be able to just ctrl or shift click multiple sheets and unhide in the existing menu.

    If anybody wants help with the macro I mentioned feel free to contact me.

    jf@stedmancs.com

  • Anonymous commented  ·   ·  Flag as inappropriate

    I work with a lot of workbooks that contain many hidden sheets. Unhiding many sheets at one time would be a great time-saver.

  • CB commented  ·   ·  Flag as inappropriate

    Yes, please add feature to unhide multiple sheets. Thanks.

← Previous 1 3 4

Excel for Windows (Desktop Application): Other

Categories

Feedback and Knowledge Base

(thinking…)