Excel pastes the contents of the Clipboard to the new worksheet. Display the new, blank worksheet you created in step 1.This copies the selected cells to the Clipboard.
(If it doesn't, hold down the Shift key and press the arrow keys until you have selected all the worksheet cells.) Excel should select all the used cells in the worksheet. The first cell in the worksheet (A1) should be selected. Display the original worksheet that is protected.
This can be in the current workbook or in a new workbook. Dennis wants to know how he can unprotect the worksheet so he can make the necessary changes.ĭepending on the way that the worksheet was protected, you may be able to simply copy the worksheet contents to a new worksheet.
There is the problem, though: The worksheet is locked, and changing the formulas is not permitted because of the protection. Some of the cells in the worksheet need to be unlocked so that Dennis can correct the outdated formulas they contain. Dennis has a travel expense worksheet that he has inherited it has been passed down within his organization for years.
0 kommentar(er)
