![top excel keyboard shortcuts top excel keyboard shortcuts](https://www.myexcelonline.com/wp-content/uploads/2020/03/shortcuts-bg.jpg)
![top excel keyboard shortcuts top excel keyboard shortcuts](https://support.content.office.net/en-us/media/f1365c28-b1f3-4f5a-b18b-80e5d991e693.png)
Whether calculating sums or averages, these shortcuts will help users be more efficient in formula creation and use.Ĭancel an entry in the cell or formula barĮdit the active cell and position the insertion point at the end of the lineĬalculate all sheets in all open workbooks To do this, one must understand the basics of formulas. or P.M.Īpply the number format with two decimal places, thousands separator, and minus sign (-) for negative valuesĪpply the outline border around the selected cellsĪdd an outline border to the right of the selectionĪdd an outline border to the left of the selectionĪdd an outline border to the top of the selectionĪdd an outline border to the bottom of the selectionĬancel an entry in the cell or the formula barĮdit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contentsĭisplay the Formula Builder after you type a valid function name in a formulaĮxcel spreadsheets are often used to crunch numbers. Apply the currency format with two decimal places (negative numbers appear in red with parentheses)Īpply the percentage format with no decimal placesĪpply the exponential number format with two decimal placesĪpply the date format with the day, month, and yearĬtrl + Shift + the time format with the hour and minute, and indicate A.M.