Skip to content

    Archive 2026

    Pencil icon

    Quick Tips: Using the "New Window" Feature in Microsoft Excel

    How do you use the "New Window" feature in Excel? The New Window may be common knowledge for some business professionals, but it wasn't to me. I often use applications and don't fully understand its capabilities, and don't take the time to explore the tool properly. I discovered this button out of need. What's the "New Window" button used for? Imagine you are working on a large spreadsheet with multiple sheets, and you need to reference data from one sheet while working on another. Switching back and forth between sheets takes a while and it's a bit of a hassle. It's especially bad when you are building a formula that references two different tabs. The 'New Window' feature eliminates this frustration by allowing you to view two sheets from the same workbook simultaneously. Once I found it, I started using it daily. Furthermore, I thought I was the last person to know this existed, but I constantly see my team members struggling with the same issue. Every person I've shown this button ...

    Subscribe to our blog