View Two Sheets Side-by-Side in the Same Excel File

Công Nghệ

Learn how to setup Excel to view two sheets side-by-side in the same workbook using the New Window feature. This technique is great for writing formulas, copying and pasting data, or comparing two or more sheets. It saves time from having to navigate between two tabs that are not close to each other in the workbook.

I explain shortcuts to setup the split screen view, and how to use Synchronous Scrolling to visually compare two different sheets with similar data.

Read the full blog post:

Additional resources:

View Multiple Windows in Split Screen View:

5 Keyboard shortcuts to Paste Values in Excel:

Shortcuts for Pasting Values with the Mouse:


Xem thêm bài viết khác:

21 thoughts on “View Two Sheets Side-by-Side in the Same Excel File

  1. Is it possible to view two sheets side-by-side inside same app window (old style Office 2010 view, without having toolbars for each sheet)? Thanks

  2. OK, now do one where you save two workbooks at the same time while continuing to work on a 3rd. Other than as legacy-ware why is this atrocity still a valid business tool?
    How about this, do one where you have multiple panes open for various data sources and intersperse the excel panes in between the data sources so that you don't have to go looking for the right sheet.

  3. I can't tell you how many times I have used a screen copy to do this.  Thank you for this short but useful video!

Leave a Reply

Your email address will not be published. Required fields are marked *