I just HAD to share this little gem with you. There is a button in Excel for freezing rows and columns really easily. It’s a small icon right at the very top of the scroll bar, and a similar one to the far right of the horizontal scroll bar.

All you need to do is drag it where you want the freezing to be in either the columns or the rows, or indeed both. Neat Yes?

Freeze Rows

Freeze Columns

Give this tip a go, you will be glad you did.

Other Excel tips You Might Like.

1. Centre a title across an Excel worksheet

2 Change the standard font in your workbooks

3. Conditional formatting in Excel