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??
- Jul 25 Fri 2008 20:45
'Compare side by side' for work sheets
close
全站熱搜
留言列表
發表留言