If hard work becomes a habit, So success becomes a matter. Whoever is watching my comment at this time, we are all unknown to each other, yet I pray to God that if there is any tension going on in your life, then it should go away. And may you always be happy.️✨❤️
Great Love And Respect From The Kashmir. It's Only Because Of You That As Of Now Am Enable To Use Excel In Detail & In Deep,There Are Many Online Courses But Yours Way Of Teaching Is Far Better.
Thanks for the vid! I think it's cool seeing you making a video out of passion for these very nice little quick controls that people indeed don't know. However, I think the underlying fantasy (that at least I think I had/still have with such 'productivity' things) was that this was going to improve my efficiency which is mainly bad due to lack of concentration and distractibility. Unfortunately it didn't and I'm sometimes worried it even increased it because I am now able to zoom all around my Windows PC very quickly (Win D, Alt+Tab, ). At the very least, if not as causal as I made it sound, the two fit so well together: move swiftly from point A to point B, the moment you have the impulse. I see people very slow with PCs, just point and clicking everything slowly, but being extremely efficient and productive. I don't know if you've ever had such thoughts, but I thought I'd just put them here, since I recognize a very warm familiar feeling. : )
Btw, do you have any insights on how to change font colour swiftly? My quickest is Right Click (using the Context menu key on a keyboard that has it), F, Tab Tab Tab, Down, Down... etc 😉😉 If your keyboard doesn't have a context menu key, then you can map it to any key you like using Microsoft Powertoys (there's many mapping software, but this is super straight forward, 'native' and intuitive) I have mapped it to my Alt-Gr key because I never use that.
Another awesome video. Thank you so much for being a wonderful teacher. I've learned so much & shared several videos with other people. Keep up the great work.
thanks for the info, im doing my paper and im getting tired of scrolling up and down whenever i go to the different parts, how to create title page like a shortcut so i can go to different oage with out scrolling
How the heck is one supposed to remember all the keyboard commands? I need a cheat-sheet of all of them in a list. For now I'll just stick to using the ribbon. PS - great videos! Loving the playlists.
None of the text formatting shortcuts outlined at the beginning of this video are working for me. I have Word 365, if that makes a difference. I tried using Ctrl, Option, Cmd - none of them work.
Hi , Sub GoTo_Example1() Application.Goto Reference:=Worksheets("Jan").Range("C5"),Scroll:=True End Sub This is VBA code which i use to go to a cell , but i want to use this code in VBA code for a automation tool , where the range value varies for every sheet. So for that , i have a range value in a cell , which i want to go, so can u please help me out , how the Above code should be used to take the range from a cell (which has range value, which changes from sheet to sheet). Thanks
If hard work becomes a habit, So success becomes a matter. Whoever is watching my comment at this time, we are all unknown to each other, yet I pray to God that if there is any tension going on in your life, then it should go away. And may you always be happy.️✨❤️
That ctrl+shift+c or v was very new to me. It makes formatting texts very convenient! Thanks! God bless!
Great Love And Respect From The Kashmir.
It's Only Because Of You That As Of Now Am Enable To Use Excel In Detail & In Deep,There Are Many Online Courses But Yours Way Of Teaching Is Far Better.
Thanks for the vid! I think it's cool seeing you making a video out of passion for these very nice little quick controls that people indeed don't know.
However, I think the underlying fantasy (that at least I think I had/still have with such 'productivity' things) was that this was going to improve my efficiency which is mainly bad due to lack of concentration and distractibility.
Unfortunately it didn't and I'm sometimes worried it even increased it because I am now able to zoom all around my Windows PC very quickly (Win D, Alt+Tab, ). At the very least, if not as causal as I made it sound, the two fit so well together: move swiftly from point A to point B, the moment you have the impulse.
I see people very slow with PCs, just point and clicking everything slowly, but being extremely efficient and productive.
I don't know if you've ever had such thoughts, but I thought I'd just put them here, since I recognize a very warm familiar feeling.
: )
Thank you so much
Great video 😁
Very informative. Thank you.
Btw, do you have any insights on how to change font colour swiftly?
My quickest is Right Click (using the Context menu key on a keyboard that has it), F, Tab Tab Tab, Down, Down... etc 😉😉
If your keyboard doesn't have a context menu key, then you can map it to any key you like using Microsoft Powertoys (there's many mapping software, but this is super straight forward, 'native' and intuitive)
I have mapped it to my Alt-Gr key because I never use that.
Great video, as always! 🙂
Another awesome video. Thank you so much for being a wonderful teacher. I've learned so much & shared several videos with other people. Keep up the great work.
thanks for the info, im doing my paper and im getting tired of scrolling up and down whenever i go to the different parts, how to create title page like a shortcut so i can go to different oage with out scrolling
Very helpful
How the heck is one supposed to remember all the keyboard commands? I need a cheat-sheet of all of them in a list. For now I'll just stick to using the ribbon. PS - great videos! Loving the playlists.
merge formatting shortcut? In Ms word
Great😉
None of the text formatting shortcuts outlined at the beginning of this video are working for me. I have Word 365, if that makes a difference. I tried using Ctrl, Option, Cmd - none of them work.
Video Summary
============
Ctrl+B U I
Ctrl+R L E J
Ctrl Shift > <
Ctrl [ ]
Ctrl shift c
Ctrl Shift *
WELL
Hi ,
Sub GoTo_Example1()
Application.Goto Reference:=Worksheets("Jan").Range("C5"),Scroll:=True
End Sub
This is VBA code which i use to go to a cell , but i want to use this code in VBA code for a automation tool , where the range value varies for every sheet. So for that , i have a range value in a cell , which i want to go, so can u please help me out , how the Above code should be used to take the range from a cell (which has range value, which changes from sheet to sheet). Thanks