🔥Check out our FREE 300+ hour training course playlist here ➡ th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html ✅ Check out our free video playlist for Excel beginners 👉th-cam.com/play/PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z.html ✅ Excel 2021 Tutorials for Intermediate Users here 👉th-cam.com/play/PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3.html ✅ Microsoft Excel Tips and Tricks 👉th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Seems that the key to this working is the VBA code mentioned at the end, which requires saving as a .xlsm (Excel Macro-Enabled Workbook). When I went to save it normally, it popped up some window talking about disabling auto-save that I didn't really understand. The target.calculate basically triggers a recalculation when a different cell is selected, aka when you click on it. Otherwise it wouldn't highlight a row unless you manually refresh for example.
you can use =OR(ROW()=CELL("row"), COLUMN()=CELL("col")) to create a cross effect on the selected cell by highlighting both the entire row and the entire column.
Thank you so friggn much for this. The single row seemed novel but this really is helping me focus. These long bookkeeping/tax days. Again THANK YOU!! 🙏🏼🫱🏻🫲🏼
@@prjk4531 Hi, if you get an error while trying to copy pase the code, it might be that you have to replace the , with ; before COLUMN, i think this has to do with your language settings!
Hi why is it everytime I close and reopen it, the highlight doest work again,, all I need to do is to retype again the activecell.calculate inside viewcode.. or else otherwise it won't work again. Can you help me to fixed it.?thanks
For me I figured out that I was using a shortcut to that file. However when I saved it as a macro enabled file that created a new file. So for me it was just figuring out I was accidentally opening my original file.
That's excellent - thankyou. Can you tell me how to apply this rule to all the pages within an existing spreadsheet without having to do this individually for each page?
I can't get this to work :( I'm doing everything the same, but it only highlights one cell and doesn't move it. I added the condition, changed the code, and saved as .xlsm. What am I doing wrong?
You're very welcome. Glad you enjoyed it and thanks for watching! 🙂 🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Hi it tried but hit a road block when I had to add Target.calculate. I am using Microsoft 365 for Mac. I get this message: Microsoft Visual Basic: Variable uses an automatic type not supported in Visual Basic. any help would be appreciated. Thank You
Happens to me too, but I figured it out. Okay bro, just copy and paste this code even in General is okay. It will auto change into Worksheet. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Target.Calculate End Sub
Glad it was helpful. Thanks for watching🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
thanks! seriously hard to believe that Microsoft hasn't created a toggle/button to do this automatically as it really is useful if you have more than 4-5 columns. I dont really like that i now need to save any sheet that i do this to as a macro enabled worksheet with a different extension .xlsm)....but i guess thats the trade-off.
Well, Microsoft does like to keep us on our toes with their updates! Maybe they're just waiting for the perfect moment to surprise us with the automatic toggle/button for Excel columns. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
You are very welcome! Glad it was helpful. 🙂 🔥Check out our FREE 400+ hour training course playlist here 👉 th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Keep up the awesome work, and keep learning! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
You are very welcome! Glad it was helpful. 🙂 🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
Awesome, thanks! What if I want to change the formatting? I ran a new rule but it still does the last one. Also what if I want to turn this feature off? Thanks!!
If you are using Excel in another language than English you must use the "translated" formula names. For example in French, you must type: =LIGNE()=CELLULE("ligne"). It won't work with : =row()=cell("row"). The VBA code does not change however.
Keep up the awesome work and keep learning! We have additional Microsoft Excel Tips and Tricks here ➡️ th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
You are very welcome! Thanks for watching 🙂 🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
You are very welcome! Glad it was helpful. 🙂 🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
You're welcome. Glad you found it useful. 🙂 🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
You are very welcome! Thanks for watching 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
You are very welcome! Thanks for watching 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
hi, i had applied the procedure and it was working perfectly well; until, i left it over the weekend and reopened on Monday when i noticed that it stopped working. I tried closing and opening the files few times but it did not work.
This is a great feature and I did implement it; however, now my data entry lags. After I enter data and hit Enter, it doesn't move to the next cell. I have to wait for it to do it on its own after that. Is that a common issue once you use this feature?
Glad you enjoyed it. Thanks for watching! 🙂 🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Thank you so much for your kind words! We're thrilled that you found the video helpful. 😊 We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! TH-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► th-cam.com/users/simonsezittraining ♥️ We appreciate your support!
To find Turkish formulas in Excel, use the Formula Translator add-in from the Insert tab or visit websites like Excel-Translator for quick translations. You can also ensure Turkish is set as your editing language in Excel options to see localized formulas directly.
You are very welcome! Thanks for watching 🙂 🔥Please check out our FREE 300+ hour training course playlist here 👉 th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
I complete the whole first step the same as showed, but it doesn't highlight anything. Anyone know why? I do have a fill colour given and there are no other codes, so I can't be overruled. It doesn't even work for me when I try it in a new blank save file. Would love some help, thanks!
You are very welcome! Thanks for watching 🙂 🔥Check out our FREE 400+ hour training course playlist here 👉 th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
You're very welcome😊 We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! TH-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► th-cam.com/users/simonsezittraining ♥️ We appreciate your support!
So to achieve this I went into Conditional Formatting Rules Manager and changed the 'Applies to' to =$D$9:T$1048576 This now only highlights the selected Cell row from columns D to T and from Row 9 onwards.
We're glad you enjoyed it! Thank you for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! TH-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► th-cam.com/users/simonsezittraining ♥️ We appreciate your support!
Whaaatttt. I have a code that does the same thing. The only problem is any time I click a new row it doesn't allow me to ctrl-z. Will this code let me undo even after updating the row selection?
Yes thats possible, highlight only the column and row that you wish to be highlighted then .. use the formula =cell("row")=row() instead. Then on the view code use activecell.calculate, and save it using Microsoft Excel Macro-Enable Workbook(*.xlsm)
To prevent the highlighted column or row from showing up when printing, you can temporarily remove the fill color. Select the highlighted cells, go to the "Home" tab, click on "Fill Color," and choose "No Fill." After printing, you can reapply the original color.
You are very welcome! Thanks for watching 🙂 🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
🔥Check out our FREE 300+ hour training course playlist here ➡
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
✅ Check out our free video playlist for Excel beginners 👉th-cam.com/play/PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z.html
✅ Excel 2021 Tutorials for Intermediate Users here 👉th-cam.com/play/PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3.html
✅ Microsoft Excel Tips and Tricks 👉th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
How can I get to Show *VIEW CODE* when I Right Click on Tab
I don't get it when I Right Click on Tab :(
Please
Seems that the key to this working is the VBA code mentioned at the end, which requires saving as a .xlsm (Excel Macro-Enabled Workbook). When I went to save it normally, it popped up some window talking about disabling auto-save that I didn't really understand. The target.calculate basically triggers a recalculation when a different cell is selected, aka when you click on it. Otherwise it wouldn't highlight a row unless you manually refresh for example.
Another video suggested the VBA code : Application.Calculate The latter sort of worked, though not perfectly.
thiojoe jump scare
you can use
=OR(ROW()=CELL("row"), COLUMN()=CELL("col"))
to create a cross effect on the selected cell by highlighting both the entire row and the entire column.
Thank you so friggn much for this. The single row seemed novel but this really is helping me focus. These long bookkeeping/tax days. Again THANK YOU!! 🙏🏼🫱🏻🫲🏼
That's exactly what I wanted. Thanks. I'm amazed this isn't built in to Excel. Very useful with large spreadsheets, helps avoid errors.
Can i do this for the whole workbook instead of each worksheet at a time?
For me it is not working :(
@@prjk4531 Hi, if you get an error while trying to copy pase the code, it might be that you have to replace the , with ; before COLUMN, i think this has to do with your language settings!
Finally someone with a simple solution. Thank you very much.
So glad you found the solution helpful! Excel can be tricky, but it doesn't have to be
YOU CHANGED MY EXCEL LIFE! Thank you! I had over 3500 rows to look through with over 30 columns for months before I saw this video.
Glad it helped! :-)
Köszönjük!
Many thanks for your support!
Thank you so much.❤
You're very welcome! Here’s to more learning in 2025 😊
This is very useful when working with data that spans many columns. Thanks for the tutorial.👍
Glad you liked it. Thanks for watching 😀
Thank you so much @Simon Sez IT You are so genius. I just finished my paper by following your instruction.
I'm so glad to hear that the instructions helped you finish your paper! Great job! 🤩
thank you so much! not sure how I survived in HR with large data sets for almost 20 years without this
So glad to hear that you found the information helpful! It sounds like you've had quite the journey in HR. 😃
This is great! Is there a way to make this available by default in Excel so that we can apply to any sheet when needed?
You can create a macro for that I believe
Hi why is it everytime I close and reopen it, the highlight doest work again,, all I need to do is to retype again the activecell.calculate inside viewcode.. or else otherwise it won't work again. Can you help me to fixed it.?thanks
Same problem ...
@@Sameena2107 Hi already figured it out.. You have to save it using Excel Macro-Enabled Workbook(*xlsm) . I tried it, and it works. 😊
For me I figured out that I was using a shortcut to that file. However when I saved it as a macro enabled file that created a new file. So for me it was just figuring out I was accidentally opening my original file.
Same problem
Save as a macro- .xlsm
That's excellent - thankyou.
Can you tell me how to apply this rule to all the pages within an existing spreadsheet without having to do this individually for each page?
Did you ever find out?
I can't get this to work :( I'm doing everything the same, but it only highlights one cell and doesn't move it. I added the condition, changed the code, and saved as .xlsm. What am I doing wrong?
Please press ctrl+ a
Very cool and worked perfectly. Thank you.
Can i do this for the whole workbook instead of each worksheet at a time?
Did you ever figure out how to do the whole workbook?
wow it's working like magic! Thank you
You're welcome! 😊 Thanks for watching.
Wonderful - Simple ...... I have been hunting this for a very long time ..... THANK YOU!!!
This is an excellent tutorial; thank you so much!!!
You're very welcome. Glad you enjoyed it and thanks for watching! 🙂
🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
I'm making a engineering sheet and it's full of data, your code just made my job a lot easier. Thanks you so much!
Glad the code was helpful for your engineering sheet! Thanks for watching 🙂
Thanks ❤❤❤❤
You are very welcome! Thanks for watching 😃
Thank you very, very much for this, it's life-changing!!
Does selecting all cells in the worksheet & highlight across all columns (instead of just the data) make up file size a lot bigger?
I don't think it does.
Very helpful thankyou 😊
You’re welcome 😊
You are the best
Glad you enjoyed it. Thanks for watching! 😃
Thank you so very much for sharing this. Your instructins were clear and easy to apply. Again, thank you!
I'm glad you found the instructions helpful! 😊
Hi it tried but hit a road block when I had to add Target.calculate. I am using Microsoft 365 for Mac. I get this message: Microsoft Visual Basic: Variable uses an automatic type not supported in Visual Basic. any help would be appreciated. Thank You
Happens to me too, but I figured it out.
Okay bro, just copy and paste this code even in General is okay. It will auto change into Worksheet.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target.Calculate
End Sub
This is super useful. I have to update prices on our system based on a very large spreadsheet and didn't want to get the price from the wrong row.
Glad it was helpful. Thanks for watching🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
thanks! seriously hard to believe that Microsoft hasn't created a toggle/button to do this automatically as it really is useful if you have more than 4-5 columns. I dont really like that i now need to save any sheet that i do this to as a macro enabled worksheet with a different extension .xlsm)....but i guess thats the trade-off.
Well, Microsoft does like to keep us on our toes with their updates! Maybe they're just waiting for the perfect moment to surprise us with the automatic toggle/button for Excel columns. 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thank you. This works!
You are very welcome! Glad it was helpful. 🙂
🔥Check out our FREE 400+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Big help.. thank you 😊
That's awesome! Thanks for watching 🙂
thanku that helps me alot to find the adjact data
You are very welcome! Thanks for watching 😃
Thank you ❤
You are very welcome! Thanks for watching 😃
Thank you, works well.😊
Thanks ☺
You are very welcome 🙂
Was searching for this forever, Thank you so much!
Glad it was helpful. 🤩 Here are more Microsoft Excel Tips and Tricks to try on ➡️
th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Is it possible to highlight a certain row if a special cell is clicked? e.g we want when cell B1 is clicked, then row 12 is highlighted
Ok I got it:
=AND(CELL("row")=1,CELL("col")=2) applied to 12th row
That was helpful thanx!
You are very welcome! Glad it was helpful. 🙂
Hey, it Worked!! Thank You. This is so helpful 😊
Glad it was helpful! 🤩 Learn Microsoft Excel Tips and Tricks here ➡️
th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
excellent tutorial...thanks a lot🤝
Glad you enjoyed it. Thanks for watching! 😃
Thanks for this. 😊
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
It's work. Thanks so much❤
Keep up the awesome work, and keep learning! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
It works thanks just what I needed Excel was driving me nuts scrolling to see the line itself.
You are very welcome! Glad it was helpful. 🙂
🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
thank you it worked!!!
Awesome, thanks! What if I want to change the formatting? I ran a new rule but it still does the last one. Also what if I want to turn this feature off? Thanks!!
Found it - either edit rule or just clear and do it again. Where has this been my whole life!! Thanks again.
Thank you for your kind words! 😊 I'm thrilled that the video was useful to you.
If you are using Excel in another language than English you must use the "translated" formula names. For example in French, you must type: =LIGNE()=CELLULE("ligne"). It won't work with : =row()=cell("row"). The VBA code does not change however.
Thank you! Absolutely could not have figured that out o my own.
You are very welcome! Thanks for watching 😃
How can I make it the default behaviour in any excel file.
Can I do this for the whole workbook instead of each sheet?
Thank you very much...
You are very welcome! Thanks for watching 😃
Awesome. So simply yet very useful, thanks
You are very welcome! Thanks for watching 🙂
thank you for this info SOOOOOO helpful and easy..I soooo new to Excel
Keep up the awesome work and keep learning! We have additional Microsoft Excel Tips and Tricks here ➡️
th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Great tip... Thanks
I'm glad you found the tip helpful! Thanks for watching! 😃
super simple and super cool, thank you for sharing
Glad you enjoyed it. Thanks for watching! 🙂
thank you mam❤️❤️
Most welcome 😊
awesome, thank you so much!!!!!!
Glad it helped! Thanks for watching 🙂
Thanks a lot. It has been extremely useful
You are very welcome! Thanks for watching 🙂
🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
This is working
Thanks
Glad to hear that it's working for you! Thanks for watching 🙂
I was able to get my excel to work. Thank you very much for the lesson!
You are very welcome! Glad it was helpful. 🙂
🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
Thanks！ very useful！
You're welcome. Glad you found it useful. 🙂
🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
Thankyou soo much sir 💐
You are very welcome! Thanks for watching 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
thank you! very useful
You are very welcome! Thanks for watching 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Thank you for making this!!
hi, i had applied the procedure and it was working perfectly well; until, i left it over the weekend and reopened on Monday when i noticed that it stopped working. I tried closing and opening the files few times but it did not work.
When you save it, save as .xlsm as opposed to .xlsx
Thank's a lot!
You are very welcome 🙂
This is a great feature and I did implement it; however, now my data entry lags. After I enter data and hit Enter, it doesn't move to the next cell. I have to wait for it to do it on its own after that. Is that a common issue once you use this feature?
If you want to highlight a cell instead of row you can use this code
=AND(CELL("row")=ROW(), CELL("col")= COLUMN())
if i want to highlight the cell in column B only, when I select any other cell in that row, what would be the formula?
this is amazing how Highlight column
Wow, thanks! Glad it was helpful. 🤩
Is there anyway to apply this to all the excel tabs without having to go in and adding the rule a tab at the time?
tqvm! subscribed!
Thank you so much for subscribing! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Worked perfectly, thank you!
Great to hear!
It worked!! Thank you!
You’re most welcome 😊
NICE. Thanks
Glad you enjoyed it. Thanks for watching! 🙂
🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
My spreadsheet has every 2nd row coloured, these coloured rows won't show the highlighted colour when selected. Is there a way to allow this?
Thanks a lot. Its very helpful.
Thank you so much for your kind words! We're thrilled that you found the video helpful. 😊
We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Hello, thank you for your helps but my MS Office runs in Turkish, how can i find Turkish formulas? 😢
To find Turkish formulas in Excel, use the Formula Translator add-in from the Insert tab or visit websites like Excel-Translator for quick translations. You can also ensure Turkish is set as your editing language in Excel options to see localized formulas directly.
great trick... thanks
You are very welcome! Thanks for watching 🙂
🔥Please check out our FREE 300+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
THANK YOUUUUUUUUUUUUUUUUUUUU!!!!!!!!!!!!!!!!!!!!!!
You are very welcome! Thanks for watching 😃
I complete the whole first step the same as showed, but it doesn't highlight anything. Anyone know why? I do have a fill colour given and there are no other codes, so I can't be overruled. It doesn't even work for me when I try it in a new blank save file. Would love some help, thanks!
Did you do step 2 - change the van code?
I have the same problem...
You made it easy thanks
Glad to hear that!
Not happening for me. i have to press f9 to refresh. What mistake am i doing ? using office 2016
Same issue for me as well.
It work bro I am also using office 2016.
Why when I close it and re open the code disappears? It also goes slowly, I have to double click on the cell to activate it. Is there a way to fix it?
Thank you very much!
You are very welcome! Thanks for watching 🙂
Simply a miracle.
Glad it was helpful! Thanks for dropping by 😀
thank you!!
You are very welcome! Thanks for watching 🙂
🔥Check out our FREE 400+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
It does work!!
Wow, thanks! Glad it workedl. 🤩
Thanks, very succinct!
You're very welcome😊
We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
thank you very nuch
You are very welcome! Thanks for watching 😃
Instead of the entire row being selected, how would I have a row for example from column D to T only selected?
Thanks
So to achieve this I went into Conditional Formatting Rules Manager and changed the 'Applies to' to =$D$9:T$1048576
This now only highlights the selected Cell row from columns D to T and from Row 9 onwards.
that was it! thanks!
We're glad you enjoyed it! Thank you for watching! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Whaaatttt. I have a code that does the same thing. The only problem is any time I click a new row it doesn't allow me to ctrl-z. Will this code let me undo even after updating the row selection?
Could you advise how could i remove this after applying
thanks
You are very welcome! Thanks for watching 😃
What if you only wanted to highlight the part of the row that information typed into it? 🤠
Yes thats possible, highlight only the column and row that you wish to be highlighted then .. use the formula =cell("row")=row() instead. Then on the view code use activecell.calculate, and save it using Microsoft Excel Macro-Enable Workbook(*.xlsm)
How could you prevent highlighted column or row (orange color in this example) to NOT show up when you are printing the document out?
To prevent the highlighted column or row from showing up when printing, you can temporarily remove the fill color. Select the highlighted cells, go to the "Home" tab, click on "Fill Color," and choose "No Fill." After printing, you can reapply the original color.
@@SimonSezIT The active row changes when you move your curser around in your video. I don't believe this answer fits my question. Thanks.
It is working but my system is getting hanging issues after that.
how to delete this function/command?
How about I want to select multiple rows, only the first row is being highlighted, not all the rows I selected.
Great!
thank you
You are very welcome! Thanks for watching 🙂
🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
without cell highlight color how i print a sheet
Everything works right up to the time you click on the second cell, all the ones after that stay the same color, not the one picked, they stay white.