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.
For example, if you record a command, such as clicking the AutoSum button to insert a formula that adds a range of cells, Excel records the formula by using R1C1 style, not A1 style, references. You can turn the R1C1 reference style on or off by setting or clearing the R1C1 reference style check box under the Working with formulas section in the Formulas category of the Options dialog box.