January 12, 2016
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.
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)
If you missed my last newsletter, you can click here to view it online.
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.
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.
NOTE: You can also access the sort options by right clicking a cell in your table.
| '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