Computeractive

Make Office Better

MICROSOFT EXCEL

Add headers and footers to multiple worksheets

You can easily add headers and footers across multiple worksheets, saving you the hassle of doing so individually.

First, press the Shift key as you click the worksheets at the bottom ( in our screenshot). This selects them all. Now click the Page Layout tab at the top and click the small arrow at the bottom right.

You’re reading a preview, subscribe to read more.

More from Computeractive

Computeractive1 min read
Roku Wants To Show Adverts On Any Device Connected To Your TV
Roku wants to show adverts on any device that you connect to your TV via HDMI, including TV boxes, game consoles, DVD/Blu-ray players, PCs and even other video-streaming devices. The adverts would appear only on TVs made by Roku, such as the new Logi
Computeractive1 min read
Computeractive
Group Editor in Chief Graham Barlow Group Editor Daniel Booth Deputy Editor Robert Irvine Production Editor Graham Brown Art Editor Katie Peat Contributors Keumars Afifi-Sabet, Judith Batchelor, Dinah Greek, Jonathan Parkyn, Nik Rawlinson, Andy Shaw
Computeractive5 min read
Phone and Tablet Tips
Google has updated its Photos app with a useful feature called Photo Stacks, which keeps your pictures better organised by grouping similar shots. Instead of showing multiple photos of the same subject, taken seconds apart, Stacks presents them as a

Related Books & Audiobooks