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:
View Multiple Windows in Split Screen View:
5 Keyboard shortcuts to Paste Values in Excel: