Select cell B1
Window>Freeze Panes
If you had selected B2 instead, it would keep Row 1 in sight as well
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| I'm trying to lock a column so that it doesn't move when I scroll across my
| Excel spreadsheet, is there a way I can do that or no? Please let me know.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.