Video

Thanks. Intersting. I didn´t know that option. You have a very sweet and pleasant voice

Thank You so much it definitely helped me❤❤❤❤❤

thank you so much mam

🔥🔥🔥

Kept the good work

Why not use If function?

What? You can just apply a formula

It didn't even work correctly lol

Excellent thanks a lot❤

⭐ *Promosm*

That is a table not a chart. Generally, we don't say word has cells. Past is not paste.

that is not a table it's a range

If u also happen to have a blank cell it will also delete that. How do you delete a row that is entirely blank only with deleting a cell that may be blank where the rest of the row has data.

iam the first commenter

Great guide!

The last is probably most useful

What a brilliant, easy to understand and implement, tutorial - thanks ever so much.

Hi, Thx 4 this video, pls tell me if the option crtl+Z still will be working using this condition and VBA code?

"📧 Hey everyone! Get ready to revolutionize your email game with this incredible Excel trick! 💼💻 In today's video, we're diving into the magic of sending emails directly from Excel using just a SINGLE FORMULA - no VBA code required! 💡 Whether you're managing communications or streamlining your workflow, this technique will save you time and effort. Let me know your thoughts in the comments below and if you have any other Excel automation topics you'd like me to explore in future videos! Keep streamlining and Excel-ing! 🚀

🖋 Hey everyone! Today, we're delving into an important topic: adding digital signatures in Excel! 💼💻 In this video, we'll explore step-by-step how to enhance the security and authenticity of your Excel documents with digital signatures. 💡 Whether you're handling sensitive data or simply want to ensure document integrity, this Excel feature is a game-changer! Let me know your thoughts in the comments below and if there are any other Excel security features you'd like me to cover in future videos! Stay secure and Excel on! 🚀

🌟 Hey everyone! I'm excited to share these top Excel hacks with you today! 💼💻 In this video, we covered some game-changing techniques: splitting data and formatting tables. 💡 Whether you're organizing large datasets or presenting your information with style, these hacks will definitely come in handy! Let me know your thoughts in the comments below and if you have any other Excel topics you'd like me to cover in future videos! Keep Excel-ing! 🚀

👨‍💼 Hey everyone! Thanks for tuning in to learn how to highlight the active row and column in Excel! 💼💻 It's a simple yet powerful technique that can really enhance your spreadsheet navigation. Let me know in the comments if you found this tutorial helpful or if you have any questions! Happy Excel-ing! 🚀

Hey everyone! Thanks for watching the video on the SUM function in Excel. I hope you found it helpful for your spreadsheet adventures! If you have any questions, need clarification, or have suggestions for future topics, feel free to drop a comment below. Your feedback is invaluable, and I'm here to help you excel in Excel! 👨‍💼💻📊

Welcome to the world of automated numbering in Excel! 🚀 Share your thoughts, questions, or any specific scenarios where you plan to apply this technique. Excited to hear how you're making your Excel game stronger! 🎬✨ #ExcelTips #AutomatedNumbering #ProductivityHacks

Welcome, Excel enthusiasts! 🚀 In this tutorial, we've delved into the incredible world of using the Macro Recorder to automate anything in Excel. 💻✨ If you found this helpful or have any questions, drop a comment below! Excited to hear about the automations you're planning to implement in your spreadsheets. Happy automating! 🎬🔧

Thank you for watching! 🚀 In this tutorial, I've covered the essentials of setting data entry limits to ensure accurate and secure information. If you have any questions or need further clarification on any point, feel free to ask. Happy data managing!

Catch the code I used in the video 👇 [Red]# "Days Overdue";[Blue]# "Days Remaining";[Green] "Today"

Good sir ji

Code: Option Explicit 'Main Function to Convert Number to Words Function NumToWords(ByVal MyNumber) Dim Units As String Dim SubUnits As String Dim TempStr As String Dim DecimalPlace As Integer Dim Count As Integer ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " Million " Place(4) = " Billion " Place(5) = " Trillion " ' Convert MyNumber to string and trim white space MyNumber = Trim(Str(MyNumber)) ' Find position of decimal place 0 if none. DecimalPlace = InStr(MyNumber, ".") ' Convert SubUnits and set MyNumber to Units amount. If DecimalPlace > 0 Then SubUnits = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2)) MyNumber = Trim(Left(MyNumber, DecimalPlace - 1)) End If Count = 1 Do While MyNumber <> "" TempStr = GetHundreds(Right(MyNumber, 3)) If TempStr <> "" Then Units = TempStr & Place(Count) & Units If Len(MyNumber) > 3 Then MyNumber = Left(MyNumber, Len(MyNumber) - 3) Else MyNumber = "" End If Count = Count + 1 Loop NumToWords = Application.Trim(Units & SubUnits) End Function ' Converts a number from 100-999 into text Function GetHundreds(ByVal MyNumber) Dim Result As String If Val(MyNumber) = 0 Then Exit Function MyNumber = Right("000" & MyNumber, 3) ' Convert the hundreds place. If Mid(MyNumber, 1, 1) <> "0" Then Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred " End If ' Convert the tens and ones place. If Mid(MyNumber, 2, 1) <> "0" Then Result = Result & GetTens(Mid(MyNumber, 2)) Else Result = Result & GetDigit(Mid(MyNumber, 3)) End If GetHundreds = Result End Function ' Converts a number from 10 to 99 into text. Function GetTens(TensText) Dim Result As String Result = "" ' Null out the temporary function value. If Val(Left(TensText, 1)) = 1 Then ' If value between 10-19... Select Case Val(TensText) Case 10: Result = "Ten" Case 11: Result = "Eleven" Case 12: Result = "Twelve" Case 13: Result = "Thirteen" Case 14: Result = "Fourteen" Case 15: Result = "Fifteen" Case 16: Result = "Sixteen" Case 17: Result = "Seventeen" Case 18: Result = "Eighteen" Case 19: Result = "Nineteen" Case Else End Select Else ' If value between 20-99... Select Case Val(Left(TensText, 1)) Case 2: Result = "Twenty " Case 3: Result = "Thirty " Case 4: Result = "Forty " Case 5: Result = "Fifty " Case 6: Result = "Sixty " Case 7: Result = "Seventy " Case 8: Result = "Eighty " Case 9: Result = "Ninety " Case Else End Select Result = Result & GetDigit(Right(TensText, 1)) ' Retrieve ones place. End If GetTens = Result End Function ' Converts a number from 1 to 9 into text. Function GetDigit(Digit) Select Case Val(Digit) Case 1: GetDigit = "One" Case 2: GetDigit = "Two" Case 3: GetDigit = "Three" Case 4: GetDigit = "Four" Case 5: GetDigit = "Five" Case 6: GetDigit = "Six" Case 7: GetDigit = "Seven" Case 8: GetDigit = "Eight" Case 9: GetDigit = "Nine" Case Else: GetDigit = "" End Select End Function

I'm sorry but surely flash fill is simpler and quicker

Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)

Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)

Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)

Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)

Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)

Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)

Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)

Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)

Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)

Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)

I wish I could post a table as a comment with many repeated rows of "OH MY GOD, THANK YOU".

Thank you so much 😍

✨✨✨Thank you, 🙏🌺😇✨✨✨

✨✨✨Thank you, 🙏🌺😇✨✨✨

Nice voice

It was possible to complete this video within 3 minutes.

*Promo sm* ❣️

I would be happy to help. How can you perform automatic value completion in Excel of a certain cell with a number?

automatic value completion in an excel of cell with number

Miss You are doing Good but the way of teaching needs to improve as well as fluently