Microsoft Excel-locking a column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bonnie - 25 May 2006 15:49 GMT

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?

Reply to this Message

Tom - 25 May 2006 15:57 GMT

Bonnie,
Select column B , then go to WINDOW > FREEZE PANES
Regards,
Tom

> 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
[quoted text clipped - 3 lines]
> How do I lock the first column so it slides along with me as I move across
> the spreadsheet?

Reply to this Message

Andy - 25 May 2006 15:59 GMT

Hi
Select cell B1 and click on Windows/Freeze Panes.

Hope this helps.
Andy.

>I am creating a weekly log of what I sell in my restaurant. Each column is
>a
[quoted text clipped - 6 lines]
> How do I lock the first column so it slides along with me as I move across
> the spreadsheet?

Reply to this Message