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.

SPONSORED REPORT

2019 State of Financial Reporting Survey

We surveyed nearly 600 finance and accounting professionals on their month-end close and reporting processes. See the results.

VIDEO

What RPA is and how it works

Robotic process automation is like an Excel macro that can work on multiple applications, says Danielle Supkis Cheek, CPA. RPA can complete routine, repetitive tasks such as data entry, freeing up employee time from lower-level chores.