Jump Between Worksheets Without A Mouse


Q. Is there an easy way to move between worksheets in an Excel workbook without having to aim the mouse at those tiny tags on the bottom of the page?

A. You can move worksheets with the keyboard by using Ctrl+PgUp and Ctrl+PgDown. Ctrl+PgUp moves toward the first worksheet in the workbook and Ctrl+PgDown moves toward the last. However, when you reach the first or last worksheet, you have to switch directions: Excel doesn’t wrap to the opposite end of the workbook.

Where to find July’s flipbook issue

The Journal of Accountancy is now completely digital. 

 

 

 

SPONSORED REPORT

Better decision-making with data analytics

Data analytics has become a hot topic, but many organizations have not yet managed to understand its potential, let alone put it to work. This report will take a deep-dive on how to best introduce or enhance the use of data in decision-making.