Prev: Row 3 data
Next: auto complete only for one row down?
From: KC on 29 Apr 2010 12:13
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?
From: Eduardo on 29 Apr 2010 12:21
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?
From: Tom Hutchins on 29 Apr 2010 12:34
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?
From: Dave Peterson on 29 Apr 2010 17:24
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
 | 
Pages: 1
Prev: Row 3 data
Next: auto complete only for one row down?