Out of literally multiple hundreds of channels on Excel skills, THIS channel is ABSOLUTELY THE VERY BEST! Thank you so much for your hard work in creating this amazing contents! You are an incredibly gifted teacher who not only addresses daily needs of Excel users (and there are so many of us!), while also keeping abreast of the most recent trends in data analytics. I have learned so much from your videos already, and I have only scratched the surface...
Many thanks, Mynda. I use New Window a lot, particularly if I'm setting up complex formulas where I need to reference a table on another worksheet. My only beef with New Window is that Freeze Panes settings aren't 'inherited' by the New Window, and you have to set them up again. I know this is because Freeze Panes is a window-based setting, rather than worksheet-based, but's still a pain / pane!
And ... if you close the second window before you close the first one, you loose all of the settings you had in your original file (freeze panes, zoom, etc.) ...
I am a big fan of new tips and tricks for Excel...and this video is one of the best...learned something completely new and would help a lot in day to day work. Keep this up!!
I suggest other people to put the "Switch Windows" button all the way to the left on their QAT and show the latter under the Ribbon. End-users like pushing a button, but don't like remembering shortcuts. OTOH: years ago I purchased an add-in called "Office tabs" and I have file tabs above just like the tabs in your browser. I use that. NB: all of the above applies to the entire Office suite of apps.
With the risk of being philosophical a quote spring to mind "The more you know, the more you know you don't know." One must just love to get inspiration from your videos, thanks.
Thank you Mynda for another great video! A functionnality that I'd love to see in Excel is a way to "pin" a sheet in a workbook to prevent it from moving out of scope especially when your worbook contains a large number of sheets. This way, one could navigate through the workbook and still easily access the pinned sheet. Have you ever wished you had that functionnality?
Glad you liked it, Olivier! You can use the New Window feature at 3:29 to effectively pin a sheet so it's always in view or can be easily navigated to using CTRL+Tab.
@@silversolver7809 Thank you Silver Solver ... but no! The problem is that, when a book contains a large number of sheet, I often need to scroll back and forth from the first sheet to the other. The way Around that I found is to open the first sheet in a new window and toggle through my windows. But this is note entirely satisfying.
@@olivierissaverdens6916 I recommend getting a second monitor-I've used 2 for ~20 years and feel bereft if I ever have to help someone with only one. Put a second Excel instance on the other monitor, any everything's in view :)
Great video simple yet so powerful. Go ctrl tab and ctrl shift tab and wind left arrow. One question: what is the point of new window i cant understand the use?
Really you are one of the best people in the world since you are sharing the knowledge. I have question if possible and I don’t know if possible to solve through excel I am a maintenance planner and I have to present report for number of work order - Open, Close and Carry forwarded status in dashboard report also this is comparison report between the Monthly or quarterly based on user selection parameter. Scenario 1:- if the 5 Workorder created in March and 3 WO closed in March means and rest 2 WO is carry forwarded to April means my report has to be Scenario 2:- and in April additional 3 work Order was created and 4 closed (including of last month (2 WO) carry forwarded and This month WO is 2 ) and CF is 1. on my report it has to present like Month Open Close Carry Forwarded March 5 3 2 April 3 4 1 for Open - I have creation date. Close - I have Completion date. CF - IF creation date(mm) is Not Initial and Completion date(mm) is initial and Completion date(mm) GT creation date(mm). this is what I planned but the problem is let say the the WO is created on March and closed in May then the report supposedly as to present like Month Open Close Carry Forwarded March 1 1 April 1 May 1 but the problem is if the WO got closed means it effects all other counts for carry forward. for example the report resented like below; Month Open Close Carry Forwarded March 1 April May 1 so kindly let me know how to solve this issue .
Thank you for great content. I would like to ask Is there a way to view previous or go to previous to go back to previous cell in its sheet or workbook. Many thanks Firas
Thanks for sharing! I personally hate split windows because it's too easy to scroll back up and to the left past the split point so you end up just seeing the fixed rows and columns twice. I prefer freeze panes. I love CTRL+PgUp/PgDn but this was about working in multiple files, not multiple sheets so I didn't mention it, but probably should have, so thanks for adding it.
@@MyOnlineTrainingHub I was wondering in the past if there is a shortcut for switching between Sheets. I am not very happy with this one, as in every browser it's Ctrl+Tab. But I made a simple AutoHotkey script that does switching by tilting mouse wheel and my colleague loves it 😁
I usually appreciate a lot your videos, but here saying that "view/new window opens a new instance of excel" is WRONG : it is a new view within the same instance of the excel app. Launching another instance of Excel is something else, very usefull in some cases (large files with long calculations times) : maybe an idea for a future video ?
I just learned several new things I never knew before. More importantly, they will help me immediately today! And it’s not even 7 AM. Thanks so much.😊
Wow, that's a great start to the day 😊
Out of literally multiple hundreds of channels on Excel skills, THIS channel is ABSOLUTELY THE VERY BEST! Thank you so much for your hard work in creating this amazing contents! You are an incredibly gifted teacher who not only addresses daily needs of Excel users (and there are so many of us!), while also keeping abreast of the most recent trends in data analytics. I have learned so much from your videos already, and I have only scratched the surface...
Wow, thanks so much for your kind words 🙏😊 I'm so pleased you find my tutorials helpful.
Many thanks, Mynda. I use New Window a lot, particularly if I'm setting up complex formulas where I need to reference a table on another worksheet. My only beef with New Window is that Freeze Panes settings aren't 'inherited' by the New Window, and you have to set them up again. I know this is because Freeze Panes is a window-based setting, rather than worksheet-based, but's still a pain / pane!
And ... if you close the second window before you close the first one, you loose all of the settings you had in your original file (freeze panes, zoom, etc.) ...
Good to now, Ian and Olivier!
Ooooooh Mynda, once again you make my work so much better. 🥰
I'm so glad!
You can use the "Camera" button to copy paste a live view of cells from different sheets. Good tip on a small screen laptop...
Yes, great tip! Thanks for sharing.
New Windows is such a game changer! Thank you!
My pleasure!
I am a big fan of new tips and tricks for Excel...and this video is one of the best...learned something completely new and would help a lot in day to day work. Keep this up!!
Great to hear!
Your channel is my new life line! Thank you for all the knowledge sharing! Excellent teacher! Be Blessed!💫
Wow, thank you!
I suggest other people to put the "Switch Windows" button all the way to the left on their QAT and show the latter under the Ribbon.
End-users like pushing a button, but don't like remembering shortcuts.
OTOH: years ago I purchased an add-in called "Office tabs" and I have file tabs above just like the tabs in your browser. I use that.
NB: all of the above applies to the entire Office suite of apps.
Nice tip, Geert! Thanks for sharing.
Switch windows is a lifesaver for me and a staple on the QAT
Very helpful tips. THANK YOU so much.
My pleasure!
Thank you for this tutorial. At the moment I work with Windows 10. I record the changes, Mynda!!! Thx.
You're welcome, Ivan! Windows 11 is worth upgrading to.
Thanks a lot, another fantastic video that makes my work faster
Great to hear!
Another useful gem presented by Mynda!! Thanks for the lesson. Always a learning moment with your videos. Cheers!
So pleased to hear that 🙏
That's so nice 🙏 Thank you.
My pleasure 😊
Last one is the exactly what I need
Glad it'll be useful to you!
Thanks Mynda. I’m getting a new PC next week with Windows 11, so looking forward to trying out those specific tips!
Awesome, Chris! Have fun 😁
Gracias por compartir este interesante videotutorial.
Glad you liked it!
With the risk of being philosophical a quote spring to mind "The more you know, the more you know you don't know."
One must just love to get inspiration from your videos, thanks.
Well said 😊 Thanks so much, Ivan!
Nice thanks alot
Most welcome 😊
Thanks
Welcome😊
Nice 👍👍👍
Thank you! Cheers!
Great tips, just a heads up that the new window stuff tends to turn off frozen panes.
Frozen panes are set at a window level. If you open the file in a new window, you need to set the frozen panes in that window too.
Thank you Mynda for another great video! A functionnality that I'd love to see in Excel is a way to "pin" a sheet in a workbook to prevent it from moving out of scope especially when your worbook contains a large number of sheets. This way, one could navigate through the workbook and still easily access the pinned sheet. Have you ever wished you had that functionnality?
Glad you liked it, Olivier! You can use the New Window feature at 3:29 to effectively pin a sheet so it's always in view or can be easily navigated to using CTRL+Tab.
I assume just moving the sheet to first place in the book doesn't fit your need?
@@silversolver7809 Thank you Silver Solver ... but no! The problem is that, when a book contains a large number of sheet, I often need to scroll back and forth from the first sheet to the other. The way Around that I found is to open the first sheet in a new window and toggle through my windows. But this is note entirely satisfying.
@@olivierissaverdens6916 I recommend getting a second monitor-I've used 2 for ~20 years and feel bereft if I ever have to help someone with only one. Put a second Excel instance on the other monitor, any everything's in view :)
Great video simple yet so powerful. Go ctrl tab and ctrl shift tab and wind left arrow. One question: what is the point of new window i cant understand the use?
Glad you'll find them useful! The new window enables you to compare/view different sheets in the same file side by side.
Really you are one of the best people in the world since you are sharing the knowledge.
I have question if possible and I don’t know if possible to solve through excel
I am a maintenance planner and I have to present report for number of work order - Open, Close and Carry forwarded status in dashboard report also this is comparison report between the Monthly or quarterly based on user selection parameter.
Scenario 1:-
if the 5 Workorder created in March and 3 WO closed in March means and rest 2 WO is carry forwarded to April means my report has to be
Scenario 2:-
and in April additional 3 work Order was created and 4 closed (including of last month (2 WO) carry forwarded and This month WO is 2 ) and CF is 1.
on my report it has to present like
Month
Open
Close
Carry Forwarded
March
5
3
2
April
3
4
1
for Open - I have creation date.
Close - I have Completion date.
CF - IF creation date(mm) is Not Initial and Completion date(mm) is initial and Completion date(mm) GT creation date(mm).
this is what I planned but the problem is let say the the WO is created on March and closed in May then the report supposedly as to present like
Month
Open
Close
Carry Forwarded
March
1
1
April
1
May
1
but the problem is if the WO got closed means it effects all other counts for carry forward. for example the report resented like below;
Month
Open
Close
Carry Forwarded
March
1
April
May
1
so kindly let me know how to solve this issue .
Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
👍
Cheers 😊
MVP = most valuable Player
😁
Thank you for great content.
I would like to ask Is there a way to view previous or go to previous to go back to previous cell in its sheet or workbook.
Many thanks
Firas
Use CTRL+G > Enter to navigate back to the previous cell.
Two things to add.
* From time to time I use just Split window in excel (instead of two windows)
* Ctrl+PgUp / Ctrl+PgDn for switching between Sheets
Thanks for sharing! I personally hate split windows because it's too easy to scroll back up and to the left past the split point so you end up just seeing the fixed rows and columns twice. I prefer freeze panes. I love CTRL+PgUp/PgDn but this was about working in multiple files, not multiple sheets so I didn't mention it, but probably should have, so thanks for adding it.
@@MyOnlineTrainingHub I was wondering in the past if there is a shortcut for switching between Sheets. I am not very happy with this one, as in every browser it's Ctrl+Tab. But I made a simple AutoHotkey script that does switching by tilting mouse wheel and my colleague loves it 😁
Hmmm, I use CTRL+PgUp/PgDn to switch tabs in my browsers. I use Opera, Chrome and Edge. I didn't realise CTRL+TAB also does it.
I usually appreciate a lot your videos, but here saying that "view/new window opens a new instance of excel" is WRONG : it is a new view within the same instance of the excel app. Launching another instance of Excel is something else, very usefull in some cases (large files with long calculations times) : maybe an idea for a future video ?
Yes, I got my terminology mixed up there. However, I don't think it obfuscated the usefulness of the feature.
I just have 3 monitors lol
I only have two...maybe I need to step up my game 😁
i like your videos but here i didnt find anything new, these are all quite old tricks
I’d say you’re in the minority 😉 Windows 11 isn’t that old, and plenty of people are still on Windows 10, so they’ll be new to those switching over.