Ask Your Question
1

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

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

dfoerster gravatar image dfoerster
11 1 3 3

updated 2012-03-02 18:32:30 +0200

MagicFab gravatar image MagicFab flag of Canada
690 5 12 23
http://wiki.documentfound...

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

delete close flag offensive retag edit

3 Answers

Sort by » oldest newest most voted
1

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

Kevin E gravatar image Kevin E
26 1 1

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.

link delete flag offensive edit
1

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

ProLogic gravatar image ProLogic flag of Philippines
103 1 1 8

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

link delete flag offensive edit
0

answered 2012-10-24 19:02:17 +0200

shawncm217 gravatar image shawncm217 flag of United States
1 1
http://www.shawncm217.com...

I had this same question on Windows. ProLogic's answer helped me find the actual answer of Ctrl+Page Up and Ctrl+Page Down by scrolling through the current mappings. Sorry I don't have a Mac to give you your exact answer, but maybe following ProLogic's response will (or already did) get it for you.

link delete flag offensive edit

Login/Signup to Answer

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Follow
1 follower

subscribe to rss feed

Stats

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

Seen: 1,071 times

Last updated: Oct 27 '12