Fix the Excel Footer
January 10, 2017
Keep the text in a footer from shrinking, and more, in this week's Excel news. Visit my Excel website for many more tips, tutorials and videos -- let me know if you're looking for something and can't find it there.
If you're working on year-end reports in Excel, and printing worksheets at a reduced scale, you can adjust the settings so that the footer text doesn't end up too small to read.
To change the footer setting for the active sheet:
Find more tips for Excel worksheets on my website.
There is a free online course starting next week -- Data Exploration and Storytelling: Finding Stories in Data with Exploratory Analysis and Visualization. It runs from January 16 - February 26, 2017.
Led led by Alberto Cairo and Heather Krause, the 6-week course will teach you how to find data, how to download it, how to analyze it, and then how to present it as stories and visualizations.
It's a Massive Open Online Course (MOOC) course, so you won't get lots of personalized attention from the instructors. However, there should be message boards and comment sections where you can post questions, if you need help along the way.
Here are a couple of recent Excel articles that you might find useful.
VisiCalc History - Last week was the 38th anniversary of the date when Software Arts was incorporated. Later that year, they launched VisiCalc, and changed spreadsheets forever. On my Spreadsheet Day blog, you can read more about it, and find links to other articles. (Level - All)
Conditional Formatting - See how to put criteria on a worksheet, then format other cells, based on those two criteria. The example shows everything on one sheet, but you can keep the criteria on a different sheet, for safekeeping. (Level - Intermediate)
Happy New Year! I hope you enjoyed the holidays, and had time to relax before heading back to work. We had fun with our family at Christmas, and then I got a head cold, which eventually turned into pneumonia. Thankfully, things are getting better now, and I'll try to stay healthy for the rest of the year!
That's it for this week! If there are topics that you'd like to see covered in future emails,
please let me know.
ddalgleish @ contextures.com
Note: I am an affiliate for some of the products mentioned in this email, and earn a commission on the sales.
Last updated: March 15, 2017 11:56 AM