FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week


Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

January 12, 2016

TheExcelAddict.com Quote of the Day
"You will never reach your destination
if you stop and throw stones at every dog that barks."
-- Winston Churchill --


Hi fellow Excel Addict,

Welcome to 2016.

I hope you had a wonderful and safe Christmas and New Year. Here in eastern Newfoundland, it snowed a week before Christmas and we were lucky enough to have a white Christmas Eve. However, it rained on Christmas Day and all the snow disappeared again. Unfortunately, Tina and I haven't been able to use the snow shoes we got for Christmas gifts.

Christmas Eve Snow Kelligrews 2015

I am really looking forward to 2016 and I hope that I can help you with your Excel training over the next year. Last year was somewhat of a turbulent year for me as planning for retirement, retiring and then adjusting to retirement did take a lot of focus away from my Excel work. So I do apologize if I have let you down in any way.

What I would like, is for you to tell me what your Excel goals are for 2016. By understanding your needs, it will help me provide you with more relevant information and resources to reach your goals.

Also, if you have any suggestions for me on what you'd like to see from my newsletter and website in 2016, please let me know. I can't guarantee that I will deliver on them all but all suggestions are welcome.
I'm looking forward to hearing from you.

Have a great week and keep Excelling,

Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com


Francis Hayes (TheExcelAddict.com)


If you missed my last newsletter, you can click here to view it online.



Excel in Seconds with TheExcelAddict.com

Sort by Background Color or Font Color


If you are using Excel 2007 or later, you can now sort your data based on the background color of the cells or the font color.  If you use Conditional Formatting icons, you can also sort by icon color.

To sort by color...

1) Select the data you want to sort (or click a single cell in a table);

2) From the Data tab, click the Sort command (i.e. the one with the Z-A/A-Z image);

3) In the Sort dialog, you'll find the 'sort by color' options on the Sort On dropdown.

Sort By Cell Font Or Icon Color in Microsoft Excel 2007_2010_2013_2016

4) When working with multiple colors, for each color, click the Add Level button on the Sort dialog to set the order you want it sorted.

Choose Sort Order For Colors in Microsoft Excel 2007, 2010, 2013, 2016, 365


NOTE: You can also access the sort options by right clicking a cell in your table.

Right_Click_Sort_By_Color_Menu_Options in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365




Thanks for supporting this newsletter and website

FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week


Subscription Information: Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter. If this newsletter was forwarded to you and you would like to get your own copy, please visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com

 If you would like to share this newsletter with others...
1) Share a link to this page
2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com
3)  Post a link to TheExcelAddict.com in a company newsletter or website.

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630