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. Tab: Auto-complete functions, names, structural references. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |