Doing this is very simple!
Just go to the View tab on the Ribbon, and under the Show section, tick (to show) or untick (to hide) the Gridlines.
A little longer way but simple once you get it.
Suppose you have data like this: –
Notice that every alternate cell has text in Bold.
So now you want to select all cells in the sheet that have the formatting as of that is there in cell A1 (Bold in this case).
1. Go to Home tab on the ribbon – Under Editing section click on Find & Select – Choose Find.
2. Click Options.
3. Click on Format, select Choose Format from Cell.
4. Click on A1.
5. Click on Find All.
6. Click on 1 of those results and then Ctrl + A (Select All).
7. Close the Find dialog box.
Your done! 🙂 A little long but effective way 🙂
Keep Excel-ling 🙂
Suppose you have a list of values as this: –
You want to count all values except “d”. Normal =COUNTA will include all values.
But you can NOT count any 1 value (eg – “d”) using this formula: –
What if you want to count all values except “c” and “d” both?
Try this out yourselves.
If you get it, send your answer to me on firstname.lastname@example.org.
Lets see who gets it first 🙂
Whoever gets it, I will post that person’s name on the blog.