It also doses full screen mode when this mode has been applied, and returns to normal screen mode to display the ribbon and status bar again.Ĭompletes a cell entry and selects the cell aboveĬopies a formula from the cell above the active cell into the cell or the formuula barĬopies the value from the cell above the active cell into the cell or the formula barĬopies values from cell above to current cellĬreates a chart of data in the current rangeĭisplays the control menu for the microsoft office excel windowĭisplays the delete dialog box to delete the selected cellsĭisplays the insert dialog box to insert blank cellsĭisplays the insert hyperlink dialog box for new hyperlinks or the edit hyperlink dialog box for selected existing hyperlinksĭisplays the macro dialog box to create, run, edit, or delete a macroĭisplays the menu or message for a smart tag. Closes an open menu or submenu, dialog box, or message window.
in cell editing mode, it deletes the character to the left of the insertion pointĪlternates between hiding objects, displaying objects, and displaying placeholders for objectsĪpplies the currency format with two decimal places (negative numbers in parentheses)Īpplies the date format with the day, month, and yearĪpplies the exponential number format with two decimal placesĪpplies the number format with two decimal places, thousands separator, and minus sign (-) for negative valuesĪpplies the outline border to the selected cellsĪpplies the percentage format with no decimal placesĬTRL + SHIFT + the time format with the hour and minute, and am or pmĪuto sum selected cells and places value in cell beneathĬalculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculationĬancels an entry in the cell or formula bar. also clears the content of the active cell. Shortcut Keyĭeletes one character to the left in the formula bar.
You can print this page or you can download here. I have listed some of the shortcut keys of Microsoft Excel below. Even users with a basic knowhow of Excel can become more efficient by learning keyboard shortcuts. Microsoft Excel is frequently used by finance and accounting professionals on a daily basis.