Home

Keyboard shortcut to get a list of Excel sheets to select from

%3CLINGO-SUB%20id%3D%22lingo-sub-394254%22%20slang%3D%22en-US%22%3EKeyboard%20shortcut%20to%20get%20a%20list%20of%20Excel%20sheets%20to%20select%20from%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394254%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20tried%20researching%20an%20answer%20to%20this%20question%20online%20in%20general%20and%20on%20this%20community%20board%2C%20but%20none%20that%20I%20found%20appear%20to%20apply%20to%20the%20Mac%20version%20of%20Excel%202019.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20find%20the%20keyboard%20shortcut%20that%20produces%20a%20list%20of%20all%20the%20Excel%20sheets%20in%20a%20given%20workbook%20from%20which%20I%20can%20select%20any%20sheet.%20%26nbsp%3BI%20have%20a%20particular%20workbook%20that%20has%2075%20sheets.%20%26nbsp%3BIt%20is%20easy%20to%20go%20to%20the%20beginning%20or%20end%20of%20the%20workbook%20using%20the%20Command%20key%2C%20but%20I%20don't%20know%20how%20to%20produce%20the%20list%20of%20all%20the%20sheets.%20%26nbsp%3BNavigating%20to%20a%20sheet%20in%20the%20middle%20of%20the%20workbook%20is%20tedious.%20%26nbsp%3BIt%20must%20be%20possible%20to%20do%20what%20I%20want%20since%20I%20hit%20some%20combination%20of%20keys%20by%20accident%20that%20resulted%20in%20the%20selectable%20list%2C%20but%20I%20am%20unable%20to%20recreate%20that%20keystroke%20combination.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20any%20suggestions%20you%20have%20to%20offer.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-394254%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-401334%22%20slang%3D%22en-US%22%3ERe%3A%20Keyboard%20shortcut%20to%20get%20a%20list%20of%20Excel%20sheets%20to%20select%20from%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401334%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F266754%22%20target%3D%22_blank%22%3E%40Nauthstar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again%20for%20your%20suggestion.%20%26nbsp%3BI%20didn't%20try%20it%20because%20I%20found%20the%20existing%20keyboard%20shortcut%20by%20trial%20and%20error.%20%26nbsp%3BTo%20bring%20up%20the%20list%20of%20sheets%20in%20Excel%202019%2C%20one%20Control%20clicks%20in%20the%20arrow%20box%20on%20the%20lower%20left%20where%20there%20are%20arrows%20to%20move%20right%20and%20left%20in%20the%20sheets.%20%26nbsp%3BI%20%26nbsp%3Bthought%20this%20was%20not%20working%20when%20I%20tried%20it%20before%3B%20it%20appears%20that%2C%20for%20a%20workbook%20that%20has%20a%20lot%20of%20sheets%20(like%20mine%20with%2075)%2C%20sometimes%20it%20takes%20a%20few%20seconds%20before%20the%20list%20appears.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-400624%22%20slang%3D%22en-US%22%3ERe%3A%20Keyboard%20shortcut%20to%20get%20a%20list%20of%20Excel%20sheets%20to%20select%20from%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-400624%22%20slang%3D%22en-US%22%3ETry...%3CBR%20%2F%3E%3CBR%20%2F%3ESub%20SheetMenu()%3CBR%20%2F%3EApplication.CommandBars(%22Workbook%20tabs%22).ShowPopup%3CBR%20%2F%3EEnd%20Sub%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-394747%22%20slang%3D%22en-US%22%3ERe%3A%20Keyboard%20shortcut%20to%20get%20a%20list%20of%20Excel%20sheets%20to%20select%20from%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394747%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F266754%22%20target%3D%22_blank%22%3E%40Nauthstar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20suggestion.%20%26nbsp%3BI%20copied%20your%20algorithm%20into%20a%20Macro%20and%20get%20an%20error%20when%20I%20run%20it%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERun%20time%20error%20'28'%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOut%20of%20stack%20space%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20clicked%20to%20debug%20but%20can't%20identify%20the%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20familiar%20with%20macros%20so%20don't%20know%20how%20I%20would%20edit%20this%20to%20make%20it%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-394435%22%20slang%3D%22en-US%22%3ERe%3A%20Keyboard%20shortcut%20to%20get%20a%20list%20of%20Excel%20sheets%20to%20select%20from%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394435%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F305510%22%20target%3D%22_blank%22%3E%40RSP123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20I%20haven't%20tried%20this%20on%20a%20MAC%20before%20but%20you%20may%20be%20able%20to%20modify%20the%20below%20macro%20to%20get%20what%20you%20want%20working...%3C%2FP%3E%3CP%3E1.%26nbsp%3B%20Create%20a%20macro%20(see%20below)%3C%2FP%3E%3CP%3EPrivate%20Sub%20Workbook_Open()%3CBR%20%2F%3E'Sub%20SheetMenu()%3CBR%20%2F%3EApplication.CommandBars(%22Workbook%20tabs%22).ShowPopup%3CBR%20%2F%3E'End%20Sub%3CBR%20%2F%3EEnd%20Sub%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%26nbsp%3B%20Assign%20shortcut%20key%20combination%20to%20run%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-401797%22%20slang%3D%22en-US%22%3ERe%3A%20Keyboard%20shortcut%20to%20get%20a%20list%20of%20Excel%20sheets%20to%20select%20from%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401797%22%20slang%3D%22en-US%22%3EIf%20you%20hold%20the%20Ctrl%20key%20down%20whilst%20you%20click%20on%20the%20bottom%20Left%20(or%20Right)%20arrow%2C%20it%20will%20quickly%20take%20you%20to%20the%20first%20(or%20last)%20tab%20in%20your%20spreadsheet.%20Handy%20if%20you%20have%20lots%20%26amp%3B%20lots%20of%20tabs.%3C%2FLINGO-BODY%3E
RSP123
Occasional Contributor

