Excel Tips - Don't Use Formulas! Use Ctrl + E Instead
ฝัง
- เผยแพร่เมื่อ 19 มิ.ย. 2023
- This quick video shows you how powerful the Ctrl + E combination can be in Excel with some examples.
Ctrl + E is a keyboard shortcut for flash fill that recognizes patterns in adjacent columns and fills the current column. This will not replace the need for all formulas but it can help with common tasks we perform in Excel.
Hello everyone, this video covers the topic of flash fill (Ctrl + E as a shortcut) in Excel. This will not replace the need for all formulas but it can be a great way to complete simple tasks that follow a pattern. I appreciate all the feedback and comments below and will look to implement your thoughts. Thank you for the support and wishing everyone a great day.
Yes, definitely not a replacement for formulas. It's also kind of dangerous. You assume that the information is a formula and yet when you correct the one of the last or first name fields, the name doesn't get updated. Worse, if you don't know this, you won't notice it.
As is, I consider it a novelty and not something I would want to have to spend time thinking about as to when I was willing to accept it versus putting in a formula. I would be much happier if it gave the option to put in the formula that it "determined" was what you wanted.
It is sort of like writing with a pen rather than with a pencil and eraser. You just know that if you use it, someone is going to want a tweak made.
What is the easy way for combine Birth (in cell A1) and Date (in cell A2) into Birthdate (in cell A2)?
@@BW022 Yup, this is pretty much worse than using formulas. Goes right into my "never use this shit" bin
What about the opposite?
I've been using Excel for years and never saw this cool shortcut until your video. Thank you! I was set to retire this August, but I've decided to put it of for another year, just so I can use your trick at work!
Thank you =)
Let me know if there are any other tricks you'd like to see.
The fact that it fills the fields with the current values rather than dynamically recalculating them means the process is human-controlled every time. Formulae take a little more time to setup, but will recalculate every time.
@creanero Correct. One DOES NOT actually replace the other, especially considering the distinct functionality...
Exactly. Ctrl+E is for this type of one off situation that comes up very often.
formulae?
@@neverhit17 _Formulae_ is an acceptable plural of formula however _formulas_ is normally used in general conversation like this.
I saw the same thing. Without dynamically updating, I have a hard time finding a use-case for this.
That's good introduction. But also you could have mentioned the technical name for this which is "Flash fill" in excel. This will help people to explore it in more detail.
nice
Been working with Excel for 20 years now. Did not know this… Wish I could like your video more then once
Ditto!
That's a relatively recent feature, so no :)
I'm shocked! Use professionally excel for years, but this one is one of the best!!! Thanks!
🤯 MY MIND HAS JUST BEEN BLOWN BY THIS TIP!
Congratulations! You just broke the minds of my Teams group chat. Now we are all calculating how many hours we have collectively lost by not knowing this... :P Thanks for the video!
I have been learning Excel for a few weeks now and this is one of the best tips I have seen.
Thank you for watching. Let me know if you have any questions.
You've just Ctrl + E'd my life. Thank you 😊
As always in Excel, the simpler the solution is (if there is a feature on the Ribbon or a shortcut key combo), the less flexible or useful it is if the data changes.
Eureka! I wish I knew this decades ago...
UNREAL.. this is just incredible.. more please
Wow! That was the most productive 2:30 minutes of my whole day! Thank you 🙏🏻 for sharing!!!
Really appreciate the comment, thank you for watching =)
This is really really good. I used to think I a master of Excel. Never knew of this. Thanks for sharing
Wow, concise with no filler. I'm now a subscriber. Thank you
You don't have to ask for a subscribe, I find it very helpful.
Wow, the Ctrl+E is soooo powerful. Saved me a million years in using functions. Thank you so much for sharing this. 👍👍
Boy, some of these comments are really mean spirited. If you don’t want to use control E then don’t use it. Get a grip!
Thanks for the tip
This is great feature I'm pleased to know about. I can see me using it in specific situations but it will never replace formulas if it's not dynamic.
Thank you love the bite sized video and straight to the point with example 😊
Wow….I don’t know about this before…thanks for sharing this tips 😊
At time of writing, Flash fill is really great, until the source data changes and the non-dynamic flash-filled column doesn't update until you Flash Fill again. Only formulas are guaranteed dynamic. Also it only seems to work with contiguous cells and not with large gaps between columns.
I was wondering about that, thanks
And it only works on the right side. Plus, why in hell would one ever use a spreadsheet to generate a form letter? A word processor document that uses the raw data is the better choice.
Thank you so much for this helpful tip. As a teacher, I can see where this application will replace CONCAT for extracting Given and Family names but also LEFT and RIGHT which I use to parse student numbers. Excellent tip! Great for setting up Mail Merger to generate test results. After sorting by score and inserting a row between grades, I was able to quickly make grade-based comments, and then delete the blank rows.
Thank you for explaining and usage of flash fill option
This is going to help how I organize my audits and outreach. Thank you for sharing!
Great tip and a time saver! Thanks!
Simply a great no fuss tip - thanks
Absolutely amazing tips! Thanks!
Thank you so much!
This tip has changed my life! Thank you
Excellent video, Thank you for sharing your Knowledge!
Very useful.... Learned something new... Thank you
Soon Excel will do what we think. I've said it often, it's an amazing program that I wish I knew more about.
Really appreciate the comment.
Just WOW!!! I struggle daily with excel, this will be a game changer- Thank you
I've used this often when doing data cleanup (prior to even basic knowledge of Power Query [much better name than "Get & Transform"]). The main problem I see with it is that it's not sustainable or easily extensible. It's great for quick and dirty (worked great on my 20,000 row sheets of data). But repeated use makes it quite difficult. If you're dealing with large amounts of data requiring lots of manipulation and repetition, Power Query is a much better way to go (in general).
Now, if you can use this "formula-by-example" approach, where you just enter examples based on data, and you can get a formula produced, that would be something. Regardless, it's always helpful to have a nice toolbox full of handy tools. You just need to know limitations and functional expertise (what works best in particular situations or types of data). Practice and experiment with COPIES of data (I call this play so it seems more fun).
I know, why the hell would they drop the powerquery name, if you need help online is easier to use powerquery name, is a unique identifier, the irony!
Thank you! Although I usually need the output to change when inputs are changed, added or deleted, this is another quick way to do something on the spot.
OMG! You have just made my life a bzillion times easier!!!!
Hey wanted to say thank you for the super chats =)
Let me know if you have any content topics you want me to cover and thank you for watching.
Thanks for this tip. Its really good shortcut.
That's an amazing shortcut. Had no idea, thanks.
Certainly enjoyed it. very good tips.
Great tip. Thanks for sharing.
Well explained, thanks for sharing!
Thank you for the comment =)
Very cool. I love the shortcuts.
A spectacular shortcut that I wish I would have learned about years ago! I will share this with my team and look for other videos from you. Great presentation, and in the perfect amount of time to make the point. I've read through many of the comments and learned there are some limitations (like when the data changes, the values don't update which is also helpful to know. Well done!
Thank you for the comment =)
Holy smokes, this blew my mind. What a game-changer it's going to be for me. Thank you!
Honestly, this is good. thank you thank you. I have subscribed
This is a very and helpfull great tip and has many uses, increase productivity a lot.
This is a game changer for me! Thanks so much! 🤗
This is cool. I'm sort of a power user and didn't know about this.
That's incredible, I like formulas but this is very useful for quick and dirty tasks when I'm not going to use the workbook over and over.. This can be a real timesaver. thanks for searching
I reckon I know my way around excel (formulas, macros, and all other advanced functions) but this was absolute magic to me haha how I never knew this before is simply laughable. Would have made my life so much easier back in the day when cleaning up massive data sets. I do need familiarise myself with all the new excel functionality though. Thanks for this 👍🏻
Thank you so much for the comment, glad this video helped =)
Thanks. As an educator this will be helpful to my students.
I never knew this.. Bummer. Loved it.. Thanks a lot...
This is a great find. Thank you very much.
This has made my life much easier. Great 1!
Awesome and very useful, using it now
Thank you for sharing this trick.
Really appreciate the comment =)
Very Useful tips
So cool! Great tip - huge timesaver!
I've been using spreadsheets for thirty years and I think this is magic!
I currently use free version of WPS Office and they call it Flash Fill.
That is brilliant. Thank you
Wow, super useful tips!
wow, that's mindblowing ! thank you for the tip
Thank you so much for checking out the video =)
You just made my day! Thank you!
That was cool, hope to try that soon. tHanks for the video
This is very helpful, thank you very much
Very helpful! Thank you 🎉
Excellent tip
oh wow thank you for sharing this new tricks
I feel like you just saved me a lot of time. Thank you
Really appreciate it =)
Good tip, thanks!
Now that’s extremely helpful.
Awesome tips...thanks for sharing 👍
Thank you for watching =)
Great video! I did not know, now I do. Thanks!
thanks for the info
Awesome tip, thanks
great tutorial thank you so much
Thank you!
Thank you mr. Career for that. This is very powerful
Really appreciate the comment =)
@@CareerSolutionsforTodayThanks
Excellent, thank you!
That helped me so much. Thanks.
Really appreciate the comment =)
Great tips! I especially like being able to separate data. When I download data from our database, it comes with so much junk in one cell I don't need for my report.
That's pretty cool. Thank you for that.
the last use of ctrl+E that i was looking for like crazy, 2:20
thank you sir!!!
Love it thanks for the tip
Thank you for the tip.
Helpful video, Thanks
Thank you for commenting
Thanks, it looks good. One condition needs to be added. This function works in the adjacent column/s and to ensure there are no blank columns in between
Thank you for the feedback I made an updated video explaining in more detail. Hope you have a great weekend =)
Wow that tip is literally gold !!
Really amazing tip sir.....
Great tip!
Great tip! Thanks!!
Thank you also =)
Very useful. Thanks.
Thank you! So useful
Mind blown! Thank you! 🤯
I have a hard time remembering formulas. Thank you for this!
Formulae. I am not at all surprised you struggle, you are very probably an "American".
A brilliant tip, thanks.
Never knew this. Awesome!!!
This is an awesome function. I had no idea this existed.
Really useful, thanks.
I've gone through these comments and for the life of me cannot understand why there are so many fools that walk this earth.
Great video. Succinct, clear, audio/video was crystal clear, explanations spot on. I have to admit I saw this pop up on my home page and I was reluctant but came out pretty darn amazed. Thank you, great job.
Thank you for watching =)