Excel Better Headers and Footers
July 13, 2021
Office Scripts, stop header and footer scaling, 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.
Thank you for reading the news, and you'll get the next email on July 27th.
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
Do you scale some of your Excel reports, so they print on a single page, or one page wide? I love that feature, because it saves paper, but it can make the header and footer text too small to read. It's usually in a small font size already, and scaling makes it worse!
To keep the header and footer text at its original size, you can change a setting for the selected sheet(s):
Find more tips for Excel worksheets on my website.
Here are some Excel-related links that you might find useful or interesting.
Office Scripts: If you create macros in Excel, they won't run in the online version. Jan Karel Pieterse shows how to get started with Office Scripts, which allows you to automate things in Excel online. (Level - Int/Adv)
Power BI: On the Excelerator BI blog, Matt Allington shows how to compare two things in Power BI, such as different years, or company products. (Level - Int/Adv)
Movies: Did you know Excel played an important role in the children's movie, "Babe"? The livestock manager used it to keep track of all the piglets who played Babe, during the 6 months of filming. Can you guess how many they used? (Level - All)
Also see: Previous Newsletter Issues
A few of the golden cherry tomatoes in our garden have ripened, and there are lots more on the plants. We like this variety because the tomatoes are delicious, and the crop is ready by early summer. The basil, oregano and parsley are ready too, so I'm sure we can use those ingredients to make something tasty for supper!
NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2021/20210713ctx.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: July 25, 2021 2:07 PM