Tip: If you want to enable or disable the display formulas for the entire worksheet in one go, you can use CTRL + Grave Accent (`) shortcut. Now, using the mouse to switch to Formula tab and then enabling ‘Show Formulas’ can consume quite some effort as compared to a gentle pressing of F2 key on the keyboard. There are several reasons for which you need to look at the formula for the cell including suspecting the value displayed. You can use Function key F2 to show the formula for the active cell. Here are some of the Excel shortcuts that every accountant must know: 1. However, by learning some tricks and shortcuts of the tool, you can save some quality time and be more efficient. It not only maintains the data in an organized and structured form but also adds pace to calculations and deployment of special functions.Īccounting professionals spend a significant amount of time on Excel due to the number of operations that it can deliver. Maintaining and working on spreadsheets is a necessity for every accounting professional, for which Microsoft Excel is among the most preferred software. Update: This article was last updated on 11th Mar 2019 to reflect the accuracy and up-to-date information on the page.
0 Comments
Leave a Reply. |