All the definitions on AZdictionary were written by people just like you. Now's your chance to add your own!
1 In Excel, select â File â and click Save As. 2  Choose â Tools General Options â at the bottom of the window. 3  Select the check-box for â Read-only recommended â, then select â OK 4  â. Select â Save 5  â. If prompted, choose â Yes â to update the file with the read-only setting.f you have a file that is sensitive to changes, you can force Excel 2013 or 2010 to prompt the user to open as Read Only whenever they attempt to open the file. Hereâs how to enable this setting. 1  In Excel, select â File â and click Save As. 2  Choose â Tools General Options â at the bottom of the window.
Select the original cell that contains the correct reference and click in the formula bar or press F2 to edit the formula. Image courtesy of Microsoft. Select the section of the formula that contains the reference you want to change. For example, in the formula =A1&B1, select either A1 or B1..Press F4 to change the reference type. Each time you press F4, Excel advances through a cycle of four options: B1, $B$1, B$1 and $B1. To make the reference fully absolute, set the equation to $B$1.mage courtesy of Microsoft. Select the section of the formula that contains the reference you want to change. For example, in the formula =A1&B1, select either A1 or B1.. Press F4 to change the reference type. Each time you press F4, Excel advances through a cycle of four options: B1, $B$1, B$1 and $B1.