How to use AutoFill & Flash Fill in Excel

How to use AutoFill & Flash Fill in Excel - Tips for Beginners

Рет қаралды 22,274

Күн бұрын

Пікірлер: 22

@TeachersTech 6 ай бұрын

You've probably noticed a typo in the flash fill example on the phone number. I wrote 2475 at the end of the first number and it should have been 7890. Flash fill couldn't recognize the pattern and when I copied it down, it kept the 2475 at the end and didn't notice 😳 I've updated the practice sheet so it is correct. Sorry about any confusion.

@meatiethatsme2471 6 ай бұрын

Thank you Jamie. I was wondering about that. Great video.

@dorissarpong5496 2 ай бұрын

Nice👏👏 l never knew so simple I love it❤❤❤

@michaelmansaray9366 7 ай бұрын

Thanks a lot.❤ I never knew the Autofill function could be used in reverse.

@TeachersTech 7 ай бұрын

You’re welcome!

@estherlawanson7951 Ай бұрын

Thank you so much, you are amazing

@s.baskaravishnu22 3 ай бұрын

Many thanks

@banneman4376 7 ай бұрын

Clear video, my compliments. However, if I use the keyboard shortcut ctrl + E in my Excel 2019, Excel will read the cell in question. When I add flashfill to the quick access toolbar and stand on the icon it shows the shortcut Ctrl + E. But it does not work. Do you have a solution for this problem?

@ashleyparkhurst5005 3 ай бұрын

I've watched so many videos on flash fill and I'm currently taking a course at my local library on Excel. Everybody is telling me that you only have to type in the first thing of a list, however it only seems to work for me if I type in the first two. Is this because of an update that happened? I was also told that if you type directly into a cell the second thing in a list should start to appear after typing the first couple of letters, but that never seems to work for me.

@OlugbengaOluwasina-tg8ud 4 ай бұрын

Thanks for the tips on flash fill. What if I want to add a prefix like mailto: before email addresses in the same column. How do I flash fill the entire column?

@oboycorporation Ай бұрын

no flashfill option even its enable in option, help??

@Chaithra777 7 ай бұрын

Hello Jamie. I like your way of teaching. Thanks for your lessons. I have a question though. In the flashfill, the phone numbers are incorrect as the last 4 digits are repeated in the rows after Flashfill.

@TeachersTech 7 ай бұрын

Thanks, when I did it, I hurried through it. I should have filled another row to help the pattern.

@Chaithra777 7 ай бұрын

@@TeachersTechoh! i tried it now. that won't be necessary i guess. as you have entered the last 4 digits 2475 in the first row, which is not in the data. thats's the reason it showed the error. when i tried to enter the first row correctly. the rest are coming in line.

@intermixhector2902 5 ай бұрын

Updating updating systems good is it am lost on updating it

@Tesnobay 7 ай бұрын

The telephone # example is incorrect?

@MoniMeka 6 ай бұрын

Yeah, they all had 2475 at the end. He didn't see that?

@TeachersTech 6 ай бұрын

I had a typo on the first line and didn't notice. The first number needed to be corrected; the last four digits didn't match, so it couldn't find the pattern.

@user-cc8hs9rc9t 4 ай бұрын

Hello there. tyvm for the clip. i have a question; flash fill only works on columns, ins`t it? best regards from Portugal

@theriemannbreaker8174 5 ай бұрын

Flash Fill: 5:09

@MoniMeka 6 ай бұрын

Why didn't the phone numbers do the same number at the end? They all had 2475 at the end. 🤨

@TeachersTech 6 ай бұрын

I wrote the wrong phone number on the first line and it didn't match. On the practice file I had 2475 at the end, should have been 7890. Just make the change on the sheet and it should work.