Excel – Keep your headings at the top

We provide our delegates with ongoing inspiration and support via short ‘How to’ videos that you can watch and learn from. The latest tips are little things that speed up your work, making you super-efficient. You’ll be well on your way to becoming a productivity Ninja!

This week’s tip is about keeping your headings at the top in Excel. Column headings disappear as you scroll down a spreadsheet, which is frustrating as you want to know what the data means in the columns. In this short ‘How to’ video I’ll show you how to use the Freeze Panes feature, how to pin this button to your Quick Access Toolbar for convenience, then show you a great shortcut to do it in seconds from anywhere in Excel.

If you would like a copy of the file I used in this exercise and step by step directions, sign up for our Tips & Tricks blog.

Contact us on 01952 581550 for course dates and learn Excel with us!

If this is useful to you, you can sign up to receive more free tips directly to your inbox!

You will also receive our Excel Cheat Sheet to get you started.

Tags: , , , , , ,