ExcelBanter - how do i switch between multiple sheets in the same workbook (key.

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

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

- - how do i switch between multiple sheets in the same workbook (key. (https://www.excelbanter.com/excel-discussion-misc-queries/917-how-do-i-switch-between-multiple-sheets-same-workbook-key.html)

Catalin

how do i switch between multiple sheets in the same workbook (key.

Frank Kabel

Hi
CTRL-PGUP
CTRL-PGDOWN

"Catalin" wrote:

cvgairport

You can also see different tabs or sections from the same workbook by opening
up a second view of the workbook by clicking on Window/New Window. After
doing this reduce the size of the :1 workbook and then reduce the size of the
:2 workbook so that both views can fit on the screen. Then you can mouse
click back and forth between the windows.

"Catalin" wrote:

DGPickett

Window-Arrange works nice on 2 copies of the same workbook, too. However, I
find it fights with autosave in excel 2000.

"cvgairport" wrote:

You can also see different tabs or sections from the same workbook by opening
up a second view of the workbook by clicking on Window/New Window. After
doing this reduce the size of the :1 workbook and then reduce the size of the
:2 workbook so that both views can fit on the screen. Then you can mouse
click back and forth between the windows.

"Catalin" wrote:

All times are GMT +1. The time now is 12:48 PM.