| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Columns in excel
Can colums be locked so that they do not expand in width?
-- gueyo |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Locking Columns in excel
Hi!! I hope this helps.
The only way to "lock" a cell is to protect the sheet. Format your cells the width that you want them and then click on the "Format" button on your "Home" ribbon. It should be under "Cells". Then click on "Protect Sheet". This will require a password. Once you protect your spreadsheet, it cannot be changed, but you can still edit your information. I hope this helps!! Good Luck! Venetia "gueyo" wrote: Can colums be locked so that they do not expand in width? -- gueyo |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Locking Columns in excel
Thank you, very much
-- gueyo "Venetia" wrote: Hi!! I hope this helps. The only way to "lock" a cell is to protect the sheet. Format your cells the width that you want them and then click on the "Format" button on your "Home" ribbon. It should be under "Cells". Then click on "Protect Sheet". This will require a password. Once you protect your spreadsheet, it cannot be changed, but you can still edit your information. I hope this helps!! Good Luck! Venetia "gueyo" wrote: Can colums be locked so that they do not expand in width? -- gueyo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking rows and columns | Excel Discussion (Misc queries) | |||
| Locking columns | Excel Discussion (Misc queries) | |||
| Greying out or locking certain columns | Excel Discussion (Misc queries) | |||
| Locking columns | Excel Discussion (Misc queries) | |||
| Locking and Hiding Columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
