Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiply two columns in Excel or one column by one number | New Users to Excel | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Sort Excel Column on Fifth Character | Excel Worksheet Functions | |||
Check COlumn - Excel VBA | Excel Discussion (Misc queries) | |||
creating a bar graph | Excel Discussion (Misc queries) |