Is there a way to compare sheets of a same workbook side by side, as you can
do it with two workbooks?

Thanks in advance.

Regards,
Emece.-

In 2007, View, Arrange all, Windows of active workbook.

Emece wrote:
Is there a way to compare sheets of a same workbook side by side, as you can
do it with two workbooks?

Thanks in advance.

Regards,
Emece.-

Thanks Bob for your prompt reply. I have tried your suggestion, but I cannot
figure out how to visualize different sheets. The windows are arranged but I
can see the same sheet in both sections of the window.

Hope I am clear enough.

Thanks again.

Regards,
Emece.-

"Bob I" wrote:

In 2007, View, Arrange all, Windows of active workbook.

Emece wrote:
Is there a way to compare sheets of a same workbook side by side, as you can
do it with two workbooks?

Thanks in advance.

Regards,
Emece.-

Select the sheets to see in each window using the tab at the bottom or
CRTL+PGUP or CTRL+PGDN

Emece wrote:
Thanks Bob for your prompt reply. I have tried your suggestion, but I cannot
figure out how to visualize different sheets. The windows are arranged but I
can see the same sheet in both sections of the window.

Hope I am clear enough.

Thanks again.

Regards,
Emece.-

"Bob I" wrote:


In 2007, View, Arrange all, Windows of active workbook.

Emece wrote:

Is there a way to compare sheets of a same workbook side by side, as you can
do it with two workbooks?

Thanks in advance.

Regards,
Emece.-

WindowNew Window

WindowArrangeVertical

Select a sheet in each window then WindowCompare side by side


Gord Dibben MS Excel MVP

On Fri, 4 Sep 2009 06:39:02 -0700, Emece
wrote:

Is there a way to compare sheets of a same workbook side by side, as you can
do it with two workbooks?

Thanks in advance.

Regards,
Emece.-