![]() For example, closing the workbook without saving changes might cause you to lose too much work if you haven’t saved the file in a while. Unfortunately, these three scenarios don’t always apply when you want to revert a workbook to an earlier state. If you haven’t saved the workbook since you made the error, and you don’t need to preserve any changes you’ve made since the last save operation, you can close the workbook without saving it. If the error was not the most recent action, but you don’t need to preserve any workbook changes you’ve made since then, you can repeatedly use Undo until the mistaken action is reversed. If the improper edit or paste was the most recent action you performed, you can use Undo to reverse the action. In some circumstances, you can use the following methods to recover: On occasion, you might realize that you have improperly edited some workbook data, or you have accidentally overwritten an important worksheet range during a paste operation. Use the Encrypt With Password command to protect your workbook with a password In the Format Cells dialog box, on the Protection tab, clear the Hidden check box, and then click OK. On the worksheet, select the cells that contain the formulas you want to show. To show only certain formulas in worksheet cells In the Format Cells dialog box, on the Protection tab, select the Hidden check box, and then click OK. On the Home tab, click Format, and then click Format Cells. Select the cells that contain the formulas you want to hide. On the Home tab, click Format, and then click to activate the Lock Cell command. On the Home tab, click Format, and then click to deactivate the Lock Cell command. On the Home tab, in the Cells group, click Format, and then click to deactivate the Lock Cell command. When you set up protection formatting on one or more cells, or protect one or more ranges with a password, your restrictions don’t go into effect until you activate worksheet protection. After you protect the sheet, only authorized users who know the password can edit the range. That is, if you want to prevent unauthorized users from editing within a specific range, you can set up that range with a password. If you don’t want to protect the entire worksheet, you can restrict your protection to a more targeted area. To keep only selected formulas visible, hide every formula and then make the formulas you want visible. Then select the cells you want protected and lock them. If you want only certain cells to be locked, first select all the cells and unlock them. Similarly, if you want certain formulas hidden, you can select the cells and hide their formulas. If you want only certain cells to be unlocked (for data entry, for example), you can select those cells and unlock them before turning on worksheet protection. If you want to protect every cell, you can leave the formatting as it is and turn on worksheet protection. With this in mind, here are the options you have when setting up your protection formatting: That’s because Excel doesn’t perform the actual lock-that is, it doesn’t prevent users from modifying the cells-until you turn on worksheet protection. Note, however, that “locked” in this context really only means that the cells have the potential to be locked. Protect a range with a password When you use this technique, you protect one or more ranges with a password, and then specify which users are allowed or denied editing privileges on that range.īy default, all worksheet cells are formatted as locked and their formulas are visible. ![]() You then turn on worksheet protection, which means that locked cells can’t be changed, deleted, moved, or copied over, and that hidden formulas are no longer visible. You can also hide the formulas in one or more cells if you don’t want users to see them. Protection formatting When you use this technique, you format those cells in which you want to allow editing as unlocked, and you format all other cells as locked. You can prevent this problem by using Excel’s worksheet protection features, which you can use to prevent changes to anything from a single cell to an entire workbook.įor protecting cells, Excel offers two techniques: When you have labored long and hard to get your worksheet formulas or formatting just right, the last thing you need is to have a cell or range accidentally deleted or copied over. Objective 1.2: Manage workbook review Restrict editing
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |