See more than one tab at a time

R

rocky59

I would like to be able to see more than one Tab at a time in Excel.
Currently I'm able to see two Tabs from different worksheets, but not two or
more tabs from the same worksheet
 
H

Hank Scorpio

I would like to be able to see more than one Tab at a time in Excel.
Currently I'm able to see two Tabs from different worksheets, but not two or
more tabs from the same worksheet
Click to expand...

That would be because each tab represents a single worksheet. Clicking
on the tab would move you from where you are to... well, to where you
already are, essentially.

What exactly are you trying to do?
 
I

icestationzbra

question was - ???

answer was - !!!!!!! (hank, no offence...)

got me there both ways...

:)
 
G

Gord Dibben

Rocky

You seem confused about what a workSHEET is as opposed to workBOOK

Worksheets have only one tab(each tab in a workBOOK is a worksheet).

You can have Tools>Options>View "Windows in taskbar" enabled which will allow
more than one workBOOK to be displayed on the taskbar.

Worksheets are internal to each workBOOK and cannot be displayed on the
taskbar.

If you wish to see more than one worksheet on the screen you can go to
Window>New Window and create a second(or more) window. You can arrange these
windows so's you can see multiple windows on the screen at once.

Gord Dibben Excel MVP
 
E

ebipere

I am trying to do something that may be similar.

I think I may have found a way. ???

Consider a WORKBOOK [BOOK2.XLS] with 2 WORKSHEETS.[SHEET1 & SHEET2]
Within a WORKBOOK you can select MENU=WINDOW/NEW_WINDOW

THIS WILL CREATE YOU 2 WINDOWS FOR THE WORKBOO
The First window is called BOOK2:1
The Second window is called BOOK2:2

You can arrange the windows as you see fit -say HORIZONTAL
MENU=WINDOW/ARRANGE

The windows are independant.

What I do is I select WORKSHEET=SHEET1 for WINDOW=BOOK2:1
& WORKSHEET=SHEET2 for WINDOW=BOOK2:2

Now I have to work out how to automate this - LOL

Differentiate between a WORKBOOK a WORKSHEET and a WINDO
 
Top