Excel - Fill in empty cells with data from the cell above

Подписаться 4,1 тыс.

Просмотров 207 тыс.

50% 1

If you want to be able to sort, subtotal, or filter a list in Excel you need key data to be repeated on every line. Combining a few Excel tricks makes this an easy process.
1 - Use Go To - Special - Blanks to select the blank cells
2- Create a formula pointing to the cell above and use Ctrl+Enter to enter it into all of the selected blank cells.
3 - User Paste Special - Values to convert those formulas to their result.

Опубликовано:

19 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 115

@annettefreeman8671 Год назад

THANK YOU!!!! I kept getting the error but changed the sheet to General, per your instructions, and it totally worked. You saved me so much time (although I had already wasted a ton just trying to find out how to fix it). You saved the day!

@user-kk4dc2qe7g 6 месяцев назад

This saved me so much time and your video was great and to the point - loved it, 5 stars!

@MattDimock 5 лет назад

10.7k views and only 6 comments? Ungrateful b@$t@rd$! :) I had over 900 unique values and a total of 16k rows that needed to be populated for two different columns. Your 3:55 minute long video just saved me countless hours of manual labor. Thank you so much for taking the time to publish this!

@Addersea 3 года назад

This was incredible and exactly what I needed. Thank you so much!

@jessedoty3466 5 лет назад

This just saved me hours

@maukadigital 4 года назад

Just saved us 2 hours. Thanks !!

@manjunathandp3175 2 года назад

Sounds Good. I got stucked with text & general. Now it is cleared. Thanks Champ..

@bhsharma8618 Год назад

Thanks Bro it's just soo awesome. This removed my problems

@seantratervel4885 2 года назад

WAW!! This video saves me hours of time! Thank you sir!

@kiavashkiaee5565 4 года назад

Awesome! been scratching my head for this!

@nancykant2265 2 года назад

thank you so much you saved my life

@ghanshyambairagi8093 Год назад

This is incredible and exactly what I needed. Thank you so much dear.....

@NShah-kg5tt 2 года назад

Thanks a bunch! You saved a tone of time for me!!!

@superpollo1303 3 года назад

You saved me so much time, thank you so much

@aikoolinares 3 месяца назад

thank you! very easy to understand and follow

@meandmydodge 3 года назад

Liked and Subscribed ... Just because of This video ... saved me from investing lot of time and efforts in current task in hand ... Bravo Bro ... :)

@joeeydouglas 3 года назад

Thanks a ton brother for such an amazing technique. Knowledge, information makes a person shine or sparkle like a star and you are a star for sharing the knowledge

@prabinkumarthapa9466 3 года назад

bro u saved me a whole lotta time ....i wanna thank u so much man

@EmpressLishy Год назад

Exactly what I needed! Thank you!

@cozycubix 4 года назад

You save my 2 hours Thank you bro.

@rachelunclebach6469 2 года назад

Thank you soooo much!! I was looking for this exact solution everywhere!

@alexandramcginnis5666 3 года назад

Thank you!!! Life. Changing.

@gazula3 4 года назад

Thank you SO MUCH! this video literally saved countless time. Been going nuts trying to figure this out!!

@kylenjunior4263 3 года назад

I dont mean to be off topic but does someone know a method to log back into an Instagram account? I was dumb forgot my login password. I would appreciate any tips you can offer me

@milannoah3306 3 года назад

@Kylen Junior instablaster :)

@kylenjunior4263 3 года назад

@Milan Noah i really appreciate your reply. I got to the site thru google and im waiting for the hacking stuff now. Looks like it's gonna take a while so I will reply here later when my account password hopefully is recovered.

@kylenjunior4263 3 года назад

@Milan Noah It did the trick and I finally got access to my account again. Im so happy:D Thanks so much, you saved my ass !

@milannoah3306 3 года назад

@Kylen Junior glad I could help :)

@BurhanMohamed 2 года назад

thank you bro. helped me a lot. saved a lot of time

@ashketchum7142 4 года назад

Legend! Thanks, I was going through 2000 rows one by one

@IQAcctSolutions 4 года назад

Glad it helped!

@nehalshah4391 4 года назад

Thank you, saved me hours of work, great tip.

@DeniseFarro Год назад

This s so helpful. Thank you!

3 года назад

Nice! Thank you.. I got 3 free days now :)

@fredrickrajaprakashan3639 2 года назад

This is exactly what I was looking in for. Thanks !

@areebiqbal7225 5 лет назад

Thankyou for this. Precise and short.

@nareshvarma5310 2 года назад

very much helpful, use to struggle lot...thanks

@luiluilu123 Год назад

Life saving! Thank you so much

@thedrtamergouda 3 года назад

you saved my day Thanks

@aditya19945 3 года назад

You are a life saver!

@lalmanidas134 Год назад

this is an excellent tip. Thank u

@kundankumarfca 3 года назад

Really super value added

