Improve productivity by opening same excel sheet in 2 windows – quick tip

hacks , Learn Excel , technology - 1 comment


Often we work with large data sheets and it becomes tedious if you want to compare data / formulas etc. You can try split (menu > window > split or alt+w+s) to break the sheet in to two. But there is another cool thing you can do, open a new window for the spreadsheet. Just press Alt + w + n (menu > window > new window) to open the same spreadsheet in 2 windows. Any changes you make in one window are immediately visible in another window(s).

Bonus tip: you can do the same thing with WORD and POWER POINT as well, cool eh?


Hello Awesome...

My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.

I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.

Thank you and see you around.

Related articles:

Written by Chandoo
Tags: , , , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

One Response to “Improve productivity by opening same excel sheet in 2 windows – quick tip”

  1. productivity says:

    Improve productivity by opening same excel sheet i......

    Bookmarked your post over at Blog Bookmarker.com!...

Leave a Reply

« »