How to Compare Sheets in Excel 2007

Save

Comparing Microsoft Excel worksheets is useful when you must analyze the similarities and differences of data. By using the "View Side by Side" tool in Excel 2007, you can compare charts, graphs and other data, from separate worksheets, within the same Excel window. In addition, you can synchronize the scrolling of each worksheet, allowing you to compare the data throughout the Excel window. Use the "View Side by Side" tool to analyze the data in your Excel spreadsheets and reduce errors when making visual comparisons.

Compare Worksheets in the Same Workbook

  • Click the "View" tab and click "New Window" from the "Window" group.

  • Click the "View Side by Side" button from the "Window" group.

  • Click the tabs at the bottom of each worksheet to display the worksheets you want to compare.

  • Click the "Synchronous Scrolling" button from the "Window" group to scroll both worksheets at the same time.

Compare Worksheets from Different Workbooks

  • Open both workbooks that contain the worksheets that you want to compare.

  • Click the "View" tab and click "New Window" from the "Window" group.

  • Click the "View Side by Side" button from the "Window" group.

  • Click the tabs at the bottom of each worksheet to display the worksheets you want to compare.

  • Click the "Synchronous Scrolling" button from the "Window" group to scroll both worksheets at the same time.

Tips & Warnings

  • To stop comparing the worksheets, click the "Close" button.

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!