@TheCcastle 2 года назад

this is SO useful! thank you so so much for sharing!

@uwugamerbee 2 года назад

This is so helpful. Thank u so much!

@private54321 4 года назад

Amazing, you saved a lot of time :)

@rrcc6868 2 года назад

Thank u sir very helpful tips for me

@zanjisichone9260 2 года назад

Very helpful!

@endtroducing 4 года назад

Thank you for this helpful video!!

@priscilacpgmartinsbaldacci2616 11 месяцев назад

Thank you so much!!!

@ahmedanwer888 3 года назад

Thank you it worked!

@captive-audience 7 месяцев назад

THANK YOU, JESUS

@mvlogs9289 2 года назад

Your amazing dear made my day

@chamarabs 2 года назад

thanks a lot..really helpful to me

@shakeelasghar12 4 месяца назад

Learnt. Thanks

@kittanes7438 3 года назад

you save my life time

@dmc826 4 года назад

Thanks, so useful! I thought I was going to have to create a macro, but this is much easier.

@cindyjohnson2485 4 года назад

Great tip! Worked perfectly! Thanks for sharing.

@Himanshu260923 Год назад

Thank you very much 😊

@eileenrouski5419 2 года назад

Thank You!

@gregorysorenson8474 2 года назад

Thank you!

@parmarsavlacocharteredacco6723 4 года назад

VERY USEFUL TIP

@TrevorGinn 4 года назад

FANTASTIC!!!! Thanks a lot!

@RR-kj3sz 2 года назад

Thank you so much for this! Such a time saver 🙌🏽

@tehiladar8606 4 года назад

Super helpful! Thanks for sharing.

@NordeastMarie 3 года назад

Great for ediscovery metadata files. Copy DateSent and DateReceived to attachment files prior to loading for easier sorting by reviewers.

@pravinghanesh 3 года назад

Thanks! This helped a lot.

@priyankaprajapati1752 4 года назад

thank you, saved time

@caglarsakakli5766 2 года назад

Thank you so much! That was a lot of help.

@vsbpatel307 4 года назад

Thank you so much sir to save a lot of time.

@armindolopes2248 Год назад

Excelent Job

@Juanboosh 3 года назад

dude, thank you.

@agarwalsushil Месяц назад

Thanks a lot

@food.travel.entertainment7579 3 года назад

Thanks , it helped

@matte4president 4 года назад

Priceless, thank you!

@rakeshshastri 3 года назад

This helped me a lot, thank you

@divyadarshini4660 3 года назад

Awesome!!!!

@bartvn9593 4 года назад

You are the man.

@vijjithomas598 4 года назад

Very useful tip

@wendymaldonado111 4 года назад

OMG thank you soooooo much save time and energy!!!

@vibhorjain 4 года назад

It helped me Thanks for posting this!

@dimitris-panagiotischatzak2877 4 года назад

Thank you very much!!!!!!!

@eldoulis 4 года назад

Very useful, Thanks!

@tanyaschouteten 4 года назад

AMAZING!!! Thank you so much :)

@ohmaimariapie 2 года назад

THANK YOUUUU

@glynharper 4 года назад

Extremely useful video. Many thanks for uploading. :)

@redtaur 2 года назад

My data column has lot of blanks in between and i need to copy the cell below in only the cell above and leave the rest of them blank. Example - i want to copy A8 in A7, A11 in A10, A34 in A33 and so on. But leave all other cells blank. Can somone help me with this?

@sachinsingh-io5tl 6 лет назад

Thanks for this video, its helps me a lot

@chitonge1 5 лет назад

Really appreciate this video

@Emulives 5 лет назад

thanks. Just what I need !!!

@world752 3 года назад

I sometimes forget the procedure and needs to see video for this Anyways you saved my a** in front of boss when he caught me off guard.

@muhammadasghar9145 4 года назад

Thanks A Lot

@mkp2221989 2 года назад

Getting #REF!

@philstavro Год назад

why does the up arrow key do something else for me?!?!?!

@CheeseStew101 4 года назад

Yes!!!! It worked!

@wolfgangharland4156 3 года назад

How do I get this to run across all the columns (so first run this on column A, then B, then C, etc...). I think this is a simple question, but I haven't written code in forever and can't remember.

@Colabala2 6 лет назад

MARVELOUS THANKS A LOT!

@janelle4x4 Год назад

I know that there is a way to make it look like you had it at first even though the data is there so that you can properly filter and still get all the data. Do you know how to do that? Right now I have all the data in there and changed the font color to the same as the cell color so you just can't see it, but I know there is a better way.

@steverentz1984 3 года назад

You da man!

@nurlanus7502 2 года назад

Awesome

@sarablom3733 5 лет назад

Awesome!! Thanks!!

@IQAcctSolutions 5 лет назад

I'm glad it helped. I wish I could say I figured this out myself. I also wish I had learned it years before I did. It would have saved me countless hours of work.