Just place cursor inside the range / cell address and press F4 to cycle thru all available reference styles. When typing formulas, often you may want to change a certain cell reference to Absolute or Mixed or Relative. F4: Switch reference styles – Absolute > Mixed > Relative > Absolute.
You can save a ton of time by just arrow key + tabbing. Use arrow keys to select the function, name or structural reference you want, Press Tab key to let Excel type it for you. As you start typing a formula, Excel shows auto-complete suggestions. Excel will show a list of all names and pick what you want. Whenever you want to type a name, press F3 instead. When you have a lot of names, often remembering them can be tricky. When you select a cell and press F2, Excel places cursor at the end and lets you edit the cell value / formula. So today, let us learn 5 important keyboard shortcuts that will save you a lot of time and help you write better formulas. As an analyst (or manager), I bet a good portion of your Excel time is spent writing formulas and getting the results.
