ExcelBanter - Toggle between Worksheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Toggle between Worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/210734-toggle-between-worksheets.html)

Jerry L

Toggle between Worksheets

Is there a keyboard key combination that will allow me to display / make
active the next open Worksheet?

I am trying to NOT have to choose the dropdown list as I swap data from one
worksheet to another.

Thanks,
Jerry

Jim Thomlinson

Toggle between Worksheets

Ctrl + Tab to swap between workbooks
Ctrl + Page Up/Page Down to move between sheets
--
HTH...

Jim Thomlinson

"Jerry L" wrote:

Is there a keyboard key combination that will allow me to display / make
active the next open Worksheet?

I am trying to NOT have to choose the dropdown list as I swap data from one
worksheet to another.

Thanks,
Jerry

All times are GMT +1. The time now is 09:07 AM.