Freezing titles

Hi Rachel,

Freeze columns is a feature in Excel - we call it Freeze Panes but the concept is the same.

On the View Tab click on Freeze Panes
It has three options: Top Row or First Column are the two that always work

Has you scroll the Top row or First Column stay still

The third option is slightly harder
If you have your headings/titles in Row 1
Names in Column A
Data in Column B - E

You don't want to freeze just the top row or first column, you want to freeze both!

First get into the right place on the excel sheet

Click on the cell B2 - everything to the left of this - Column A. Everything above it will be frozen - the headings

Now click on the Freeze panes button and choose the other option.

The faint grey lines on your screen will let you know the Freeze panes are working.

Click back on the freeze panes button and it will say Unfreeze.

Have a go. Let me know if you need me to help you further with that.


Kind regards

Richard Bailey
Microsoft Certified Trainer

Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector