Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
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: https://www.excelcampus.com/tips/new-window/
Additional resources:
View Multiple Windows in Split Screen View: https://youtu.be/E7odG8Y1LA0
5 Keyboard shortcuts to Paste Values in Excel: https://youtu.be/jd9PZd7Itzs
Shortcuts for Pasting Values with the Mouse: https://youtu.be/sVagS3j1ryI
00:00 Introduction
00:24 New Window
00:59 Split Window
02:14 Synchronous scrolling
03:38 Close Windows
04:19 Outro