Excel Tip – Advanced Select Using Find
It’s already the 2nd week in March and I’m running soooo late with my ‘Keep it Simple’ tip!
But I promise it’s worth waiting for!
This month it is a really lovely Excel tip that will allow us to, when suitable, bypass using a Filter!
You can view the video or follow the step-by-step shown underneath.
Enjoy and remember: Keep it Simple!
I want to highlight all the cells with the words ‘Item 2‘ written in to them.
In a large data set, I would probably set up a filter; but I’m going to do this using the Find feature.
- This time I do NOT need to be clicked into the data set – or to have anything selected.
- To open Find you can use the keyboard shortcut CTRL + F.
- Or – you can click on the Find & Select button – then click on Find in the menu.
- Type in ‘Item 2‘ into the Find What box (note that it’s not case sensitive).
- Then click on the Find All button.
- You can see that it’s picked up 5 cells containing that text.
- I could scroll down and use the SHIFT key to select them.
- But I’m going to use the keyboard shortcut CTRL + A to do the same.
- Once they are selected, I can click the Close button.
- Then I can go ahead and put on the Fill Colour or whatever it is that I want to do to that selection.
Thank you for watching and I’ll be back with another useful ‘Keep it Simple‘ tip – next month (hopefully on time)!