Thank you so much Mr. Jon. Your videos are blessing to me. They Make me understand a subject so easily compared to other excel videos from other people. God bless you soooo much.
This is awesome. I need this almost every day. My work around has been to pull one of the sheets into a second workbook. The problem, of course, is that formula writing becomes VERY cumberdone
You get all these crazy work around to try get this to work, then I get this clip and I am like what the hell, this so much easier. I honestly cant understand why it took me so long to find this feature.
Great tips. Can’t believe I did t not know this trick. That said, I still prefer the Mac numbers way of doing it. Basically a canvas with multiple/unlimited number of spreadsheets on it. This also solved the problem of cell sizes being off when cells above or below are wider or more narrow. It’s a cleaner design.
I appologize if you already answered this. Once you get your windows set up the way you want, how would you save them so you don't have to re do setting them up every time?
Is this only if you are working on one monitor? The steps don't work for me the same that they are working for you, but I am using 2 monitors. I used to be able to perform this task when I was limited to 1 monitor and was just wondering if this could be my issue now? Thank you for your videos!!
Hi Jon! Thanks for the tips, it’s very helpful. I also wondering if I need to hit save on all the new opening windows to save the changes that I made on all the new windows?
Hi. I really liked this great tip. But after creating 2nd window and making some changes if close and reopen means again it's opening two windows how to stop that. After making necessary changes if I open that Excel file I want to see only main Excel workbook not 2 work books. Can you plz guide !!
Great tip. One thing to watch out for on the second window (unless Microsoft has changed this behavior lately): Any freeze panes on any tab set in the workbook disappear from the - 2 version. And if you close the -1 version before the -2 version, you have to reset all of those. Hopefully, Microsoft will address this, but probably not (unless they already have, in which case I will gladly be wrong).
Hey Jack, Thanks for mentioning this! Unfortunately that is still the case. I'm working on a follow-up video with a macro that will set the freeze panes, gridlines, and headings on the new window for each sheet. And another macro to close additional windows. It will save time and help prevent this issue. The video should be out this week. Thanks again! :-)
Thanks for the tip jon. Btw do you have tips on how to join multiple sheets with same header but different content into one sheet? I have 85 GL account sheet that needs to be joined into one sheet.
Hi Eko, Great question! I do have training on this in my courses. We can use Power Query (www.excelcampus.com/powerquery/power-query-overview/) to make this process really easy. I go into more detail on how to combine data from worksheets and workbooks. I will create/share a RUclips video in the future that covers the basics to help get you started. Thanks again! 🙂
Great start but I was making changes to both worksheets and actually linking them via "=worksheet1!C3" kind of thing. It didn't give the way to save the changes to both WSs in the same workbook.
Hi Jon, after using your advice, I encountered a problem - saving and closing the file no longer opens a second time. Suggest how I can solve this problem
If you make changes in both windows, then they both will also sync and update both windows? And then when you close it, the file is update into 1 file or do you now have 2 different files?
Hi Robert, Yes, that is correct. Any changes made to the file will be reflected in BOTH windows. You do NOT have to update both windows. If you are working in split screen view then you will see those changes reflected immediately in the additional window(s). It does not matter which window you make the changes in. I hope that helps.
This is almost what I'm looking for but not quite. How does one get new instances of excel to open in the same window? On Office 2019 and this option doesn't seem to exist any longer.
The pivot charts and tables had help me a lot. Then, I find myself watching all your videos. Thanks for the free training. More power.
After using excel for a decade, I finally realise this amzing function!!!Thanks!!!It's very practical and effcient especially in dual monitor!!!
Glad it was helpful, Chau! 😀
You are my hero today.
Thank you so much Mr. Jon. Your videos are blessing to me. They Make me understand a subject so easily compared to other excel videos from other people. God bless you soooo much.
You are welcome, James! 😀
I've been using this for a few years now and love it. I've taught my colleagues about this and they were amazed.
OMG I cant believe I didn't know about this. My live is change forever Jon. Thank you
Woohoo! I'm happy to hear it. Thanks Geoffrey! 🙌
meeee toooo!!! :D
meeee toooo!!! :D
meeee toooo!!! :D
This is definitely a game changer. Really wanted this feature for a while. Thank you for the quick video.
Thank you man from Iraq 🇮🇶
Thanks for the video - told me exactly what I was trying to find out
Clear, concise exactly what I was looking for, great job
Appreciate the help! This makes Studying for my Excel Final way more manageable!
Fundamentals! I just brought this into a coworker's life last week, trying to troubleshoot a SUMIFS and not wanting to flip between 10 tabs.
Awesome! Thanks A.J. I'm sure the coworker was appreciative. :-)
Saved a lot of time. Thanks, Jon
Thank you so much. Really helpful and the first video that came up in a Bing search.
Good Job
great tips. Im already using it with double screen
Glad it helped! 😀
This is awesome. I need this almost every day. My work around has been to pull one of the sheets into a second workbook. The problem, of course, is that formula writing becomes VERY cumberdone
Thanks Russ! Happy to hear this technique will help. Formulas between workbooks can definitely be difficult to maintain.
Excellent Jon. Most helpful and time saving.
This is exactly what I needed. Thank you!
Thanks for help
thanks for the useful tutoral video!
Thank you! This helped me greatly. Very well explained and to the point. Thanks again.
Excellent tip!! This is my life on a daily basis... :)
Thanks Jayne! 🙂
You helped me a lot. THANK YOU ;-)
Great, exactly what I was looking for! Thank you!
i love this. Thank you so much.
You're welcome! 😀
You had me at "Side by Side" 🤩
Haha! Thanks Jerry! 🙂
Thanks for the video.
Great tip. Really appreciate you sharing. Very helpful!!
Thanks Ken! I really appreciate your support! 👍
THANKS FOR THIS
Fantastic tip - thank you for sharing this...
Nice, thanks!
Great; thanks very much!
Thank you..
ok - did not know about this and love it.
Wish I had googled this years ago!! Thanks for the great help.
Well done, Sir! Thank you.
Thank you for this useful video!
Great tip John, thanks for sharing! This is something I will use over and over again :)
Awesome! Thanks so much Scott! 🙂
That's fantastic! That's one of the best features of Google sheets, that's great to know Excel can do it to
Thankyou! Such a great tips 👌
awesome.
a great helpful for me dude!
Excellent
Thanks 😀
Thanks
This is great!
very useful one, I am using Excel since years and I did not know about it
Awesome! Thank you sir
Thank you so much 😊
YUP!!!! I love it. Thank you Jon
Great ❤
Thanks It's realy Helpful
Thanks Jon.. always something new and insightful from your channel. Thumbs up!
Thanks!
Very helpful video 👍
Glad it was helpful! 😊
life saver
thanks
Perfect thanks sir !!
Amazing!!
very concise and clear (as usual) thanks Jon!
Great tip. Thanks!
Thanks Ahmed! 🙂
Thanks it's helpful
AWESOME, THANK YOU JON!!!!
Thank you Sir!
Did not know about such possibility. But this is very helpful! Thank you!
wow.. I wish I knew about this feature. Nobody at my work uses this so I doubt they know either. Great find! Thanks for sharing.
thanks man. I was wondering how to view a chart on one screen based on a slicer in another
thank you so much! This is really helpful.
Awesome! Thanks Theiceize! 🙂
Ty for this!
Well done, nice tutorial :-)
As always clear & concise explanation! Thank you so much for sharing your knowledge.
Thx big brother for useful info ❤️
Gracias Helpful information.
Thank you! Very useful information and easy to follow instructions.
You get all these crazy work around to try get this to work, then I get this clip and I am like what the hell, this so much easier. I honestly cant understand why it took me so long to find this feature.
Great tips. Can’t believe I did t not know this trick. That said, I still prefer the Mac numbers way of doing it. Basically a canvas with multiple/unlimited number of spreadsheets on it. This also solved the problem of cell sizes being off when cells above or below are wider or more narrow. It’s a cleaner design.
thank you very much. I don't this feature
Thanks, sir.
One shortcut to quickly move to split view is windows+right arrow or left arrow
I needed this tip eons ago! LOL
Haha! It's definitely one of those little shortcuts that can save a lot of time, and eye strain! 👀
Thanks D! 🙂
Thanks for sharing this.
Finally someone to explain this. Couldn’t ever get a clear answer, everyone I know tries and still can do only simple things.
Super helpful!
I appologize if you already answered this. Once you get your windows set up the way you want, how would you save them so you don't have to re do setting them up every time?
Is this only if you are working on one monitor? The steps don't work for me the same that they are working for you, but I am using 2 monitors. I used to be able to perform this task when I was limited to 1 monitor and was just wondering if this could be my issue now? Thank you for your videos!!
This is great tip Jon, thank you.
Hi Jon! Thanks for the tips, it’s very helpful. I also wondering if I need to hit save on all the new opening windows to save the changes that I made on all the new windows?
This video is as concise as useful 👍🏻 Thank you sooooo much! 🙏🏻
Hi. I really liked this great tip. But after creating 2nd window and making some changes if close and reopen means again it's opening two windows how to stop that. After making necessary changes if I open that Excel file I want to see only main Excel workbook not 2 work books. Can you plz guide !!
I keep learning all these ideas until I become pro haha
Super
Great tip.
One thing to watch out for on the second window (unless Microsoft has changed this behavior lately): Any freeze panes on any tab set in the workbook disappear from the - 2 version. And if you close the -1 version before the -2 version, you have to reset all of those. Hopefully, Microsoft will address this, but probably not (unless they already have, in which case I will gladly be wrong).
Hey Jack, Thanks for mentioning this! Unfortunately that is still the case. I'm working on a follow-up video with a macro that will set the freeze panes, gridlines, and headings on the new window for each sheet. And another macro to close additional windows. It will save time and help prevent this issue. The video should be out this week. Thanks again! :-)
@@ExcelCampus Hey Jon. Great content. Just wondering if you manage to create the macro and post it
Thanks for the tip jon. Btw do you have tips on how to join multiple sheets with same header but different content into one sheet? I have 85 GL account sheet that needs to be joined into one sheet.
Hi Eko, Great question! I do have training on this in my courses. We can use Power Query (www.excelcampus.com/powerquery/power-query-overview/) to make this process really easy. I go into more detail on how to combine data from worksheets and workbooks. I will create/share a RUclips video in the future that covers the basics to help get you started. Thanks again! 🙂
Great start but I was making changes to both worksheets and actually linking them via "=worksheet1!C3" kind of thing. It didn't give the way to save the changes to both WSs in the same workbook.
Hi Jon,
after using your advice, I encountered a problem - saving and closing the file no longer opens a second time.
Suggest how I can solve this problem
If you make changes in both windows, then they both will also sync and update both windows? And then when you close it, the file is update into 1 file or do you now have 2 different files?
Hi Robert,
Yes, that is correct. Any changes made to the file will be reflected in BOTH windows. You do NOT have to update both windows. If you are working in split screen view then you will see those changes reflected immediately in the additional window(s). It does not matter which window you make the changes in. I hope that helps.
Good Stuff! Thanks for sharing
Thanks Tammy! 🙂
can you view to different books at the same time ?
Om a beginner. How do u open multiple sheets in the same workbook
Thanks John, But could you please explain how can this be done in Mac Numbers?
This is almost what I'm looking for but not quite. How does one get new instances of excel to open in the same window? On Office 2019 and this option doesn't seem to exist any longer.
Looking for this long time ago, but never dig in.