ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   'Compare side by side' for work sheets (https://www.excelbanter.com/excel-discussion-misc-queries/86301-compare-side-side-work-sheets.html)

Dr Sanjay

'Compare side by side' for work sheets
 
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??

Rae Drysdale

'Compare side by side' for work sheets
 
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 Drysdale


"Dr Sanjay" wrote:

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??


CLR

'Compare side by side' for work sheets
 
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

http://www.realezsites.com/bus/primitivesoftware

Vaya con Dios,
Chuck, CABGx3














"Dr Sanjay" wrote in message
...
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??





All times are GMT +1. The time now is 04:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com