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. Switching Between Different Tabs / Worksheets One of the keyboard shortcuts I use all the time in Excel is the one for switching between tabs or worksheets within a workbook: Ctrl+PageUp or Ctrl+PageDown.

A number of people in my office have been asking me how they can easily switch between worksheets in Excel using their keyboards rather than having to click on an individual sheet and this article will addresses that issue. This may sound lazy to someone who does not use Excel very often, but when you’re a manager and have an Excel spreadsheet in front of you with 50 tabs, that little mouse pointer can start to be a real pain!

Reset the settings of word 2016 to default settings on MacBook Hi, how do it reset the settings of word 2016 to default settings on MacBook Pro, the text starts at the very top of the page and it messes up the layout of the page. Change the default settings for new documents. Important: If you mistakenly modify the Normal template, you can easily restore the default behavior by deleting, renaming, or moving it. The Normal template is automatically recreated the next time that you open Word. In Word for Mac 2011, on the Home tab, under Themes, click Themes,. Word for mac version 16 restore defaults.

Anyway, it’s always good to know shortcuts if you can. I’ve been in the situation numerous times where my touch pad died and I didn’t have a mouse laying around. Knowing some slick keyboard shortcuts can make the difference between getting some work done and taking a coffee break. Switch Between Worksheets in Excel So in order to move through sheets or tabs in an Excel workbook using the keyboard, simply press and hold CTRL and then press the PgUp or PgDn buttons to move from right-to-left or left-to-right!