![]() |
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? |
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