When I asked a magacian how he does all the tricks, he replied that magicians do not reveal. But you, the magician of Excel, display new useful tricks every time, helping us many ways and making our life easier. God bless you 🙏
frustrated by this on a daily basis, but because of the ease of backtracking and re-doing it... i never took the time to research it. Great video. Wonderful original content.
Why am I learning about this just now? Excel developers definitely find it important. It's just there, sitting on the corner, waiting to be acknowledged. Thank you! Total game changer.
This video is going to be a great help for folks to understand what is happening around cells while they are using them. It's always good to see channels like us who are doing great jobs.
I have seen this all my life but never realised that it had so much significance until I saw this video. Thanks a lot, saved a lot of frustration, especially in conditional formatting.
Thank you so much! I have been using Excel for over 20 years and never once have I seen instruction about cell modes! This will be most helpful. You explained it very well.
It was a headache to select cells when data validation and other dialogue box opened situations. You healed the pain completely Leila. Thanks for this valuable tip...
Holly shit!!! I’ve been waiting for a solution for this problem since I started using Excel. Why the majority of people don’t know about this trick. This is a real game changer. I want to give you a big warm hug, Leila. 1000 likes to you. Unfortunately, TH-cam allows to tack only one.
It used to be very irritating to use mouse when moving left or right while editing in dialogue box. This video changed my excel experience. Thank you, Leila.
Intuitively I always knew this (by trial and error and using F2... you know the drill), but nice to know that there is a visual cue for it in the bottom left corner! This will save me some headache. Thanks for the video!
I've always been a keyboard lover in Excel. But some events just forced me to use the mouse 🖱 especially when selecting range for Data Validation or Pivot Table. This video simply frees me even further of having to switch to mouse and helps keep my hands on the keyboard! How on earth didn't I ever try to press this F2 key twice (or more) despite this being the first shortcut I was taught editing a cell when I learnt to use Lotus 123 many years ago (!?!). Thanks heaps, Leila!
Thanks Leila! Fantastic! You made my day! Again! You say it's a basic tip but reading the comments you will see that many of us didn't know that. Thank you so much for your efforts!
This has been driving me crazy for years, and I had no idea you could change the behaviour in dialog boxes - thank you for revealing this awesome (simple) solution.
I've been using Excel since the 90s but I never realised that there were special names for the different behaviours of cells in Excel and in particular that they are actually shown on the screen. I wonder what the first version of Excel to do that was. Thanks for the video. I learnt something new.
OMG! That differing behaviour is something that has been bugging me for ages! Thanks for, once again, shedding light on a feature I'd never previously known about.
Thank you!!! I am a moderately advanced Excel user and this is one thing that was frustrating me to no end. I had no idea that the solution was so simple!!!
Leila! your teaching is unique , simple and focused. This is excellent trick. I could'n't understand as to why this is happening and it seemed painfully embarrassing. As I don't have institutional training in excel and learned by doing work and watching some wonderful videos. However, your videos are very informative and smarter. your melodiously super cool voice and balanced pitch makes you stand unique. I really admire you for your effective, meaningful, relevant teaching style. Thank you very much.
This is a small but very useful tip... can't tell how many times I get frustrated when I press the arrow keys in the validation dialogue box! Thank you
Up until now I considered myself to be advanced Excel user. If I'm advanced user indeed, then I have no idea how to describe yourself. This a real game-changer. Editing of conditional formating was driving me nuts on multiple occassions. Thank you for sharing!
I've been using Excel probably since 1995. I've been writing VBA Excel applications for about 9 years. It never occurred to me to hit F2 twice let alone that it works in the dialogs. I learned something new today. Thanks Leila! Keep up the good work
Excellent video, and I want to thank you for the last part too, of toggling the display of the Cell Mode. Assuming that some settings might be turned off for some users is what makes the best teacher, imo.
I learned this behavior of Excel over several years and now, when I'm teaching students, I include this skill early when we start Excel. Students get so frustrated when they open a dialog box and try to modify a formula. When they ask me for help, my first question is "what mode are you in?" Your tutorial on this is very well done (as I've come to expect from you) and I'll start having my students watch it to help them learn Excel. Thanks, Leila.
I knew about F2 when editing a formula in a cell but I never thought to use it in a Data Validation or Conditional Formatting. That's very helpful. Thank you.
I never looked in that corner for that status. great tip! just started your dashboards course. thanks!...from a huge fan of all your knowledge sharing.
Despite using Excel for years, this is the first time I’ve heard this topic explained. Thank you! I’m hoping that it makes the editing of conditional formatting and ranges is a little less frustrating for me.
You are so good, this attention to details makes you what you are, I've started following you few months back. And other than learning excel, I'm also learning on how to make people learn easily. Your videos are so clean and clear. Keep'm coming, Thank you.
Yes, highly appreciated tip. I have realized that only a few years ago, although constantly working with MS Office. F2 works also fine in MS Filexplorer when you want to quickly rename files or folders.
I have been using Excel since the 90ies (no, I'm still not a pro, I'm talking basic levels here, as I never really needed advanced excel knowledge until my current job), but still: I've never seen that, heard of it or even realized it was there. I just accepted my fate and that sometimes Excel does not behave the way I expect or want it to. Well, FML! 😄Thank you for this one. I didn't specifically look for it, but it helped me TREMENDOULSY! And while I'm already here word vomiting all over your comment section: Thank you for ALL the videos you've made - and the ones still coming. I'm far from being a real advanced user (meaning: actually KNOWING instead of googeling my shit until I have the expected outcome [VBAing out weekly and monthly reports via e-mail cuz I'm too lazy to do it manually]), but with the help of people like you I'm getting better everyday. So please keep up the work. 💐😁👍🏻
This is very useful, Leila! I wasn't aware if these cell modes. It seems that you are determined to reveal all the little corners of Excel! :) thank you for sharing.
Hi Leila. Such a great tip! Before I learned this trick, it was super frustrating. F2 is definitely your friend when editing formulas and manipulating ranges. Thanks for sharing it for all to see :)) Thumbs up!!
Fantastic Leila; frankly I have hardly paid any attention to this mode thing. I especially like the the use of F-2 to switch between Edit and Enter mode in conditional formatting and editing an existing formula. Lovely video blonde girl :)
This is so useful to know! It was only yesterday when I was writing a really long formula in the conditional formatting dialog box, and annoyingly I could not get the text cursor to go to the very end. And with no way of resizing the box (that _needs_ changing), I ended up copying and pasting the formula into the worksheet - working on it that way - and then copying and pasting it back in. Your advice will certainly solve many headaches!
What great timing, and what a surprise :-). Thank you. I use a lot offset formulas and names and didn't know how to change my workflow until now. Leila, you are such a great presenter. This is my favorite TH-cam channel. Thank you so much for sharing your extensive knowledge. (Been using Excel since version 1 and never knew this).
I always was feeling upset while trying to change the cell at the chart range and did not know F2 works there also, a great solution! Thanks a lot, Leila Khanum! :)
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
When I asked a magacian how he does all the tricks, he replied that magicians do not reveal. But you, the magician of Excel, display new useful tricks every time, helping us many ways and making our life easier. God bless you 🙏
Your contribution to MS Excel videos are always appreciated...
O.M.G. A Game changer!! I had never thought to hit F2 *while* editing! Thank you, Leila! 👍👍👍👍
You're welcome 😊
15 yrs of using spreadsheet and I have been ignorant about these basics even though I have been using the modes. A BIG Thank you from India.
My pleasure Avishek. Glad to help.
You are just genius! I feel attention to all these little things in excel will make us Pro users. Thanks Leila!
Happy to hear that!
frustrated by this on a daily basis, but because of the ease of backtracking and re-doing it... i never took the time to research it. Great video. Wonderful original content.
Glad it helped!
Why am I learning about this just now? Excel developers definitely find it important. It's just there, sitting on the corner, waiting to be acknowledged. Thank you! Total game changer.
Glad to help Phil!
This video is going to be a great help for folks to understand what is happening around cells while they are using them. It's always good to see channels like us who are doing great jobs.
Very Clever Magnify Glass to highlight the mode : )
Thanks teammate! Glad you like our little visual :)
It works very well!
Very sleek !!! congrats Leila !
Totally agree. May I know how you make that magnifier?
Guys..i am one of those guys who use advance excel on daily basis and trust on me guys this channel is gold mine that will make your life easier...
I have seen this all my life but never realised that it had so much significance until I saw this video. Thanks a lot, saved a lot of frustration, especially in conditional formatting.
You're very welcome!
Wholly cheese, I've been stuck in those various modes and not realized I could switch modes.
Life just got easier!
Thanks....
Glad I could help!
You never cease to amaze me Leila. I'm never disappointed to watch each and every of your videos. Thumbs up!
Thank you! Cheers!
Thank you so much! I have been using Excel for over 20 years and never once have I seen instruction about cell modes! This will be most helpful. You explained it very well.
Great to hear Douglas!
It was a headache to select cells when data validation and other dialogue box opened situations. You healed the pain completely Leila. Thanks for this valuable tip...
Glad it was helpful :)
_point_ mode drives me insane when trying to edit formulas inside the _conditional format_ dialogs!
I'll second that!
Yuuuuup
This is really a something... that majority of the population doesn't know... Keep it up Leila..
Glad you like the video.
That's a great tip!! This has frustrated me forever, now I can tame Excel.
Glad to help Jean-Pierre.
Holly shit!!! I’ve been waiting for a solution for this problem since I started using Excel. Why the majority of people don’t know about this trick. This is a real game changer. I want to give you a big warm hug, Leila. 1000 likes to you. Unfortunately, TH-cam allows to tack only one.
I love your tutorials, so simple and clear. Thank You
Who would have thought to check what mode your in. Super tip. Thanks!
So _that_ was what was driving me insane! I never noticed those modes before. Thanks for enlightening me...and saving my sanity.
Glad I could help 😀
It used to be very irritating to use mouse when moving left or right while editing in dialogue box. This video changed my excel experience. Thank you, Leila.
Glad it helped!
Thanks! Never think anything as basic since most of the people just do stuff but they really don't know the basics. Very helpful.
Glad you like it!
even after 20+ years, I still learn tings about Excel o this channel. Bravo.
Intuitively I always knew this (by trial and error and using F2... you know the drill), but nice to know that there is a visual cue for it in the bottom left corner! This will save me some headache. Thanks for the video!
My pleasure Anatoly.
Enjoy it. NICE presentation Leila. Cannot wait for upcoming topic..
I've always been a keyboard lover in Excel. But some events just forced me to use the mouse 🖱 especially when selecting range for Data Validation or Pivot Table. This video simply frees me even further of having to switch to mouse and helps keep my hands on the keyboard! How on earth didn't I ever try to press this F2 key twice (or more) despite this being the first shortcut I was taught editing a cell when I learnt to use Lotus 123 many years ago (!?!). Thanks heaps, Leila!
My pleasure Emil :)
Thanks Leila! Fantastic! You made my day! Again!
You say it's a basic tip but reading the comments you will see that many of us didn't know that. Thank you so much for your efforts!
You're so welcome Gino!
@@LeilaGharani
This has been driving me crazy for years, and I had no idea you could change the behaviour in dialog boxes - thank you for revealing this awesome (simple) solution.
Glad I could help!
I've been using Excel since the 90s but I never realised that there were special names for the different behaviours of cells in Excel and in particular that they are actually shown on the screen. I wonder what the first version of Excel to do that was. Thanks for the video. I learnt something new.
Glad you found something new Mike.
OMG! That differing behaviour is something that has been bugging me for ages! Thanks for, once again, shedding light on a feature I'd never previously known about.
Happy to help!
Thanks a lot...mam.. I had been trying to get this tip for quite a long time. No one could give me this helpful tip. Today I got.. Thanks a lot.....
this little tip just saved me a lot of headache and time. thank you
Great to hear!
I’ve never noticed that before. The F2 will help me greatly, in Validation & Conditional formatting. Thank you very much for your tutorial.
Great to hear!
I had no idea you could change modes in a dialogue... THIS IS AWESOME!
Thanx so uch!
Glad it's helpful :)
This is the only channel where I always learn something new with each video. Excellent work.
Wow, thanks!
I used to always wonder - now get the difference - point mode/enter mode. Neat visuals to capture the mode, just brilliant. Thank you!
Glad you enjoyed it!
Thank you!!! I am a moderately advanced Excel user and this is one thing that was frustrating me to no end. I had no idea that the solution was so simple!!!
Glad it helped!
You are a treasure for all excel users. I am always thankful for your tips
Leila! your teaching is unique , simple and focused. This is excellent trick. I could'n't understand as to why this is happening and it seemed painfully embarrassing. As I don't have institutional training in excel and learned by doing work and watching some wonderful videos. However, your videos are very informative and smarter. your melodiously super cool voice and balanced pitch makes you stand unique. I really admire you for your effective, meaningful, relevant teaching style. Thank you very much.
My pleasure. I'm glad it was helpful.
This is a small but very useful tip... can't tell how many times I get frustrated when I press the arrow keys in the validation dialogue box! Thank you
I'm glad it's helpful for you.
Thank you. It was really difficult to afford editing in dialogue but you made it easy to me. Thank you
Glad to hear that!
Up until now I considered myself to be advanced Excel user. If I'm advanced user indeed, then I have no idea how to describe yourself. This a real game-changer. Editing of conditional formating was driving me nuts on multiple occassions. Thank you for sharing!
Glad to help Radoslaw!
I've been using Excel probably since 1995. I've been writing VBA Excel applications for about 9 years. It never occurred to me to hit F2 twice let alone that it works in the dialogs. I learned something new today. Thanks Leila! Keep up the good work
Leila, simple and easy and a lot useful this is your videos all the time and this one is no exception
Thanks a lot
Happy to hear that!
Once again you blew my mind Leila! I'm so glad I discovered your Channel. Best excel Channel ever!!
Wow, thank you Roberto!
Excellent video, and I want to thank you for the last part too, of toggling the display of the Cell Mode. Assuming that some settings might be turned off for some users is what makes the best teacher, imo.
I learned this behavior of Excel over several years and now, when I'm teaching students, I include this skill early when we start Excel. Students get so frustrated when they open a dialog box and try to modify a formula. When they ask me for help, my first question is "what mode are you in?" Your tutorial on this is very well done (as I've come to expect from you) and I'll start having my students watch it to help them learn Excel. Thanks, Leila.
Great teaching. Thanks for sharing.
It may be very basic, but I never knew this for 15+ years. Thank you so much
Glad it was helpful!
WELL EXPLAINED SUCH MINUTE CARE - IRRITATING FRUSTRATION FOR WHICH NEVER FOUND ANSWERS GONE FOR EVER , SIMPLY BRILLIANT , THANKS A LOT
Glad it helped
ALL tutorials should be done in this manner!!!
I knew pressing F2 works but I didn't know the background behind it. Thank you Leila :)
You're welcome 😊
That change to edit mode in dialog boxes is really useful!!
I knew about F2 when editing a formula in a cell but I never thought to use it in a Data Validation or Conditional Formatting. That's very helpful. Thank you.
I'm glad to hear that Seán.
I never looked in that corner for that status. great tip! just started your dashboards course. thanks!...from a huge fan of all your knowledge sharing.
Despite using Excel for years, this is the first time I’ve heard this topic explained. Thank you! I’m hoping that it makes the editing of conditional formatting and ranges is a little less frustrating for me.
Glad it was helpful Walter!
Arghhh.. I had plenty of headache with conditional formatting without this tip.. Thanks Leila..
You’re welcome 😊
This is going to save a lot of time and frustration for me. Thank you
My pleasure :)
You are so good, this attention to details makes you what you are, I've started following you few months back. And other than learning excel, I'm also learning on how to make people learn easily. Your videos are so clean and clear. Keep'm coming, Thank you.
Thanks so much 😊
Something so simple that 99% probably had no idea. Thanks Leila
You bet!
Sometimes it is the simplest things we need the most help with. Thank you.
Thank you for this! That has cleared up something about Excel that has bugged me for years. Tremendously helpful!
Great to hear, Richard!
This clarification is tremendously great. Thanks a lot. 😍😍 Your one of subscribers from Myanmar.
Thanks and welcome!
This will 100% change the way I do move around cells and formulas...
Glad this is useful for you.
Very helpful. It explains the magic behind of how often hitting F2 😃thx.
Glad you liked it!
Your voice is heavenly - any topic.
😘
Really handy, thanks! That's been frustrating me for ages!
Glad it helped!
Yes, highly appreciated tip. I have realized that only a few years ago, although constantly working with MS Office. F2 works also fine in MS Filexplorer when you want to quickly rename files or folders.
Thanks for sharing!
I have been using Excel since the 90ies (no, I'm still not a pro, I'm talking basic levels here, as I never really needed advanced excel knowledge until my current job), but still: I've never seen that, heard of it or even realized it was there. I just accepted my fate and that sometimes Excel does not behave the way I expect or want it to. Well, FML! 😄Thank you for this one. I didn't specifically look for it, but it helped me TREMENDOULSY!
And while I'm already here word vomiting all over your comment section: Thank you for ALL the videos you've made - and the ones still coming. I'm far from being a real advanced user (meaning: actually KNOWING instead of googeling my shit until I have the expected outcome [VBAing out weekly and monthly reports via e-mail cuz I'm too lazy to do it manually]), but with the help of people like you I'm getting better everyday. So please keep up the work. 💐😁👍🏻
Thank you so much for the kind feedback! It's really great to hear the content is helpful. Keep learning!
OMG I have been using Excel for over 20 years and I did not know this!
This is very useful, Leila! I wasn't aware if these cell modes.
It seems that you are determined to reveal all the little corners of Excel! :) thank you for sharing.
Indeed
Total determination :)
What i am learning in excel from u is what i used in my class and in ny youtube channel.... thank u for this
Wow, amazing. I knew that F2 was used in some of the user defined functions like counting the cell colour but this is truly a game changer.
Glad it was helpful Tony!
Something missed from a long time. Thanks Leila for the video.
You're welcome 😊
Informative, Precise and Educational as always. Thanks.
Thanks Leila, Excel and you never fail to make you wise.
Happy to hear that!
Hi Leila. Such a great tip! Before I learned this trick, it was super frustrating. F2 is definitely your friend when editing formulas and manipulating ranges. Thanks for sharing it for all to see :)) Thumbs up!!
You always guide us. Nice information Laila.
My pleasure 😊
Hi Leila, I just finished the playlist excel basis. I can't thank you enough for the detailed videos! Keep up the excellent work!
Awesome, thank you Misha!
I am learning so much from your videos. Thank you.
I'm so glad!
Fantastic Leila; frankly I have hardly paid any attention to this mode thing. I especially like the the use of F-2 to switch between Edit and Enter mode in conditional formatting and editing an existing formula. Lovely video blonde girl :)
Blonde?? #lastvisitathairdresserwas3monthsago 😁
Never noticed those little info on the bottom left, guess a quick look to the mode saves a lot of time. Thanks, always interesting stuff here.
This is so useful to know! It was only yesterday when I was writing a really long formula in the conditional formatting dialog box, and annoyingly I could not get the text cursor to go to the very end. And with no way of resizing the box (that _needs_ changing), I ended up copying and pasting the formula into the worksheet - working on it that way - and then copying and pasting it back in. Your advice will certainly solve many headaches!
I've definitely been there Andrew :)
What great timing, and what a surprise :-). Thank you. I use a lot offset formulas and names and didn't know how to change my workflow until now. Leila, you are such a great presenter. This is my favorite TH-cam channel. Thank you so much for sharing your extensive knowledge. (Been using Excel since version 1 and never knew this).
Wonderful! Glad you found something new Mike :)
I knew about this but I could not have explained it as clearly as you did.
Love this. Thanks so much. My mode has been disabled nd I didn't know how to "manage" these types of challenges .
OMG! Thank you! It was always sooo frustrating while editing conditional formatting!
Glad it helped!
Thank you Leila.Now that know how to deal with conditional format, it is just so easy.
This was something that I really never noticed.. Awesome...!!!
Thank you so much Leila...
Happy to help!
Unfortunately not helpful for me now but thank you for sharing your knowledge with people. Thank you very much.
I always was feeling upset while trying to change the cell at the chart range and did not know F2 works there also, a great solution! Thanks a lot, Leila Khanum! :)
Happy to help!
As always great explanation even of simple subject
This is like pushing F4 multiple times for cell references. This will be very handy for chart ranges.
Yes, exactly :)
This is a revelation!!!! I had no idea it existed!
Glad you like the video 😀
Simple but very powerful. I've been looking for this solution
this was causing a lot of headage, I never knew this. Thanks for bringing this up
Mam, Thanks your contribution to MS Excel tutorial are always appreciated...
Glad to hear that
That was certainly an eye opener.... can't thank you enough....
My pleasure.