excel keyboard shortcut for filling down

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.

Excel keyboard shortcut for filling down