Contextures

Contextures News 2021-07-13

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.

Header Font Size

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):

  • 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 both the header and footer.)

Find more tips for Excel worksheets on my website.

footer settings

Excel Articles

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

Garden Gold

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!

weekly photo

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.

Debra Dalgleish
dsd @contextures.com
ctxdebra @gmail.com

Debra Dalgleish

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.

contextures newsletter info

 

Last updated: July 25, 2021 2:07 PM