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.
0 Comments
Leave a Reply. |