I have tried researching an answer to this question online in general and on this community board, but none that I found appear to apply to the Mac version of Excel 2019.

 

I am trying to find the keyboard shortcut that produces a list of all the Excel sheets in a given workbook from which I can select any sheet.  I have a particular workbook that has 75 sheets.  It is easy to go to the beginning or end of the workbook using the Command key, but I don't know how to produce the list of all the sheets.  Navigating to a sheet in the middle of the workbook is tedious.  It must be possible to do what I want since I hit some combination of keys by accident that resulted in the selectable list, but I am unable to recreate that keystroke combination.

 

Thanks in advance for any suggestions you have to offer.

5 Replies

@RSP123 

Hi, I haven't tried this on a MAC before but you may be able to modify the below macro to get what you want working...

1.  Create a macro (see below)

Private Sub Workbook_Open()
'Sub SheetMenu()
Application.CommandBars("Workbook tabs").ShowPopup
'End Sub
End Sub

 

2.  Assign shortcut key combination to run it. 

 

 

@Nauthstar 

 

Thanks for the suggestion.  I copied your algorithm into a Macro and get an error when I run it:

 

Run time error '28':

 

Out of stack space

 

I clicked to debug but can't identify the problem.

 

I'm not familiar with macros so don't know how I would edit this to make it work.

Try...

Sub SheetMenu()
Application.CommandBars("Workbook tabs").ShowPopup
End Sub

@Nauthstar 

 

Thanks again for your suggestion.  I didn't try it because I found the existing keyboard shortcut by trial and error.  To bring up the list of sheets in Excel 2019, one Control clicks in the arrow box on the lower left where there are arrows to move right and left in the sheets.  I  thought this was not working when I tried it before; it appears that, for a workbook that has a lot of sheets (like mine with 75), sometimes it takes a few seconds before the list appears.

If you hold the Ctrl key down whilst you click on the bottom Left (or Right) arrow, it will quickly take you to the first (or last) tab in your spreadsheet. Handy if you have lots & lots of tabs.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies