Applies or removes underlining in Microsoft Excel. 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. Displays the Delete dialog box to delete the selected cells.Įnters the current date. Shortcut CTRL SHFT Plus ( ) CTRL+Minus (-)Ĭommand Displays the Insert dialog box to insert blank cells in Microsoft Excel. Copies the value from the cell above the active cell into the cell or the Formula Bar.

In a PivotTable, it selects the entire PivotTable report.Įnters the current time. Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). 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. Applies the Exponential number format with two decimal places.ĬTRL+SHFT+# the Date format with the day, month, and year. Applies the Currency format with two decimal places (negative numbers in parentheses).Īpplies the Percentage format with no decimal places. Applies the General number format in Microsoft Excel. Removes the outline border from the selected cells. Applies the outline border to the selected cells. Unhides any hidden columns within the selection. Unhides any hidden rows within the selection. CTRL+SHFT+( CTRL+SHFT+) CTRL+SHFT+& CTRL+SHFT_ CTRL SHFT ~ CTRL+SHFT+$

Copy formatting shortcut in excel