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.
Trending News
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
- jmorgeLv 61 decade agoFavorite 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.
- Anonymous6 years ago
I thinkto protect certain columns but not the whole spreadsheet
- Anonymous6 years ago
I think it could not be very feasible to protect certain columns but not the whole spreadsheet
- Anonymous6 years ago
to protect certain columns but not the whole spreadsheet ? yes it can be probable
- Anonymous6 years ago
to protect certain columns but not the whole spreadsheet is not feasible indeed, sorry
- Anonymous5 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