Isn't it frustrating when you lose sight of column names as you scroll down a worksheet? Scrolling up to the top to see the column names, and back down again for the data, you can start to feel like a yo-yo.

But you can keep column names in sight, no matter how far you scroll down the sheet, by freezing the names in place. One click in your worksheet, and a click on a menu, that's all it takes. Want to see how?

How to do it (text version):

• Freeze or lock rows and columns

Online training:

• Keep column titles in sight by freezing them in place

 Problems watching the video? Try our troubleshooting tips.