Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

In Excel, is it possible to protect certain columns but not the whole spreadsheet ?

We know how to protect an Excel spreadsheet against revisions.

Is it possible to protect ( not allow revisions ) certain columns of an Excel spreadsheet ? If yes, please tell me the commands.

Say I want to protect columns E, F, G only. The person reviewing my spreadsheet can alter content of cells in other columns.

Thank you.

6 Answers

Relevance
  • jmorge
    Lv 6
    1 decade ago
    Favorite Answer

    yes. By default all cells are "protected" although the protection doesn't take effect unless you turn the worksheet protection feature on. To unprotect a cell (or a column) you first have to "unprotect" those cells. To do this right click on a cell and select Format Cells. Go to the "Protection" tab. Uncheck the "locked" option. This will unlock that cell. Now when you protect your workbook, that cell will be unprotected and people can change only that cell.

    In your case you want to protect only columns E, F, G and unprotect all others. The easiest way to do this would be to select all cells (press CTRL-A to select all cells). Then right click, select Format cells, go to the Protection tab and turn off the "locked" option on all the cells. All cells would now be unprotected. Now select columns E, F, G and Format cells and "lock" those cells/columns again. And finally protect the workbook as you normally would. Since the only cells that are "locked" are those in E, F, G, the person using the spreadsheet will not be able to change those cells/columns but can change everything else.

  • Anonymous
    6 years ago

    I thinkto protect certain columns but not the whole spreadsheet

  • Anonymous
    6 years ago

    I think it could not be very feasible to protect certain columns but not the whole spreadsheet

  • Anonymous
    6 years ago

    to protect certain columns but not the whole spreadsheet ? yes it can be probable

  • Anonymous
    6 years ago

    to protect certain columns but not the whole spreadsheet is not feasible indeed, sorry

  • Anonymous
    5 years ago

    this would be easiest if you can add a column to the left of the data in the new column type the formula =RIGHT(B1,2) and copy the formula down the number of used rows now select all of the data and sort using the values in column A hope that helps

Still have questions? Get your answers by asking now.