Dear awesome viewers! Thank you for your amazing engagement! Remember, the most liked comment gets pinned - so start liking your favorites now! I love your questions and will try to respond to as many as I can. For quick generic queries, the comment section is perfect. But need more in-depth, personalized advice? Book a personalized consultations with me via topmate.io/mehran_vahedi. They're ideal for detailed, specific questions. Your support means the world to me. Let's keep the conversation going! Thank You!
Thanks, @araparts! I'm really glad you found the video helpful. If there are any other Excel topics you'd like me to explore, feel free to drop your suggestions here! 👍
Hello, thank you very muxh for leaving a comment. I am so happy that you found the video useful. If you haven't subscribed already make sure you do so you wont miss out on my next videos.
Thank you so much for your kind words! I'm thrilled to hear you found the video extremely helpful. Your support motivates me to keep creating content that can make a difference. If there's anything specific you'd like to learn more about in future videos, please let me know. Don't forget to subscribe and hit the bell icon for updates. Thanks again for being such a valuable part of our community!
Hello and thank you for the comment. I'm not sure if I understand your question as no Macro's were used in this approach. I think the approach I explained is one of the best approaches. There are obviously other methods such as using special filters and also using VBA code to delete specific rows.
Hi @brasucafr, I'm so glad to hear that the video was helpful! If you have any more questions or need further tips on Excel, feel free to ask. Thanks for watching!
Hello, Thanks for the message. If you are using Excel on a MacOS then it is applicable. I believe the keyboard shortcuts are different in a MACbook so you will need to use the equivalent keyboard short cuts for a MACbook.
When I highlight the column where I want to find the value and then find all, it finds all in the entire sheet and not just in the highlighted column. What am I missing?
Hi @Nerdy-Together, it sounds like you might need to adjust how you're setting the scope for the "Find" function in Excel. When you use the "Find" function, it defaults to searching the entire worksheet unless specified otherwise. Here’s how to ensure it searches only within your highlighted column: [1] Highlight the column where you want to search for the value. [2] Open the Find dialog box by pressing Ctrl + F. [3] Click 'Options' in the Find dialog box to expand it. [4] Set 'Within' to ‘Sheet’ and make sure 'Look in' is set to 'Values'. [5] Specify the search direction if needed, usually 'By Columns' is suitable for a column search. This should limit the search to just the highlighted column. If it still searches beyond, make sure no other cells or columns are selected. Sometimes Excel might seem to only highlight the column you clicked on, but actually, more of the sheet is selected. Double-check by clicking only on the column letter at the top of your column before starting the Find operation. Let me know if this helps or if you have any more questions!
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
Dear awesome viewers!
Thank you for your amazing engagement! Remember, the most liked comment gets pinned - so start liking your favorites now!
I love your questions and will try to respond to as many as I can. For quick generic queries, the comment section is perfect. But need more in-depth, personalized advice? Book a personalized consultations with me via topmate.io/mehran_vahedi. They're ideal for detailed, specific questions.
Your support means the world to me. Let's keep the conversation going!
Thank You!
Fantastic! Thank you!!
Thanks, @araparts! I'm really glad you found the video helpful. If there are any other Excel topics you'd like me to explore, feel free to drop your suggestions here! 👍
Thank you so much for this video! Very helpful!
Hello, thank you very muxh for leaving a comment. I am so happy that you found the video useful. If you haven't subscribed already make sure you do so you wont miss out on my next videos.
Not only helpful, very very helpful.
Thank you so much for your kind words! I'm thrilled to hear you found the video extremely helpful. Your support motivates me to keep creating content that can make a difference. If there's anything specific you'd like to learn more about in future videos, please let me know. Don't forget to subscribe and hit the bell icon for updates. Thanks again for being such a valuable part of our community!
Hi, is there an easier way to do it across worksheets without using Macro's?
Hello and thank you for the comment. I'm not sure if I understand your question as no Macro's were used in this approach. I think the approach I explained is one of the best approaches. There are obviously other methods such as using special filters and also using VBA code to delete specific rows.
Thank you, it help a lot!!!
Hi @brasucafr, I'm so glad to hear that the video was helpful! If you have any more questions or need further tips on Excel, feel free to ask. Thanks for watching!
Is this applicable for MacOS as well? Thanks
Hello, Thanks for the message. If you are using Excel on a MacOS then it is applicable. I believe the keyboard shortcuts are different in a MACbook so you will need to use the equivalent keyboard short cuts for a MACbook.
When I highlight the column where I want to find the value and then find all, it finds all in the entire sheet and not just in the highlighted column. What am I missing?
Hi @Nerdy-Together, it sounds like you might need to adjust how you're setting the scope for the "Find" function in Excel. When you use the "Find" function, it defaults to searching the entire worksheet unless specified otherwise. Here’s how to ensure it searches only within your highlighted column:
[1] Highlight the column where you want to search for the value.
[2] Open the Find dialog box by pressing Ctrl + F.
[3] Click 'Options' in the Find dialog box to expand it.
[4] Set 'Within' to ‘Sheet’ and make sure 'Look in' is set to 'Values'.
[5] Specify the search direction if needed, usually 'By Columns' is suitable for a column search.
This should limit the search to just the highlighted column. If it still searches beyond, make sure no other cells or columns are selected. Sometimes Excel might seem to only highlight the column you clicked on, but actually, more of the sheet is selected. Double-check by clicking only on the column letter at the top of your column before starting the Find operation.
Let me know if this helps or if you have any more questions!