Unlock Formula Title For Free

On the Page Layout tab, in the Page Setup group, click Print Titles. If the Print Titles ribbon button is grayed out, check to ensure that you're not currently editing a cell or an area chart. Also, check to verify that at least one printer is set up in Windows.

Turn off Scroll Lock If your keyboard does not have a Scroll Lock key, on your computer, click Start > Settings > Ease of Access > Keyboard. Click the On Screen Keyboard button to turn it on. When the on-screen keyboard appears on your screen, click the ScrLk button.

Check the permission on the file, Select Enable Content on the trust bar, or check the security and privacy options in the Microsoft Office Trust Center.

Open the Format Cells dialog by pressing Ctrl + 1. Or, right-click any of the selected cells and choose Format Cells from the context menu. In the Format Cells dialog, go to the Protection tab, uncheck the Locked option, and click OK. This will unlock all cells in your worksheet.

To turn off Scroll Lock, simply press the Scroll Lock key on your keyboard. If your keyboard doesn't have a Scroll Lock key, you can try pressing the Function (Fn) key and the Pause/Break key at the same time.

Open the Format Cells dialog by pressing Ctrl + 1. Or, right-click any of the selected cells and choose Format Cells from the context menu. In the Format Cells dialog, go to the Protection tab, uncheck the Locked option, and click OK. This will unlock all cells in your worksheet.

To unlock the cell: On the Home tab, in the Cells group, click Format, and then click Format Control. On the Protection tab, clear the Locked check box, and then click OK.

On the Home tab, click the Format Cell Font popup launcher. You can also press Ctrl+Shift+F or Ctrl+1. In the Format Cells popup, in the Protection tab, uncheck the Locked box and then click OK.