Excel Tips - Don't Use Formulas! Use Ctrl + E Instead

Рет қаралды 888,838

11 ай бұрын

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.

Пікірлер: 750

@CareerSolutionsforToday 11 ай бұрын

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.

@BW022 11 ай бұрын

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.

@geraldboutin1674 11 ай бұрын

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.

@sallyho146 10 ай бұрын

What is the easy way for combine Birth (in cell A1) and Date (in cell A2) into Birthdate (in cell A2)?

@RJiiFin 10 ай бұрын

@@BW022 Yup, this is pretty much worse than using formulas. Goes right into my "never use this shit" bin

@DriversFromHere 9 ай бұрын

What about the opposite?

@creanero 11 ай бұрын

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.

@nicadi2005 10 ай бұрын

@creanero Correct. One DOES NOT actually replace the other, especially considering the distinct functionality...

@AngusNB 10 ай бұрын

Exactly. Ctrl+E is for this type of one off situation that comes up very often.

@neverhit17 10 ай бұрын

formulae?

@AngusNB 10 ай бұрын

@@neverhit17 _Formulae_ is an acceptable plural of formula however _formulas_ is normally used in general conversation like this.

@ellisz5972 10 ай бұрын

I saw the same thing. Without dynamically updating, I have a hard time finding a use-case for this.

@DPB1947 12 күн бұрын

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!

@CareerSolutionsforToday 11 күн бұрын

Thank you =) Let me know if there are any other tricks you'd like to see.

@nitinthokare 9 ай бұрын

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.

@PodDeep 8 ай бұрын

nice

@EuropeanOnion 9 ай бұрын

Been working with Excel for 20 years now. Did not know this… Wish I could like your video more then once

@barbdunn8886 4 ай бұрын

Ditto!

@BoraHorzaGobuchul 21 күн бұрын

That's a relatively recent feature, so no :)

@igalye 9 ай бұрын

I'm shocked! Use professionally excel for years, but this one is one of the best!!! Thanks!

@feedbackdt 10 ай бұрын

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!

@AlMiner 9 ай бұрын

🤯 MY MIND HAS JUST BEEN BLOWN BY THIS TIP!

@SaltyCelt 2 ай бұрын

I have been learning Excel for a few weeks now and this is one of the best tips I have seen.

@CareerSolutionsforToday 2 ай бұрын

Thank you for watching. Let me know if you have any questions.

@a_little_bird Күн бұрын

GREAT explanation! I'm an excel noob and this was quick and to the point. Thank you!

@CareerSolutionsforToday 8 сағат бұрын

Thank you!

@andischuff 5 ай бұрын

Wow! That was the most productive 2:30 minutes of my whole day! Thank you 🙏🏻 for sharing!!!

@CareerSolutionsforToday 5 ай бұрын

Really appreciate the comment, thank you for watching =)

@diggee172 9 ай бұрын

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!

@matthewdufty606 2 ай бұрын

Thanks for the tip

@MyRoyalties 9 ай бұрын

You've just Ctrl + E'd my life. Thank you 😊

@gorflunk 7 ай бұрын

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.

@christinerumanouw8077 11 ай бұрын

UNREAL.. this is just incredible.. more please

@1SGPARKER 10 ай бұрын

Eureka! I wish I knew this decades ago...

@vincentbrown4926 10 ай бұрын

Wow, concise with no filler. I'm now a subscriber. Thank you

@minderDOTorg 10 ай бұрын

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.

@kmacdowe 9 ай бұрын

I was wondering about that, thanks

@c17nav 9 ай бұрын

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.

@30secinspiration25 6 ай бұрын

You don't have to ask for a subscribe, I find it very helpful.

@Van_Wilder Ай бұрын

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 👍🏻

@CareerSolutionsforToday Ай бұрын

Thank you so much for the comment, glad this video helped =)

@mohdjibly6184 9 ай бұрын

Wow….I don’t know about this before…thanks for sharing this tips 😊

