ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Microsoft Excel-locking a column (https://www.excelbanter.com/excel-worksheet-functions/90578-microsoft-excel-locking-column.html)

Bonnie

Microsoft Excel-locking a column
 
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?



Tom

Microsoft Excel-locking a column
 
Bonnie,
Select column B , then go to WINDOW FREEZE PANES
Regards,
Tom

"Bonnie" wrote:

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?




Microsoft Excel-locking a column
 
Hi
Select cell B1 and click on Windows/Freeze Panes.

Hope this helps.
Andy.

"Bonnie" wrote in message
...
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?






All times are GMT +1. The time now is 01:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com