Тёмный

How To Apply A Button To Clear Specific Cells In Excel 

Excel 10 tutorial
Подписаться 75 тыс.
Просмотров 166 тыс.
50% 1

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

 

22 окт 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 235   
@veenavilkus8648
@veenavilkus8648 5 лет назад
Thank you. You provide easy to understand instructions, and I appreciate it. I've not asked anyone online yet, but I have a question- If possible, how does one create a button to copy a range of cells if certain conditions are met? Example- If d6 is empty, copy a11:a17 If d6 contains text, copy b11:17 If d4 contains text but d6 doesn't, copy a11:a17 and c11:c12 If d4 and d6 contains text, copy b11:b17 and c11:c12
@Excel10tutorial
@Excel10tutorial 5 лет назад
Thanks for your comment. I'm gonna have to take a look at your problem and it will take time. I'm having issues with my PC so can't work right now. I will get a new pc soon and after that i'll try to solve your problem. Please subscribe and be in touch.
@leighfoster1697
@leighfoster1697 6 лет назад
Your tutorials are so good! I had been struggling to follow other online tutorials but yours are so easy to follow. Thank you very much for doing what you are doing and sharing your knowledge.
@Excel10tutorial
@Excel10tutorial 6 лет назад
Thanks for your appreciation. This is all i need to keep going. Please subscribe and share these resources with your friends. This will help me a lot. Thanks again for excellent comment.
@CCAFO
@CCAFO Год назад
Thank you so much! I want to learn how to enable another cell in the same sheet or another sheet (in the same Workbook) appear the same data of the data that we enter in first cell. Thank you!
@Excel10tutorial
@Excel10tutorial Год назад
Is this you are looking for? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JMqHwMQF-SY.html
@holgerrode7014
@holgerrode7014 5 лет назад
Great video. What if you only want to clear the content of cells within the range without changing the format of the cells?
@Excel10tutorial
@Excel10tutorial 5 лет назад
First subscribe to the channel and then Change Clear to ClearContents in the vba
@chriscaldwell3517
@chriscaldwell3517 5 лет назад
Use ClearContents method. Example: Range("A1", "A10").ClearContents
@dawnmeeker1411
@dawnmeeker1411 5 лет назад
Is there any way to get it to clear the cells without clearing formatting (ie. lines, shading, etc.)?
@Excel10tutorial
@Excel10tutorial 5 лет назад
Change Clear to ClearContents in the vba
@smcs18
@smcs18 3 года назад
Great video. Is there codes possible to copy the whole sheet to another tab with the current date as the name for the copied tab and clear contents from the present sheet from the particular cells
@Excel10tutorial
@Excel10tutorial 3 года назад
Check this tutorial: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GAgoy_Of8nc.html
@mohammedameerahmed2250
@mohammedameerahmed2250 4 года назад
Thank you so much for this. Now my work has become more faster to clear the data. Thanks a bunch
@Excel10tutorial
@Excel10tutorial 4 года назад
I'm glad you like it.
@mohammedameerahmed2250
@mohammedameerahmed2250 4 года назад
@@Excel10tutorial Thank you
@Excel10tutorial
@Excel10tutorial 4 года назад
You're welcome
@EpicSoccerPlayerPro
@EpicSoccerPlayerPro Год назад
Great tutorial! One question I have is if there is any way to delete an entire row based on your selection and keep the same formatting?
@Excel10tutorial
@Excel10tutorial Год назад
Try This: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Q0rlo-mzZu0.html
@arashvarzandeh4860
@arashvarzandeh4860 3 года назад
Hello, this is a very good tutorial and thank you. I have 1 question, say i have a range of excel i wanted to clear but certain cells have to skip, is there a formula that i can use rather than writing range one at a time? For instance Range(“C1”, “C7”).clear but i need to skip c8 and c9 then include C10-C12. Is it possible to do it in 1 range? Thank you
@Excel10tutorial
@Excel10tutorial 3 года назад
Why you need to do it in one range? use the code in this tutorial and you can clear multiple cells those are not adjacent.
@darranelliott3991
@darranelliott3991 2 года назад
Thanks you this is great but can I make it clear single and merged cells in the same range?
@Excel10tutorial
@Excel10tutorial 2 года назад
Use this for merged Cell: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Te5S5B0lZMk.html And use you can add both in a single button
@ΓιώργοςΔαδακίδης
@ΓιώργοςΔαδακίδης 3 года назад
Is there a chance that i could clear only the number of the cells without losing the commands like vlookup/ifblank etc and the cell color
@ML-cy5fi
@ML-cy5fi 5 лет назад
Thank you for this great video. I've been struggling to figure out how to do the last part. The internet isn't helpful. 👍🏻
@Excel10tutorial
@Excel10tutorial 5 лет назад
Glad it helped. Let me know if you have any question. And please subscribe and support the channel.
@supboi9875
@supboi9875 4 года назад
thanx alot , it seems the clear code erases the cell lines aswell is there a code that erase the content of the cell only?
@Excel10tutorial
@Excel10tutorial 4 года назад
Remove Clear to ClearContent in the code and that will keep the formatting and only delete the value. Hope you got your solution. Please subscribe and share this video with your friends.
@salvadorvallejo8351
@salvadorvallejo8351 7 месяцев назад
Very helpful. Thanks
@Excel10tutorial
@Excel10tutorial 7 месяцев назад
You're most welcome. Please subscribe and share
@prathipraj444
@prathipraj444 4 года назад
Bro thanks for your video. Clearly understood. Do have the code for save files in excel format to pdf ?
@Excel10tutorial
@Excel10tutorial 4 года назад
That is possible.
@prathipraj444
@prathipraj444 4 года назад
Where u do find the codes for this bro
@Excel10tutorial
@Excel10tutorial 4 года назад
Contact me through email with details of what you need.
@dominiquejackson7027
@dominiquejackson7027 4 года назад
Hi! Love this tutorial! It was very easy to follow but I have another issue. I have the cells I want to clear color coded. So when I click CLEAR button, it also delete the box color and border. How can I keep my color and border and also use the clear button function?? Thanks!!
@Excel10tutorial
@Excel10tutorial 4 года назад
Yes you can do that. If you need to keep the formatting you'll have to write ClearContents in the code replacing Clear.
@chris-zu6sf
@chris-zu6sf 4 года назад
Thanks, for the timesaving tip! How do I blank out the rows under 'Total' and 'Avg' columns after I have pressed the Clear button?
@Excel10tutorial
@Excel10tutorial 4 года назад
Add that data range inside the code also.
@chris-zu6sf
@chris-zu6sf 4 года назад
@@Excel10tutorial Thank you, that worked! Do you know how I can further modify this formula to alphabetize and omit duplicate values?
@Excel10tutorial
@Excel10tutorial 4 года назад
@@chris-zu6sf That is a different topic. you can use sorting and also remove duplicate from the data tab.
@ymijohson
@ymijohson 2 года назад
Thank You So Much! How do we clear specific cells (not range)? What is the code for it?
@Excel10tutorial
@Excel10tutorial 2 года назад
Just write the cell number in the code.
@km-qo4up
@km-qo4up Год назад
@@Excel10tutorial how?? Example
@willmason5774
@willmason5774 2 года назад
Great video. How do you delete cells on a different tab /sheet?
@Excel10tutorial
@Excel10tutorial 2 года назад
Here is how: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-djEddntao9Q.html
@najamaabbas
@najamaabbas 2 года назад
Thank you for the video, However, i want to clear value of cell D6 only which is a merged cell of D and E column. I am getting error "We can't do that on merged cell". Any suggestion to fix that?
@Excel10tutorial
@Excel10tutorial 2 года назад
Yes, correct. For merged cell check this tutorial: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Te5S5B0lZMk.html
@najamaabbas
@najamaabbas 2 года назад
@@Excel10tutorial Thanks! Is it possible to clear both together with one button? I am trying to clear the following: D6 H6 H7 H8 D8 (Merged with column E & F) B13 C18 C19 C20 C21 C22 C23 C24 C25 C26
@beatweezl
@beatweezl 6 лет назад
This is perfect. I am trying to do EXACTLY this but in Google sheets.
@beatweezl
@beatweezl 6 лет назад
Ok, so I went back and tried it again. I created a macro as you did and by trial and error, I figured out how to apply the macro to the button. I would have NEVER considered messing with macros to apply to a button if not for you. Of all the tutorials I have seen, no one have ever so much as used the word "macro". All credit goes to this video. Thank you so much for knowing how to impart your knowledge!
@Excel10tutorial
@Excel10tutorial 6 лет назад
Good to know.
@frankie3005
@frankie3005 5 лет назад
You did not need to name all those ranges. You could simply write Range("b2:f7"). Clear that is all
@Excel10tutorial
@Excel10tutorial 5 лет назад
Awesome tricks you just shared with the @excel10tutorial community. Thanks for that. It will really save time. Thanks a lot. Yet the way i demonstrated here will be helpful if we need to delete ranges that are separate from one another. Well at least that what i thought. Really appreciate your support. Thanks
@hariantoefendi929
@hariantoefendi929 2 месяца назад
Wow the simple.... 🙏
@Excel10tutorial
@Excel10tutorial 2 месяца назад
Thanks for liking
@miam8903
@miam8903 5 лет назад
Very helpful video. In my spreadsheet on some occasions I have ranges of cells, but also a single cell that I need to clear. How to I program the single cell? It is not a Range...
@miam8903
@miam8903 5 лет назад
Also, Merged Cells. How do I clear a range that consists of merged cells?
@Excel10tutorial
@Excel10tutorial 5 лет назад
@@miam8903 Just write the cell name
@francisgatchula2829
@francisgatchula2829 2 года назад
Thank you sir. It is easy to follow and I done it. but when I try to open again the file Clear Button doesn't work and have an error (Cannot run the macro. "filename'!Clearcells'. The macro may not be available in this workbook or all macros may be disable) then I check the Modules that I created but it is gone even I save it before closing the file.
@Excel10tutorial
@Excel10tutorial 2 года назад
Save the file in .xlsm format
@francisgatchula2829
@francisgatchula2829 2 года назад
@@Excel10tutorial thanks a lot sir.
@hk4848
@hk4848 3 года назад
It’s been very good. But I have a doubt is there a way by which you can hide the formlua that is seen even when you clear screen.
@Excel10tutorial
@Excel10tutorial 3 года назад
Please explain your requirement. If you need to hide formula you can check this tutorial: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pN9yA6gvWzw.html
@mydqlondon6308
@mydqlondon6308 4 года назад
Great video,how we can email the worksheet we working from assigned button in same sheet
@Excel10tutorial
@Excel10tutorial 4 года назад
How do you usually sent?
@suryadeepbiswas6928
@suryadeepbiswas6928 2 года назад
thank you ❤️ ..have applied your code and it's working :)
@Excel10tutorial
@Excel10tutorial 2 года назад
Thanks for your comment. Please subscribe and be with us
@kb6429
@kb6429 5 лет назад
Hi how you doing. Great video. I need a piece of VBA code that clear automatically a particular row when the date set in that row/column has pass
@Excel10tutorial
@Excel10tutorial 5 лет назад
i'll look into it and let you know. subscribe to be in touch
@Andiicodes
@Andiicodes 4 года назад
hello, is there anyway to: add a specific text to a cell when the button is clicked? I really have to do this in my project and I don't know anything of vba , thanks a lot great vid
@Excel10tutorial
@Excel10tutorial 4 года назад
Yes that can be done. Create a command button and write this code Private Sub CommandButton1_Click() Range("A1").Value = "the value" End Sub A1 is the cell where you need the value
@N8riz
@N8riz 5 лет назад
Nice demonstration. How do you reference from other sheet. example: Make clear button on sheet 1 for sheet 2.
@Excel10tutorial
@Excel10tutorial 5 лет назад
Will let you know shortly. Please subscribe.
@Excel10tutorial
@Excel10tutorial 5 лет назад
Button in sheet 1 and the content will delete on sheet 2. Here goes the tutorial: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-djEddntao9Q.html
@jockwalkercampbell
@jockwalkercampbell 4 года назад
Thank you - Great teacher!
@Excel10tutorial
@Excel10tutorial 4 года назад
Thanks a million for your appreciation.
@reservefolder8767
@reservefolder8767 3 месяца назад
How can I make it so that it gets automatically clear at midnight for fresh data to be inputted next day?
@akshayjagdale4271
@akshayjagdale4271 5 лет назад
Nice trick but i faced one issue..once sheet is closed then macro will be disabled. How to fix it..plz reply fast..
@Excel10tutorial
@Excel10tutorial 5 лет назад
save the file in ,xlsm format and subscribe the channel 😜
@moodkn
@moodkn Год назад
Great... Thanks..!
@Excel10tutorial
@Excel10tutorial Год назад
You're most welcome.
@Ling-O_o
@Ling-O_o Год назад
hello sir, .clear vb is remove all my data validation but i don't want that. i only want to remove only text so is there other code can do it?
@Excel10tutorial
@Excel10tutorial Год назад
Check this one: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Q0rlo-mzZu0.html
@paulwattsonseril8914
@paulwattsonseril8914 3 года назад
I made the clear button but h I am the only one who can perform the clear button. Can i assign other users to perform the clear function? Thank you
@Excel10tutorial
@Excel10tutorial 3 года назад
It will work on that workbook only.
@MissMarksClass
@MissMarksClass 3 года назад
What happens when we use the CLEAR ALL option. How to reverse this operation after using Clear All. can it be undone?
@Excel10tutorial
@Excel10tutorial 3 года назад
No it can't be undone. When you use vba there is no ctrl + z
@mattynice7814
@mattynice7814 3 года назад
Thank you. This is great!
@Excel10tutorial
@Excel10tutorial 3 года назад
Glad it was helpful!
@joshuagrimploma9171
@joshuagrimploma9171 Год назад
thank you
@Excel10tutorial
@Excel10tutorial Год назад
You're welcome. Please subscribe and be with us.
@SeriesTube01
@SeriesTube01 4 года назад
Thank you very much.
@Excel10tutorial
@Excel10tutorial 4 года назад
You are welcome!
@rajivsd69
@rajivsd69 2 года назад
Excellent
@Excel10tutorial
@Excel10tutorial 2 года назад
Thank you so much 😀
@carlitoxaviermathews9181
@carlitoxaviermathews9181 3 года назад
Hi, how do you save the coding, every time I open the file the coding is missing?
@Excel10tutorial
@Excel10tutorial 3 года назад
Save the workbook in .XLSM format which is Excel Macro Enabled Workbook.
@mariuspetrucristea1686
@mariuspetrucristea1686 3 года назад
Hi, great video. How can i put a message "are you sure? yes or no" ?
@mariuspetrucristea1686
@mariuspetrucristea1686 3 года назад
Function ValidEntry_d() As Boolean End Function Sub Clearcells() Dim d As VbMsgBoxResult d = MsgBox("Are you sure?", vbYesNo + vbQuestion, "Clear cells") If d = vbNo Then Exit Sub If ValidEntry_d = True Then End If Range("A5", "A10000").ClearContents Range("B5", "B10000").ClearContents End Sub
@basantbasan5520
@basantbasan5520 5 лет назад
Thanks a lot. But can it is excel 2007 also? Plz reply
@Excel10tutorial
@Excel10tutorial 5 лет назад
You have to try it. Can't confirm if it will work on 2007. Make sure to tell us if it works on 2007
@kameshbabu3116
@kameshbabu3116 5 лет назад
Thank you for this wonderful session. But there is a problem, it clears all the things like data, formatting: border, colour etc.. I want to clear only data, not formatting like border, colour......Kindly do reply.
@Excel10tutorial
@Excel10tutorial 5 лет назад
Change Clear to ClearContents in the vba
@kameshbabu3116
@kameshbabu3116 5 лет назад
@@Excel10tutorial Thank you so much for your reply.
@Excel10tutorial
@Excel10tutorial 5 лет назад
You're welcome.
@horgavaanitribalsongsandme3785
@horgavaanitribalsongsandme3785 2 года назад
Very good.
@Excel10tutorial
@Excel10tutorial 2 года назад
Many many thanks
@jsmasaya9275
@jsmasaya9275 5 лет назад
What if the cell is in another sheet and the button is in another sheet? Thanks. Your video was very helpful!
@Excel10tutorial
@Excel10tutorial 5 лет назад
Here you go. this code will clear cell c1 to c5 of sheet 2 and the button will be in sheet 1. Subscribe and enjoy Sub Clearcells() Worksheets("Sheet2").Activate Range("C1","C5" ).Clear End Sub
@jsmasaya9275
@jsmasaya9275 5 лет назад
@@Excel10tutorial Thank very much! I have experiment your code and it seems that if I had multiple sheet and they had the same content in cells, all contents in the sheets will also be cleared. But I would try this code of yours now! Thanks.
@Excel10tutorial
@Excel10tutorial 5 лет назад
@@jsmasaya9275 Try it and let me know if it works. Thanks for being with us
@Excel10tutorial
@Excel10tutorial 5 лет назад
Here goes the video tutorial: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-djEddntao9Q.html
@monicamoga6295
@monicamoga6295 4 года назад
Thank you ! Great tip, very useful !!!
@Excel10tutorial
@Excel10tutorial 4 года назад
You're welcome
@bryanchapman4779
@bryanchapman4779 4 года назад
Yikes. This worked. I created a button to clear the cells and it worked great. The only problem is that the .clear function also wiped out all my formatting, color fills, data validation and conditional formatting. :(
@Excel10tutorial
@Excel10tutorial 4 года назад
If you need to keep the formatting you'll have to write ClearContents in the code replacing Clear.
@Excel10tutorial
@Excel10tutorial 7 лет назад
Please subscribe If you can please Support Us: www.patreon.com/excel10tutorial Signup here to get the code: forms.gle/H27wWWztmm6ezQZv6
@bestrizvi
@bestrizvi 6 лет назад
Excel 10 tutorial
@Baaronlee
@Baaronlee 5 лет назад
Where is the Code?
@aceadams74
@aceadams74 5 лет назад
Where's the code???
@ketulpandav5406
@ketulpandav5406 Год назад
One problem occurs during used this steps, but i want to keep formula so how can i solve problems?
@Excel10tutorial
@Excel10tutorial Год назад
Try this: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-jsi4Ip_vHnI.html
@sanjibjana4434
@sanjibjana4434 Год назад
I want to clear not only continuous cells also different cells like B12 or D6 or g11 etc. How is possible? Plz help
@Excel10tutorial
@Excel10tutorial Год назад
Change This line Range("", "").Clear to Range("A1", "A5").Clear to clear from cell a1 to a5. and change it to Range("B5").Clear to only clear cell B5
@SuryoyoEntertainment
@SuryoyoEntertainment Год назад
if I want to do this to multiplie sheets?
@Excel10tutorial
@Excel10tutorial Год назад
You can do that. Change the macro name for each sheet.
@hammoudehhasan2436
@hammoudehhasan2436 2 года назад
How can I delete specific cells in all sheets once a time using a button in one sheet
@Excel10tutorial
@Excel10tutorial 2 года назад
Add those cell references in the code.
@hazy83
@hazy83 Год назад
If i want to redo this action or by mistake clik it then?
@Excel10tutorial
@Excel10tutorial Год назад
You can't. Because Its created with VBA
@hernanlazo98
@hernanlazo98 5 лет назад
GREAT VIDEO THANKS
@Excel10tutorial
@Excel10tutorial 5 лет назад
You are welcome. Thanks a lot for your comment. Please subscribe and share with your friends. 😍😍😍
@LordRigon
@LordRigon 4 года назад
The title said "...to clear specific cells..." you did a range of cells. I was thinking more along the lines of deleting something like B3 and D8, specifically.
@Excel10tutorial
@Excel10tutorial 4 года назад
That is possible. You'll have to write that cell reference.
@riccardosimo94
@riccardosimo94 2 года назад
How can i clear only the content of a cell and not everything (like formulas etc)?
@Excel10tutorial
@Excel10tutorial Год назад
Try this: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-jsi4Ip_vHnI.html
@ivoryphiphi
@ivoryphiphi 3 года назад
How to make a button to clear cell data in another file or multiple file not the same file ( Working on Excel or GooGle Sheet ) ?
@Excel10tutorial
@Excel10tutorial Год назад
Try this: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-jsi4Ip_vHnI.html but it won't work on google sheet
@hyderabbas3794
@hyderabbas3794 4 года назад
But when sheet is locked and when we use this button.. the unlocked cells are being locked automatically..could you please suggest what could be done ??
@Excel10tutorial
@Excel10tutorial 4 года назад
Send me your file and explain your problem in detail over email. I'll see what i can do.
@hyderabbas3794
@hyderabbas3794 4 года назад
@@Excel10tutorial please provide your email ID
@Excel10tutorial
@Excel10tutorial 4 года назад
@@hyderabbas3794 You'll find it in the channel about section
@רועיפרץ-ש7פ
@רועיפרץ-ש7פ 2 года назад
What is the command to delete cell contents without deleting formatting?
@Excel10tutorial
@Excel10tutorial 2 года назад
Here is it, This will clear cell but keep he cell formatting: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Q0rlo-mzZu0.html
@rudidpribadi6211
@rudidpribadi6211 5 лет назад
Thanks, I am from indonesiap
@Excel10tutorial
@Excel10tutorial 5 лет назад
You're welcome. Please subscribe and share the video.
@sushilsahajpal9276
@sushilsahajpal9276 2 года назад
How to delete specific cell (randomly) in column?pls describe
@Excel10tutorial
@Excel10tutorial Год назад
Change This line Range("", "").Clear to Range("B5").Clear to only clear cell B5
@Excel10tutorial
@Excel10tutorial 5 лет назад
On Request: How To Apply A Button To Clear Specific Cells On Another Worksheet In Excel: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-djEddntao9Q.html How to create a button to clear multiple merged cells in excel: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Te5S5B0lZMk.html
@TibiaLevelUp
@TibiaLevelUp 4 года назад
What if I want to turn back the cell to a previous value instead of clearing it?
@Excel10tutorial
@Excel10tutorial 4 года назад
If that value is fixed you can do that. if you just need to use undo then use CTRL+ Z instead
@stefanpoulin1277
@stefanpoulin1277 2 года назад
Good Tutorial, however you might want to add the fact that you will want to save this as an .XLSM File and not an XLSX. failure to do so will clear out all your macros that you've worked so hard on.
@Excel10tutorial
@Excel10tutorial 2 года назад
Yep. You are absolutely Right.
@HenrikWigum
@HenrikWigum 6 лет назад
Nice tutorial. But it's a bad function for my use. Cannot be undone with "ctrl+z", and it also deletes borders.
@Excel10tutorial
@Excel10tutorial 6 лет назад
Guess you'll need to use something else. Sorry if it didn't serve your purpose. But please subscribe and share with your friends. It might help them.
@lokihere8542
@lokihere8542 6 лет назад
Yeah.. Same happened in my case. It cleared even Filled color, font size everything ll come to default
@atsbfatal9607
@atsbfatal9607 6 лет назад
@@lokihere8542 change clear to "ClearContents" in the macro
@hernanlazo98
@hernanlazo98 5 лет назад
@@atsbfatal9607 THANK YOU
@ZubairChoudhary
@ZubairChoudhary 4 года назад
great
@Excel10tutorial
@Excel10tutorial 4 года назад
Thanks
@kumaranup9
@kumaranup9 4 года назад
HI..I WANT TO INSERT VAULE 0 AFTER CLEARING THE CELLS.CAN U PLZ SHARE THE CODE
@Excel10tutorial
@Excel10tutorial 4 года назад
Change Range("", "").Clear to Range("", "").Value = 0 in the code.
@juzwantukkomen5595
@juzwantukkomen5595 3 года назад
Nice... and I bet you are one of the few who thinks Chinese is an easy language to learn in school since you spelt it with an ease. :D
@Excel10tutorial
@Excel10tutorial 3 года назад
Ha ha ha😃😄😂
@mixtainment5755
@mixtainment5755 3 года назад
It deleted the cell background colour and border, How could I do it so it would only delete the text?
@Excel10tutorial
@Excel10tutorial 3 года назад
Here is it: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Q0rlo-mzZu0.html
@mixtainment5755
@mixtainment5755 3 года назад
Thanks, How could I save the module? every time I open the excel file the module isn't there.
@Excel10tutorial
@Excel10tutorial 3 года назад
Save the file in .xlsm format
@rishabhagarwal1048
@rishabhagarwal1048 4 года назад
Sir, how to clear the contents in the merged cells?
@Excel10tutorial
@Excel10tutorial 4 года назад
Here goes your solution: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Te5S5B0lZMk.html
@andrewmatthews1369
@andrewmatthews1369 4 года назад
' I have protected my sheet but have the cells I have unlocked become locked when i clear the contents ready to use again. I don't want to keep going through my sheet to unlock all the cells again. The sheet needs to be locked to stop accidental alterations
@Excel10tutorial
@Excel10tutorial 4 года назад
Check this: How To Protect All But Certain Cells In Excel Worksheet: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-7_3WUZNFtxc.html
@andrewmatthews1369
@andrewmatthews1369 4 года назад
@@Excel10tutorial I can do that but that is not my question. I have done that but when I add a button to clear contents it clears the unlocked cell and it becomes locked again. I want to stop this from happening
@Excel10tutorial
@Excel10tutorial 4 года назад
Can you send me a copy? i'll take a look.
@andrewmatthews1369
@andrewmatthews1369 4 года назад
@@Excel10tutorial yes but how
@Excel10tutorial
@Excel10tutorial 4 года назад
salman.y2k7@gmail.com
@mhnzc
@mhnzc 4 года назад
Hi how come my macro doesn't stay saved? it works but then when I close out of excel and reopen it it says it doesn't find the macro
@Excel10tutorial
@Excel10tutorial 4 года назад
Save the file with .xlsm format. It will solve your problem.
@adeniyiadeyemi2367
@adeniyiadeyemi2367 2 года назад
Can't find the code here
@Excel10tutorial
@Excel10tutorial 2 года назад
link in the description.
@tonycheung596
@tonycheung596 2 года назад
it cant delete merge cell. please let me know how thank you
@Excel10tutorial
@Excel10tutorial 2 года назад
Check these: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Te5S5B0lZMk.html
@aeronjohngarcia3600
@aeronjohngarcia3600 3 года назад
Can you delete a specific button using clear button?
@aeronjohngarcia3600
@aeronjohngarcia3600 3 года назад
Help
@Excel10tutorial
@Excel10tutorial 3 года назад
what type of button do you have?
@aeronjohngarcia3600
@aeronjohngarcia3600 3 года назад
@@Excel10tutorial Shape
@aeronjohngarcia3600
@aeronjohngarcia3600 3 года назад
@@Excel10tutorial Shape sir
@rcri99
@rcri99 5 лет назад
Where is the formula to copy/paste? I can’t find it.
@Excel10tutorial
@Excel10tutorial 5 лет назад
@awesome12699 Sub Clearcells() 'Excel 10 Tutorial Range("", "").Clear Range("", "").Clear Range("", "").Clear Range("", "").Clear End Sub
@naveenkumarbp268
@naveenkumarbp268 5 лет назад
@@Excel10tutorial send it
@Excel10tutorial
@Excel10tutorial 5 лет назад
@@naveenkumarbp268 Sub Clearcells() 'Excel 10 Tutorial Range("", "").Clear Range("", "").Clear Range("", "").Clear Range("", "").Clear End Sub
@mohdsubhan9887
@mohdsubhan9887 2 года назад
How to create undo / redo button in excel by using macro
@Excel10tutorial
@Excel10tutorial 2 года назад
Can't undo if you use a vba.
@im_anshad5959
@im_anshad5959 3 года назад
How to retrieve the same using macro
@Excel10tutorial
@Excel10tutorial 3 года назад
Once you delete something using a macro, there is no turning back.
@ruhulkhan596
@ruhulkhan596 4 месяца назад
I want get to get code
@Excel10tutorial
@Excel10tutorial 4 месяца назад
Check the link in the video description.
@JosephDaniels
@JosephDaniels 2 года назад
It's not working for me. It says I have a syntax error
@Excel10tutorial
@Excel10tutorial 2 года назад
Check the code again. Make sure nothing is missing.
@lengkanel4822
@lengkanel4822 8 месяцев назад
Help me button clear checkbox to uncheck box
@palkeshkushwah9704
@palkeshkushwah9704 3 года назад
How can we clear only values not formula
@Excel10tutorial
@Excel10tutorial 3 года назад
Change Range("", "").Clear to Range("","" ).SpecialCells(xlCellTypeConstants).ClearContents
@doomsday8987
@doomsday8987 3 года назад
how can we do this in mobile app
@Excel10tutorial
@Excel10tutorial 3 года назад
This only works on desktop. sorry.
@km-qo4up
@km-qo4up Год назад
How to clear particular any cell without cell format change?
@Excel10tutorial
@Excel10tutorial Год назад
here is how to clear cell keeping the format: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Q0rlo-mzZu0.html
@km-qo4up
@km-qo4up Год назад
@@Excel10tutorial if i not range want.. only cell.. then what is the coding
@Excel10tutorial
@Excel10tutorial Год назад
Change Range("B9:F20").ClearContents to Range("B9").ClearContents Now it will only clear contents from cell B9
@ShijuPrabhakar
@ShijuPrabhakar Год назад
I couldnt find the code
@Excel10tutorial
@Excel10tutorial Год назад
Link in the video description.
@9212701800
@9212701800 Год назад
Hi, Kindly share code
@Excel10tutorial
@Excel10tutorial Год назад
Check in the description
@pk_hemmane
@pk_hemmane 3 года назад
instead write 4 lines of codes ...........write in 1 line ie b2:e7
@Excel10tutorial
@Excel10tutorial 3 года назад
Great
@THAKURSAHABop
@THAKURSAHABop Год назад
Copy code?
@Excel10tutorial
@Excel10tutorial Год назад
Link in the description
@ruhulkhan596
@ruhulkhan596 Год назад
Please give me clearly cod
@Excel10tutorial
@Excel10tutorial Год назад
Code link is in the video description
4 года назад
Thanks for the videos I would like to set an expiry date for my excel work book and then an activator incase some one buys it at the end of the expiry. How can I do this using excel? Or is there a way of putting something online to allow me activate the work book remotely without sharing another file with someone? I'll be glad to hear from you Thank you mwebazenicholas6@gmail.com is my email just incase it's needed
@Excel10tutorial
@Excel10tutorial 4 года назад
I've never done something like that. if i find anything like it i'll definitely create a video on it.
@dooyouevenliftbro8078
@dooyouevenliftbro8078 4 года назад
This clears all formatting. Thumbs Down :(
@Excel10tutorial
@Excel10tutorial 4 года назад
If you need to keep the formating you'll have to write ClearContents in the code replacing Clear. Thumbs up buddy. Thanks for the comment.
@dooyouevenliftbro8078
@dooyouevenliftbro8078 4 года назад
Actually my bad you don't even need that code you can just record the macro. Way easier. It writes the code for you.
@Excel10tutorial
@Excel10tutorial 4 года назад
Yes. You can do that with macro recorder. I've covered that topics on my excel vba programming course. You could follow the course.
@Evilkwiet
@Evilkwiet 5 лет назад
Thanks a lot for this video!
@Excel10tutorial
@Excel10tutorial 5 лет назад
You're welcome. Please subscribe and share with friends. And thanks for the comment.
@Niamat.nasiry
@Niamat.nasiry Год назад
i cannot find the code
@Excel10tutorial
@Excel10tutorial Год назад
In the video description.
Далее
Cool Wrap! My Book is OUT 🥳
00:27
Просмотров 930 тыс.
Spreadsheets #1: Introduction
13:27
Просмотров 1 млн
Option Buttons with Formulas in Excel
8:44
Просмотров 92 тыс.
How to Create Macros in Excel Tutorial
9:17
Просмотров 1,6 млн
How to Lock Cells in Excel
3:21
Просмотров 1,2 млн