@fbilgrami 11 ай бұрын

This is really really good. I used to think I a master of Excel. Never knew of this. Thanks for sharing

@Soei23 3 ай бұрын

Soon Excel will do what we think. I've said it often, it's an amazing program that I wish I knew more about.

@CareerSolutionsforToday 3 ай бұрын

Really appreciate the comment.

@philb4462 10 ай бұрын

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.

@yian9082 7 ай бұрын

Wow, the Ctrl+E is soooo powerful. Saved me a million years in using functions. Thank you so much for sharing this. 👍👍

@jackcurl2005 11 ай бұрын

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).

@dafeac 10 ай бұрын

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!

@power-reconcile 14 күн бұрын

Well explained, thanks for sharing!

@CareerSolutionsforToday 13 күн бұрын

Thank you for the comment =)

@wayneyadams 6 ай бұрын

OMG! You have just made my life a bzillion times easier!!!!

@CareerSolutionsforToday 6 ай бұрын

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.

@cm3984 9 ай бұрын

Thank you love the bite sized video and straight to the point with example 😊

@brentculligan9030 9 ай бұрын

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.

@RJ-lf8ex 11 ай бұрын

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.

@CareerSolutionsforToday 11 ай бұрын

Thank you for watching =)

@rameshd9038 9 ай бұрын

Thank you for explaining and usage of flash fill option

@indiafoxtrotbravo 11 ай бұрын

This is going to help how I organize my audits and outreach. Thank you for sharing!

@karenbarry99 Ай бұрын

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!

@CareerSolutionsforToday Ай бұрын

Thank you for the comment =)

@reneberthet9168 11 ай бұрын

Great tip and a time saver! Thanks!

@sunshinelefty 5 ай бұрын

Thank you for "Flash Fill"!

@CareerSolutionsforToday 5 ай бұрын

Thank you for watching =)

@zoomingby 11 ай бұрын

Absolutely amazing tips! Thanks!

@CareerSolutionsforToday 11 ай бұрын

Thank you so much!

@janewalters9281 10 ай бұрын

Just WOW!!! I struggle daily with excel, this will be a game changer- Thank you

@rotaman8555 10 ай бұрын

This tip has changed my life! Thank you

@stuartmiller7419 11 ай бұрын

Great tip. Thanks for sharing.

@mochlif 3 ай бұрын

Thank you mr. Career for that. This is very powerful

@CareerSolutionsforToday 3 ай бұрын

Really appreciate the comment =)

@mochlif 3 ай бұрын

@@CareerSolutionsforTodayThanks

@jig1056 9 ай бұрын

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

@henryallan9167 10 ай бұрын

Simply a great no fuss tip - thanks

@lorettademaio4334 3 ай бұрын

Thank you for sharing this trick.

@CareerSolutionsforToday 3 ай бұрын

Really appreciate the comment =)

@cathiemerry9786 9 ай бұрын

Very cool. I love the shortcuts.

@thiagarajanganesan8377 Ай бұрын

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

@CareerSolutionsforToday Ай бұрын

Thank you for the feedback I made an updated video explaining in more detail. Hope you have a great weekend =)

@ardentdfender4116 9 ай бұрын

Now that’s extremely helpful.

@LaserJet58 9 ай бұрын

Excellent video, Thank you for sharing your Knowledge!

@brayandsouza3810 11 ай бұрын

Very useful.... Learned something new... Thank you

@canadagood 10 ай бұрын

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.

@hawkins55 10 ай бұрын

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.

@Janokuad 11 ай бұрын

This is a great find. Thank you very much.

@carlw 8 ай бұрын

That's an amazing shortcut. Had no idea, thanks.

@philipjose8092 6 ай бұрын

Certainly enjoyed it. very good tips.

@BelalAlDroubi 10 ай бұрын

Holy crap THIS CHANGES EVERYTHING!!

@bekir8504 8 ай бұрын

Thanks for this tip. Its really good shortcut.

