Excel Quick Tips
January 8, 2019
Two quick Excel tips, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
If you're entering temperatures in Excel, you can format the cells to show the degree symbol:
There are more Custom Number Format examples on the Rounding functions page on my Contextures site. Thanks to Jim M, who asked how to add the degree symbol.
When you open an old workbook, or a file that someone else created, you might not know exactly what's in there. Here's a quick way to get a list of the defined names that are in the workbook:
Learn more about Excel names on my Contextures site, and see how to create dynamic ranges with a macro (thanks to Roger Govier for that example)
Here are a few Excel articles that you might find useful or interesting.
Excel Tips - Lori Kaufman show 4 tips for working with the Excel Ribbon - do you ever use that AutoHide command? The article caught my eye, because the screen shots show my Sample Data workbook. (Level - All)
Charts - Jon Peltier shows how to make a repeated Gantt chart in Excel, to track player time on ice. Can you think of other ways to use this type of chart? (Level - All)
Data Viz - Nathan Yau chose his favourite data viz projects from 2018, so take a look, to get inspiration for your own projects. (Level - All)
Also see: My Excel Products || Excel Events || Previous Issues || Weekly Humour
Happy New Year! For 2019, I'm following the 52 week photo challenge, on the Dogwood Photography website. There's one photo challenge each week, and the first one is "Take a picture that tells us who you are, without actually showing your face."
What would your photo show? Here's mine - a shot of the bookcase beside my desk. That's where I spend most of my time, and I certainly use Google many times during the day!
NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2019/20190108ctx.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.
Debra Dalgleish
dsdalg@ gmail.com
P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.
Last updated: January 10, 2019 3:20 PM