Microsoft Excel-locking a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a weekly log of what I sell in my restaurant. Each column is a
new week and each row is a menu item. I fill in the amount sold across the
page. I am trying to lock the first column so I can read the menu items as I
go along.

How do I lock the first column so it slides along with me as I move across
the spreadsheet?
 
Bonnie,
Select column B , then go to WINDOW > FREEZE PANES
Regards,
Tom
 
Hi
Select cell B1 and click on Windows/Freeze Panes.

Hope this helps.
Andy.
 

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.

Ask a Question

Back
Top