Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing 2 tabs in same workbook
Is there a way to view 2 tabs in a workbook at the same time, so I don't have
to keep switching back and forth to grab numbers from one tab to another? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing 2 tabs in same workbook
Hi,
sorry but you cannot, why do you have to grab # from the other sheet, why you don't use formulas, with an example maybe I can help "KC" wrote: Is there a way to view 2 tabs in a workbook at the same time, so I don't have to keep switching back and forth to grab numbers from one tab to another? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing 2 tabs in same workbook
With your workbook open,
In Excel 2003: Window New Window then Window Compare Side by Side With or Window Arrange In Excel 2007, these are found in the Window section of the View ribbon. Hope this helps, Hutch "KC" wrote: Is there a way to view 2 tabs in a workbook at the same time, so I don't have to keep switching back and forth to grab numbers from one tab to another? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing 2 tabs in same workbook
And just to add to Tom's suggestion...
Excel will try to remind you by putting something in the title bar: book1.xls:1 and book1.xls:2 Those :1 and :2 are windows indicators -- you don't actually have two workbooks open -- just that single workbook is open and you have multiple views into it. And when you're tired of this second (or more!) window, select the window you don't want to see anymore and hit ctrl-w to close it. Tom Hutchins wrote: With your workbook open, In Excel 2003: Window New Window then Window Compare Side by Side With or Window Arrange In Excel 2007, these are found in the Window section of the View ribbon. Hope this helps, Hutch "KC" wrote: Is there a way to view 2 tabs in a workbook at the same time, so I don't have to keep switching back and forth to grab numbers from one tab to another? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Viewing Tabs | Excel Discussion (Misc queries) | |||
Viewing Tabs | New Users to Excel | |||
Dual Monitors: Viewing different tabs in same workbook? | Excel Discussion (Misc queries) | |||
Viewing worksheet tabs | Excel Discussion (Misc queries) | |||
Worksheet tabs viewing there of | Excel Worksheet Functions |