When you enter a value in cell A1 for example. In the Find and Replace dialog box within the replace tab enter in the Find what field and in the Replace with field. Equal Toggle the formula reference style between absolute relative and mixed T or F4.
Go to the File tab and under this go-to options.
If you want to always edit cells in the formula bar even when you use a keyboard shortcut to edit a cell youll need to change a setting. You can use the following keyboard shortcuts to increase your productivity and to streamline creating formulas in the formula editor. Equal Toggle the formula reference style between absolute relative and mixed T or F4. At first this post answers this but unfortunately F10 redues the volume.