Excel Tiny Font Fix
February 4, 2020
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
Data entry is easier with a data validation drop down list in Excel. However, I can barely read those lists, because the font only 8pt, and there's no setting to make it bigger.
To fix the problem, you can show a pop-up combo box, instead of that drop down list. You can make the font bigger in a combo box, and when you start typing, it autocompletes the matching item.
Another way to make the font look bigger, is to increase the zoom on the worksheet.
Macro: To temporarily increase the zoom, use a zoom macro from my Data Validation Tips page.
No Macro: For a non-macro solution, John Culley suggests setting the sheet's zoom setting to 120%, so the drop down font looks larger. Then, reduce the font size in the worksheet cells, to make everything else look a normal size. For example, change 12 pt font to 10 point, as I did on the worksheet shown below.
Here are a couple of recent items from my Contextures site and blogs.
Documentation: Do you keep notes about your complex Excel formulas and macro? If you do, what's your system?
Pivot Tables: Occasionally, I hide pivot table buttons and labels, to prevent people from making accidental changes to the filters and layout.
Here are a few Excel-related articles that you might find useful or interesting.
Filters: Bill Jelen and Roger Govier use macros to show which Excel columns are filtered (Level-Int/Adv)
Data Analysis: If you ever work with messy data in Excel, you'll relate to the data nightmare problems that Dr. Kate Lakowski had, when using someone else's data. What a tangled "web" it was! (Level -All)
Excel Humour: See what people said about Excel recently. Are pivot tables the high-water mark of Excel skills?
We make lots of soup in the winter, and I chop the vegetables with the lazy method. Put vegetable chunks into the blender, cover with water, and hit the grate button for a few seconds. Then, strain the water out, or just dump it all into the slow cooker, with a few more ingredients.
It's not pretty, but it's quick, and the onions don't cause tears! This was for Vegan Cabbage Soup, with a few extra seasonings thrown in.
NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2020/20200204ctx.html
I'll also post any article updates or corrections there.
That's it for this week! If you have any comments or questions, send me an email.
Last updated: January 31, 2020 2:52 PM