@miserablerhurensohn 10 ай бұрын

I knew that if I went to the trouble of entering a formula, I could copy that cell and paste it down the column and it would use relevant new cells to perform the same function but this Control+E is nice - Thanks.

@daveg5857 11 ай бұрын

This is cool. I'm sort of a power user and didn't know about this.

@ranimaharaj-sharma4332 9 ай бұрын

I never knew this.. Bummer. Loved it.. Thanks a lot...

@rhianewton451 11 ай бұрын

So cool! Great tip - huge timesaver!

@FeistyMimi024 6 күн бұрын

Great tip! Thanks!!

@CareerSolutionsforToday 6 күн бұрын

Thank you also =)

@debadri 11 ай бұрын

Wow, this is a game changer.

@CareerSolutionsforToday 11 ай бұрын

Thank you for watching =)

@sudhirsharma9103 11 ай бұрын

Wow, super useful tips!

@richardsiemion5903 3 ай бұрын

When I was splitting time that didn't allow me to use Textsplit for some reason.... this would've saved me more time than I am willing to admit.... Thank you

@CareerSolutionsforToday 3 ай бұрын

Thank you for commenting

@midwestlaserengraving644 2 ай бұрын

I feel like you just saved me a lot of time. Thank you

@CareerSolutionsforToday 2 ай бұрын

Really appreciate it =)

@mikizhero 11 ай бұрын

Honestly, this is good. thank you thank you. I have subscribed

@IndustryPets 10 ай бұрын

Very helpful! Thank you 🎉

@IanHillan 10 ай бұрын

That is brilliant. Thank you

@JeremiahPatsika 10 ай бұрын

This has made my life much easier. Great 1!

@Srinivasan.Answers 11 ай бұрын

Very Useful tips

@MadMonk67 10 ай бұрын

Holy smokes, this blew my mind. What a game-changer it's going to be for me. Thank you!

@KinkyJalepeno 11 ай бұрын

Wow that tip is literally gold !!

@shroomzzz 11 ай бұрын

Never knew this. Awesome!!!

@graciasnara 3 ай бұрын

Thanks. I am grateful to your video.

@CareerSolutionsforToday 3 ай бұрын

Thank you for commenting =)

@mdk4218 Ай бұрын

That helped me so much. Thanks.

@CareerSolutionsforToday Ай бұрын

Really appreciate the comment =)

@cliftonm.1578 8 ай бұрын

This is a game changer for me! Thanks so much! 🤗

@BoraHorzaGobuchul 21 күн бұрын

With real world data, it often requires double checking and adjustment. Particularly when selecting a substring from a string. After several manual entries it usually gets the right way to do the task, but if you have multiple rows of data, you still have to check that out for everything right.

@saskiamesternuhh 9 ай бұрын

You just made my day! Thank you!

@carlvaz 6 ай бұрын

Good tip, thanks!

@parrishburch 10 ай бұрын

Awesome and very useful, using it now

@fessit 11 ай бұрын

Great tip!

@MrMattberry1 11 ай бұрын

Awesome tip, thanks

@austind.239 10 ай бұрын

the last use of ctrl+E that i was looking for like crazy, 2:20 thank you sir!!!

@miasmic100 8 ай бұрын

Excellent tip

@abdullahbuxoo6944 3 ай бұрын

Thanks. As an educator this will be helpful to my students.

@codycampbell7434 9 ай бұрын

That's pretty cool. Thank you for that.

@panama-canada 10 ай бұрын

Love it thanks for the tip

@tjhills75 11 ай бұрын

I'm guessing that Ctrl-E is not dynamic so if i add extra rows to my data table or replace the table with new data it won't update automatically? It is a handy tip but need to be aware of any limitations

@CareerSolutionsforToday 11 ай бұрын

Hey there, thanks for the feedback. You are correct in that it won't dynamically update. It is similar to pasting as values after a formula is entered. Helpful for quick tasks but won't replace need for formulas in many situations. Have a great holiday weekend =)