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
Related videos on Youtube
![Admin](/assets/logo_square_200-5d0d61d6853298bd2a4fe063103715b4daf2819fc21225efa21dfb93e61952ea.png)
Author by
Admin
Updated on September 18, 2022Comments
-
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):
[
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?