Is there a "see all sheets" keyboard shortcut in Excel 2013 on Windows?

7,681

I don't believe there is a direct shortcut for that dialog.

You can get similar by using a small bit of VBA in a macro, and then assigning it to a keyboard shortcut of your choice.

Sub ShowAllSheets()
  Application.CommandBars("Workbook tabs").ShowPopup
End Sub
Share:
7,681

Related videos on Youtube

Admin
Author by

Admin

Updated on September 18, 2022

Comments

  • Admin
    Admin almost 2 years

    When I right-click the arrow buttons on the bottom left corner of Excel, a window listing all sheets will be displayed (as shown below):

    [See all sheets option]

    I couldn't find any keyboard shortcut to display this, neither could I declare a new shortcut linked with this window. Is there any shortcut for this option?