Share via

How can I lock formatting, column size, fonts, etc. so that it will not be changed over time in my workbook?

Anonymous
2011-03-02T16:49:35+00:00

I have just put together a workbook that should help us get things done more efficiently around the office. The last thing I need in it looking all out of wack due to multiple users and we don't have time to baby the program. How can this be done? I am doing this in 2010 but will be saving it in 2007 because that is what we use at the office.

Thanks,

Doug

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2011-03-04T11:15:10+00:00

    Follow the steps below and see if it helps.

    1.       Select the range of cells that you want to edit, right click on the range of cells and then click format cells.

    2.       Protect the sheet by clicking Review > Protect Sheet. This allows you to protect the complete work sheet.

    3.       In the protection tab uncheck 'locked' checkbox.

    3 people found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-03-02T19:24:59+00:00

    Hi Doug,

    If you select the cells that users will be allowed to edit, right click on the cells and deselect locked, then protect the worksheet and workbook from the Review menu/Changes group. The user won't be able to change the format, but will be able to edit the cells that were unlocked.

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2011-03-02T23:00:42+00:00

    I am unable to get this to work. First there is no "deselect locked" if I right click on the cells.  If I select the areas that I want the user access to edit and then in the  Review menu/Changes group I click protect worksheet, it doesn't matter what variation of items I check, it will not let me edit a cell in the worksheet.  It either locks me out completely if I uncheck "select locked cells", or when checked, allows me to select the cell, but when i try to type it errors saying it is protected...

    0 comments
  3. Anonymous
    2011-03-02T22:18:46+00:00

    How about cells that you want all access restricted? Is that in there too?

    0 comments