Unhides any hidden rows within the selection.Some of the shortcut keys may be assigned to your desktop system. Unhides any hidden columns within the selection. Applies the outline border to the selected cells. Removes the outline border from the selected cells. Applies the General number format in Microsoft Excel. Applies the Currency format with two decimal places (negative numbers in parentheses).Īpplies the Percentage format with no decimal places.

Applies the Time format with the hour and minute, and AM or PM.Īpplies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.Īpplies the Exponential number format with two decimal places.ĬTRL+SHFT+# the Date format with the day, month, and year. Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable, it selects the entire PivotTable report.Įnters the current time. Copies the value from the cell above the active cell into the cell or the Formula Bar. Shortcut CTRL SHFT Plus ( ) CTRL+Minus (-)Ĭommand Displays the Insert dialog box to insert blank cells in Microsoft Excel. #MICROSOFT EXCEL 2016 SHORTCUT KEYS AND FORMULAS PDF PLUS# Displays the Delete dialog box to delete the selected cells.Įnters the current date. Alternates between displaying cell values and displaying formulas in the worksheet.Ĭopies a formula from the cell above the active cell into the cell or the Formula Bar.ĬTRL+1 CTRL+2 CTRL+3 CTRL 4 CTRL+5 CTRL+6ĭisplays the Format Cells dialog box. Applies or removes underlining in Microsoft Excel. Alternates between hiding objects, displaying objects, and displaying placeholders for objects.ĭisplays or hides the outline symbols.

Hides the selected columns in Microsoft Excel. #MICROSOFT EXCEL 2016 SHORTCUT KEYS AND FORMULAS PDF PLUS#.

Formula pdf excel shortcut keys