Shortcut for switching sheets in Excel?

Scam · 13 Nov 2023 at 12:30

I'm doing some coursework and using different worksheets in Excel on Mac. (Different windows, not tabs)

Clicking 'Window' on the top-bar and finding the right sheet is tedious.. is there not a keyboard shortcut to cycle through worksheets as you can for tabs? :confused:

visibleman · 13 Nov 2023 at 13:01

Scam said:
I'm doing some coursework and using different worksheets in Excel on Mac. (Different windows, not tabs)

Clicking 'Window' on the top-bar and finding the right sheet is tedious.. is there not a keyboard shortcut to cycle through worksheets as you can for tabs?

CMD + Page Up (Left) or Page Down (Right).

Scam · 13 Nov 2023 at 13:07

visibleman said:
CMD + Page Up (Left) or Page Down (Right).

That cycles through tabs, not worksheets.

visibleman · 13 Nov 2023 at 13:28

Scam said:
That cycles through tabs, not worksheets.

You mean workbooks (the "tabs" are worksheets - https://www.excel-easy.com/basics/worksheets.html)?

If you're fullscreen'd then you can cycle apps/windows using CTRL+Left/Right. Otherwise you can right-mouse click the dock icon to select a workbook or, install a alt-tab switcher like AltTab (https://forums.overclockers.co.uk/t...cations-thread.18927576/page-19#post-36703311) to give you something a bit more like the switcher in Windows.

Feek · 13 Nov 2023 at 13:28

Not quite what you want but if you're using a trackpad, do it via Mission Control? Swipe up with four fingers and click on the other window?

visibleman · 13 Nov 2023 at 13:40

Similar to @Feek, you can get to Mission Control and/or swipe between fullscreen apps with gestures on a Magic Mouse - https://support.apple.com/en-gb/102482.

Cromulent · 13 Nov 2023 at 17:31

If you have a Logitech MX Master 3S it has a horizontal scroll wheel which is very handy.

mr_crowley · 13 Nov 2023 at 19:22

Scam said:
I'm doing some coursework and using different worksheets in Excel on Mac. (Different windows, not tabs)

Clicking 'Window' on the top-bar and finding the right sheet is tedious.. is there not a keyboard shortcut to cycle through worksheets as you can for tabs?

If I have multiple workbooks open I use Command ` to cycle through the sheets

Just hold the command button and then every time you click ` (next to Z) it will cycle through