June 7, 2016
Hi fellow Excel Addict,
Thank you for taking some time out of your day to read my newsletter. Do you know that you are part of the very small percentage of Excel users who consistently look for new ways to improve their Excel skills?
Yes, there are hundreds of millions of people all over the world using Excel every day and most of them (and many of their bosses and managers too) don't bother to take the time to look for new ways to become more efficient with Excel. It's something that has frustrated me ever since I started trying to share my Excel knowledge with my coworkers more than 20 years ago.
Thank you for not falling into that group.
Always keep looking for 'a better way' to do whatever it is you are doing in Excel. There always seems to be new ways to improve on almost everything.
In the 20+ years I've been using Excel, I am amazed at how often I discover new things that I didn't know I didn't know.
If you missed lat Thursday's Excel in Minutes' tip, 'Are Your Worksheets Bigger Than You Realize?', you can read it here now.
Got a suggestion for a tip you would like me to include in a future newsletter? Please hit Reply and send it along to me.
Keep on Excelling,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
Get the Perfect Font Size
You will notice that the Font Size dropdown list starts at 8 and goes up to 72, including some large gaps in the bigger fonts.
How often have you been formatting something and tried one size that was too small but the next size was too big and you had to settle for one of them? You don't need to settle for second best. In Excel, you can have whatever font size you want.
Although it may appear that these are the only font sizes available to you, in fact, you can use any size from 1 to 409. You can also use half-point sizes (e.g. 8.5). All other fractional point sizes (e.g. 8.75) will be rounded to the nearest half point.
Simple click the font number to the left of the dropdown arrow and type a value between 1 and 409, then press Enter.
There you have it, a perfect font size.
| '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