Now click on the Advanced tab. Sometimes you will find yourself clicking back and forth between the cell and the formula bar while entering an editing formula. 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.
Learn some important keyboard shortcuts 1 CTRL SHIFT END To select the whole range after inserting the formula in the cell C6 press CTRL SHIFT END key on your.
Editable grids views If your administrator has enabled editable grids views you can edit data directly in a grid view. Go to the Formulas tab in the Ribbon and press the Evaluate Formula button. Select the cell where you want to show the formula instead of the value. Copy line empty selection CtrlG.