November 22, 2016
Hi fellow Excel Addict,
Just a few notes about last week's 'Excel in Seconds' tip 'Access Your Recent List of Workbooks From the Windows Taskbar'. I received a ton of feedback about this one from people who were unaware of this option. Many said it was 'the best tip ever'.
And it gets even better. Kellie G. even shared an additional tip that makes this even more awesome. Rather than right click on the taskbar button, you can just left click and drag up to reveal the Recent list. I DIDN'T KNOW THAT! It's only a small difference but I like this way better. Thanks Kellie.
This proves what I have been saying for years. It doesn't matter how well we think we know Excel or how long we have been using it, there are always better ways that someone else can teach you.
Did you notice that this tip also works for most other programs? In addition to accessing your recent files, right-clicking (or left-clicking and dragging up) a Taskbar button, for some programs, allows you to immediately initiate common tasks such as create a 'New E-mail Message' in Outlook or, with Explorer, open recently-used folders.
In last week's 'Excel in Minutes' tip (read it here), I showed you how to locate all the merged cells in your worksheet. That revealed a couple of new tricks that you maybe weren't aware of (i.e. find cells based on formatting and select all the found cells) that you can also use in other situations. In today's 'Excel in Seconds' tip, I will show you how to 'Quickly Identify Cells With Conditional Formatting', which is even easier to do.
Please feel free to share my newsletter with your Excel friends — they will thank you for it.
My sister caller me from Ottawa yesterday and told me that their weather is freezing and everything is covered in snow. I couldn't resist sending her this picture.
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
Quickly Identify Cells With Conditional Formatting
If you're a fan of Conditional Formatting you likely have struggled with this little issue. Once you have applied Conditional Formatting to a range (or ranges) of cells you often need to go back later and make changes to the formatting or the condition used. You need to make the change to all the cells you previously formatted, but how can you tell which cells have Conditional Formatting?
Not a problem!
There is an easy way to identify cells that have Conditional Formatting applied. Press the F5 key and click the Special... button at the bottom of the Go To dialog. When you click the Conditional Formats option, another option (All, Same) becomes available.
To identify all the cells that have the same Conditional Formatting as the currently selected cell, click Same and then OK. All cells on the worksheet that have the same Conditional Formatting as the selected cell will be selected. You can now easily make changes or select additional cells to apply the formatting to.
Instead of choosing the Same option, choosing All will highlight ALL cells in the worksheet that have Conditional Formatting.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630