We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

What keyboard shortcuts are used to switch through sheets on a Mac? [closed]

asked 2012-02-24 18:35:00 +0200

dfoerster gravatar image

updated 2020-08-19 05:26:35 +0200

Alex Kemp gravatar image

What's the keyboard shortcut to switch through the tabs of a spreadsheet on the Mac?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-02 02:49:09.718351

3 Answers

Sort by » oldest newest most voted

answered 2012-10-27 02:54:38 +0200

Kevin E gravatar image

On a Mac laptop (or any Apple keyboard without PgUp/PgDn keys), you switch between sheets in Calc with:

Fn + Command + up arrow / down arrow

since Fn + up/down arrow correspond to PgUp and PgDn on Mac laptop keyboards.

The 100-something key "Apple Keyboard with Numeric Keypad" keyboards have dedicated "page up"/"page down" keys, so no need for such finger calisthenics if you have one of those.

On the older models (my 2005 PowerBook, for sure) this was explicitly silkscreened on the keys. Nowadays it's just tribal knowledge. So you would never guess this without someone telling you.

edit flag offensive delete link more

answered 2013-06-01 23:53:24 +0200

TomRoche gravatar image

C-PgUp and C-PgDn also work on debian

edit flag offensive delete link more

answered 2012-03-02 03:02:19 +0200

ProLogic gravatar image

You can customize your short cut on Calc, may be you can find what you are searching

Open a Calc SpreadSheet > Tools > Customize > and Select the Tab "Keyboard" You have 2 check button "LibreOffice" and "Calc" , "Calc" should be selected in upper right corner, if not the change will affect all LibreOffice !!

Be very careful if you change a shortcut key, it can affect another shortcut key

Next select the required function from the Category and Function lists. Now select the desired shortcut keys in the Shortcut keys list and click the "Modify" button at the upper right. Finally Click "OK" to accept the change

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2012-02-24 18:35:00 +0200

Seen: 110,326 times

Last updated: Jun 01 '13