close

In one spreadsheet I have got 2 worksheets. I wish to compare the contents of
the two worksheets in an easy fashion, without having to flick from one to
the other. I know that you can go to 'Windows | Compare Side by Side with...'
to compare 2 spreadsheets because the two get cascaded on the screen for easy
viewing.

Is there a way to do the same thing but with worksheets??

To view multiple sheets, click New Window on the Window menu. Switch to the
new window, and then click a sheet you want to view. Repeat for each sheet
you want to view.

On the Window menu, click Arrange.
Under Arrange, click the option you want.
--
Rae Drysdalequot;Dr Sanjayquot; wrote:

gt; In one spreadsheet I have got 2 worksheets. I wish to compare the contents of
gt; the two worksheets in an easy fashion, without having to flick from one to
gt; the other. I know that you can go to 'Windows | Compare Side by Side with...'
gt; to compare 2 spreadsheets because the two get cascaded on the screen for easy
gt; viewing.
gt;
gt; Is there a way to do the same thing but with worksheets??

If this is something you have to do frequently, you might consider Jim
Cone's fine commercial Add-in called XL Companion, which is what I use for
comparisons. It will list all the differences you choose. It's available
at

www.realezsites.com/bus/primitivesoftware

Vaya con Dios,
Chuck, CABGx3quot;Dr Sanjayquot; gt; wrote in message
...
gt; In one spreadsheet I have got 2 worksheets. I wish to compare the contents
of
gt; the two worksheets in an easy fashion, without having to flick from one to
gt; the other. I know that you can go to 'Windows | Compare Side by Side
with...'
gt; to compare 2 spreadsheets because the two get cascaded on the screen for
easy
gt; viewing.
gt;
gt; Is there a way to do the same thing but with worksheets??

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()