Contextures

Contextures News

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.

Fix the Footer

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:

  • Go to the Page Layout tab on the Excel Ribbon.
  • In the Page Setup group of commands, click the little arrow at the bottom right of that group, to open the Page Setup dialog box.
  • Click the Header/Footer tab, and at the bottom, remove the check mark from "Scale With Document".
  • Then, click OK to exit. (Note: this setting will affect the Header too.)

Find more tips for Excel worksheets on my website.

footer settings

Data Visualization

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.

Excel Articles

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)

Also, see all my Excel products on my Contextures website, and my weekly collection of humorous Excel tweets. For example, "My work days consist of 90% fighting with excel and 10% actual work".

Healthy New Year

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!

weekly photo

That's it for this week! If there are topics that you'd like to see covered in future emails, please let me know.

Debra
ddalgleish @ contextures.com

P.S. You can choose to get the full Contextures news package (news and occasional special announcements), or the basic news package (news only). Click either link to change your news option.

Note: I am an affiliate for some of the products mentioned in this email, and earn a commission on the sales.

 

Search Contextures Sites

Excel Data Entry Popup List

 

 

 

 

Last updated: March 15, 2017 11:56 AM