I didn't originally think this would be useful, but it turns out that these methods can be very helpful. Right now I need to add the number for the car to each row in a 155 page pdf. That would take long without these features!
Dear, this is quick and nice, thx for video. I'm using also small other technique, if you have data like video- open the filter list, click only "empty" boxes then type into [cell B3] =B2 , copy this cell and paste down :) Enjoy! All the best for you! MK313
Thanks for this cool filling down techniques :-) I like macro technique thanks for this macro solution. Could i have your personal workbook containing macros existing in your macro rubban thanks :-)
Hi, I am one of your subscriber and your video presentation very helpful and informative for line if work, by they way i just having a little hard to create a drop down list text with percentage value and equal to average,if you can help me,really appreciate.😊
IF you write a formular for example: =b1*20+b5 enter and continue to the end of column of 30 000 it does not accept. Can you show how to sort it? Thanks in advance..
Hey Jon, thank you for this trick .. Now im curious if its possible to work on 2 columns, i.e. blank cells of column 1 will be filled with its corresponding data from column 2 . .
Cool example> I have question regarding to this. For instance Cell B2" 25354Aimbo" Cell B3 is address of this company "Street 125" and it is repetitive for all companies. One common thing is that in each Company name is number at beginning. ..... I prefer delete this address and received the result as you have ? Please may you help me with this case ?
thank you for the video. I have a question for Printer object and Printers object. is any Reference library required to install in the Tool->Reference before we can use Pinter and Printers object? I run below code, and get error "object is required" for line "For Each prt In Printers". Sub ListPrinters() Dim prt As Printer For Each prt In Printers Debug.Print Prt.deviceName Next prt End Sub
Hi Jon. Great video. Just wonder what if one of the company name cell is blank, ( as the first method )it would be keep filling up other company's name above. I have to find other columns where has same patterns and use if function to fill down the blank cells. Any formula could help?
Regarding the first wya: I have a list with more than 30000 rows that I need to do this on. When I have come all the way to Select blanks the response from Excel is (found no blanks) even though I see them on my screen - they are there. What can be wrong? I even selected the whole column and pasted it as values in a totally blank sheet. Still Excel does not find the blanks between. Help me out here. The trick only works when I write the "headerwords" randomly myself.
Is there a way to un-fill-down cells? I have now a column that has an entry all the way down to forever. I don't want to delete the entries above a certain row, but would like to delete what appears to be an auto-fill entry all the way down from that row. Thanks.
Hi Eric! 😊 Select the first cell that you want to delete (single click, not double). Hold down both the Shift key and the Ctrl key. Then press the down arrow once. Let go of all three keys. If all of the entries you want to delete are selected, press the delete key; if not, repeat the Shift+Ctrl+Down Arrow step as many times as needed until you reach the exact end of your deletion, then press delete. If you went too far, you can hold Shift and press the Up arrow to go up one cell, or Shift+Ctrl+Up Arrow to go up an entire section. Hope this helps! 🙂
Hi Jon, Could you please help me to find out blank's cells in excel, as my data contain product with picture, and we want to find out product without pictures. = ISBLANK will show all cells are empty as formula read image cells also empty.
Nice question, Shamoon! Try the COUNTBLANK function to yield the number of blank cells per range. I placed a stock image in a cell (Insert > Pictures > Place in Cell > Stock Images...), and COUNTBLANK did not count that cell as empty. For counting non-blank cells, use COUNTA.
I didn't originally think this would be useful, but it turns out that these methods can be very helpful. Right now I need to add the number for the car to each row in a 155 page pdf. That would take long without these features!
Jon Thankyou!! I was struggling since data was 3L + rows. Appreciate it!!
Thanks for covering the different examples
I like the first method more. I was able to fill horizontally. Thanks, great video
Thanks John. I came across this video randomly and wish I had known this before.Formula trick is just amazing and very easy
This video saved me a lot of time. Thank you!
Excelent!!! I like it because you explain very clearly
Thank you so much for these videos
Dear,
this is quick and nice, thx for video.
I'm using also small other technique, if you have data like video- open the filter list, click only "empty" boxes then type into [cell B3] =B2 , copy this cell and paste down :)
Enjoy!
All the best for you!
MK313
thanks you, you made my day 👍👍
Thank u for this, sir. Very helpful.
Cool Tutorial 3 Great Solutions...Thank You Jon :)
Thank you Darryl! 🙌
Thanks jon, love your voice.
Excellent tutorial. Thank you so much
Thanks, this helped me alot!
Very easy! Thanks!
You're welcome @clorettalewis1711! 😀
Thanks, Time Saver.
Glad it helped, @tunastarmedia2699 😀
Awesome. You excell in explaining
Many thanks ☑️
The first technique is very useful, I had no idea we could do that.
If I would have known this trick 10 yrs ago, I would be 3 years younger!!
Nice trick formula,, thank you
Great, Thank You.
Great content, easy to follow
Great tips Jon!!! thank you
Life saver! GREAT content and super simple! 😄
Thanks, Diana! :)
Thank You.
Hi Jon. Awesome! Great solutions. Thanks for the tips :)) Thumbs up!!
Great stuff. Thanks Jon for sharing the techniques!
Thanks Emmanuel! 🙂
Nice... very helpful,, clear and practical!!! Thank you!
Love this one Jon 👍🏻
Thank you so much!!!!
You're welcome! 😀
Great solution, thanks a lot
Thanks Omar! 🙂
Awesome!!!
Thanks Abdulhafiz! 🙂
Super helpful Thanks so much!
Thanks
Excellent tips👍. Thanks
Glad it was helpful! 😀
Good job
Waaaaw, this is cool.
Thanks 🤩
It's really nice
Great!
Great.
Love it :)
Thanks for this cool filling down techniques :-)
I like macro technique thanks for this macro solution.
Could i have your personal workbook containing macros existing in your macro rubban thanks :-)
chatgpt suggested me this video
Will you be able to show how to improve data visualization through excel?
That is awesome tutorial.
I need your help, I need to fill blank spaces as $0.00 how can i do so by using macros?
Hi, I am one of your subscriber and your video presentation very helpful and informative for line if work, by they way i just having a little hard to create a drop down list text with percentage value and equal to average,if you can help me,really appreciate.😊
IF you write a formular for example: =b1*20+b5 enter and continue to the end of column of 30 000 it does not accept. Can you show how to sort it? Thanks in advance..
Hey Jon, thank you for this trick ..
Now im curious if its possible to work on 2 columns, i.e. blank cells of column 1 will be filled with its corresponding data from column 2 . .
Cool example> I have question regarding to this. For instance Cell B2" 25354Aimbo" Cell B3 is address of this company "Street 125" and it is repetitive for all companies. One common thing is that in each Company name is number at beginning. ..... I prefer delete this address and received the result as you have ? Please may you help me with this case ?
thank you for the video. I have a question for Printer object and Printers object. is any Reference library required to install in the Tool->Reference before we can use Pinter and Printers object? I run below code, and get error "object is required" for line "For Each prt In Printers".
Sub ListPrinters()
Dim prt As Printer
For Each prt In Printers
Debug.Print Prt.deviceName
Next prt
End Sub
Hello, how to fill the same value from below to above cell?
Hi Jon. Great video.
Just wonder what if one of the company name cell is blank, ( as the first method )it would be keep filling up other company's name above. I have to find other columns where has same patterns and use if function to fill down the blank cells. Any formula could help?
Regarding the first wya: I have a list with more than 30000 rows that I need to do this on. When I have come all the way to Select blanks the response from Excel is (found no blanks) even though I see them on my screen - they are there. What can be wrong? I even selected the whole column and pasted it as values in a totally blank sheet. Still Excel does not find the blanks between. Help me out here. The trick only works when I write the "headerwords" randomly myself.
Is there a way to un-fill-down cells? I have now a column that has an entry all the way down to forever. I don't want to delete the entries above a certain row, but would like to delete what appears to be an auto-fill entry all the way down from that row. Thanks.
Hi Eric! 😊 Select the first cell that you want to delete (single click, not double). Hold down both the Shift key and the Ctrl key. Then press the down arrow once. Let go of all three keys. If all of the entries you want to delete are selected, press the delete key; if not, repeat the Shift+Ctrl+Down Arrow step as many times as needed until you reach the exact end of your deletion, then press delete. If you went too far, you can hold Shift and press the Up arrow to go up one cell, or Shift+Ctrl+Up Arrow to go up an entire section. Hope this helps! 🙂
Thank you Jon. I would like to know, how do I create My Macros Ribbon? :D
I need to fill down while having one part of the formula remain constant. Example: C1*D1 and C2*D1 and C3*D1
Is there a way to convert the formula within a cell to the actual value of the formula result.
I literally asked this question just as you explain how to do it damn it thank you
Hi Jon,
Could you please help me to find out blank's cells in excel, as my data contain product with picture, and we want to find out product without pictures. = ISBLANK will show all cells are empty as formula read image cells also empty.
Nice question, Shamoon! Try the COUNTBLANK function to yield the number of blank cells per range. I placed a stock image in a cell (Insert > Pictures > Place in Cell > Stock Images...), and COUNTBLANK did not count that cell as empty. For counting non-blank cells, use COUNTA.
formi=uar was like =b$1*10+b5 al the way to the last row of 30k rows
So I have a question. so far no one could assist me with my file data. Hope you can assist. Please Advise.
😳
Thanks alot
you are the best teacher
Wow, thanks! 😀