Demo: Keep column names in sight when you scroll

Office demo Watch the demoDemo icon

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):

Assistance Problems watching the video? Try our troubleshooting tips.

Applies to:
Excel 2003