Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting cells
Back in the good old days, when we had lotus, we could simply protect cells. Why doesn't Excel tell us how to protect cells? Why is it not simple? How do you do it? -- GregP1962 ------------------------------------------------------------------------ GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063 View this thread: http://www.excelforum.com/showthread...hreadid=549713 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting cells
By default, all cells are locked. When you protect the worksheet
(Tools menu), all cells will be protected. To protect only some cells, first select all cells (click the gray box above the column header and to the left of the row headers), go to the Format menu, choose Cells, then the Protection tab. There, uncheck the locked checkbox. The select the cells you wish to protect, go back to the Protection tab and check the Locked property. Then, protect the worksheet. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "GregP1962" wrote in message ... Back in the good old days, when we had lotus, we could simply protect cells. Why doesn't Excel tell us how to protect cells? Why is it not simple? How do you do it? -- GregP1962 ------------------------------------------------------------------------ GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063 View this thread: http://www.excelforum.com/showthread...hreadid=549713 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting cells
hi, you can protect the full spreadsheet. but you can also select all cells,
unblock all of then, and block the cells that you want, after protect the worksheet, you just protected the cells that you block. regards "GregP1962" escreveu: Back in the good old days, when we had lotus, we could simply protect cells. Why doesn't Excel tell us how to protect cells? Why is it not simple? How do you do it? -- GregP1962 ------------------------------------------------------------------------ GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063 View this thread: http://www.excelforum.com/showthread...hreadid=549713 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Protecting locked cells | Excel Discussion (Misc queries) | |||
Protecting specific cells in a worksheet. | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Protecting certain cells | Charts and Charting in Excel |