New Window 0

Assume for a moment that you are working with an Excel File which has 10 Sheets or may be more!

New Window

Now What if,

  1. Some of your data is kept on Sheet 1 and rest is kept on Sheet 10
  2. And you have to do a to and fro (again and again) between Sheet 1 and Sheet 10

How would you navigate between the sheets faster?

Would you

  1. Keep using the mouse to flip between the sheets ? or
  2. Use the shortcut Ctrl PgUp or Ctrl PgDn to move back and forth ?

Let me introduce you to something called as New Window. It is simple and extremely effective way of navigation

Assume This

I have some data kept on Sheet 1 and some on Sheet 10

New Window 1

Let’s try and use the New Window to quickly navigate between the sheets instead of the other navigation options

 

The New Window Tool

New Window 2

  1. In the View Tab click on New Window
  2. A new window of the same excel file will open up
  3. Now that you have 2 windows. You can set one window on Sheet 1 and the other window on Sheet 10
  4. Now simply use Alt Tab to navigate between the 2 windows

Cool isn’t it ?

 

Using the New Window in PowerPoint

  1. Assume that you have 15 slides. Slide 1 has Table of Contents and Slide 12 has some content
  2. Now again you have to navigate between the 1st Slide and 12th Slide
  3. In the View Tab Click on New Window
    1. You’ll have a new window of the same powerpoint presentation open up
    2. Just as excel set one view to Slide 1 and the other to Slide 12
    3. Now use Alt Tab to navigate quickly between the slides

Bonus Tip: The New Window works the same way in MS Word too

 

Some things to keep in mind !

  1. New Window is extremely helpful for navigation especially when you are dealing with many excel sheets or powerpoint slides and you continuously want to refer to and fro between sheets or slides
  2. The New Window actually opens up another image of the same file
  3. So the changes that you make in any window are automatically replicated to all other windows
  4. You can open more than 2 windows if you want
  5. Excel/PowerPoint will not notify to save the file until you close the last window (which is the excel or the powerpoint file itself)

 

More awesome quick tips for you

  1. Draw a Chart in 1 keystroke
  2. Format your charts with ease
  3. How to generate automated serial numbers
  4. A smart and quick alternative to merging cells
  5. How to work on multiple sheets at once
  6. How to not copy hidden rows from filtered data
  7. Keep a track of critical cells with the Watch Window

 

Did you find the New Window useful? Please leave your comments

 



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI