Excel Keyboard Shortcuts for Formatting Cells
Open the Format Cells dialog.
Ctrl+1
Apply or remove strikethrough formatting.
Ctrl+5
Switch between hiding objects, displaying objects, and displaying placeholders for objects.
Ctrl+6
Display or hide the outline symbols.
Ctrl+8
Open the Paste Special dialog.
Ctrl+Alt+V
Bold text or remove bold formatting.
Ctrl+B or Ctrl+2
Copy the selected cells.
Ctrl+C
Use the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
Ctrl+D
Italicize text or remove italic formatting.
Ctrl+I or Ctrl+3
Open the Insert hyperlink dialog.
Ctrl+K
Display the Create Table dialog.
Ctrl+L or Ctrl+T
Open the Delete dialog to delete selected cells.
Ctrl+Minus sign (-)
Display the Quick Analysis options for selected cells that contain data.
Ctrl+Q
Format fonts in the Format Cells dialog.
Ctrl+Shift+F or Ctrl+Shift+P
Insert a threaded comment Open and reply to a threaded comment
Ctrl+Shift+F2
Open the Workbook Statistics dialog.
Ctrl+Shift+G
Open the Insert dialog to insert blank cells.
Ctrl+Shift+Plus sign (+)
Apply an outline border to the selected cells.
Ctrl+Shift+ampersand (&)
Apply the Time format with the hour and minute, and AM or PM.
Ctrl+Shift+at sign (@)
Apply the Scientific number format with two decimal places.
Ctrl+Shift+caret sign (^)
Enter the current time.
Ctrl+Shift+colon (:)
Apply the Currency format with two decimal places (negative numbers in parentheses).
Ctrl+Shift+dollar sign ($)
Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
Ctrl+Shift+exclamation point (!)
Apply the Date format with the day, month, and year.
Ctrl+Shift+number sign (#)
Apply the Percentage format with no decimal places.
Ctrl+Shift+percent sign (%)
Apply the General number format.
Ctrl+Shift+tilde sign (~)
Remove the outline border from the selected cells.
Ctrl+Shift+underline (_)
Underline text or remove underline.
Ctrl+U or Ctrl+4
Paste content at the insertion point, replacing any selection.
Ctrl+V
Move the selected cells.
Ctrl+X
Copy a formula from the cell above the active cell into the cell or the Formula Bar.
Ctrl+apostrophe (')
Switch between displaying cell values or formulas in the worksheet.
Ctrl+grave accent (`)
Enter the current date.
Ctrl+semi-colon (;)
Edit the active cell and put the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point into the formula bar. If editing a formula, toggle Point mode off or on so you can use arrow keys to create a reference.
F2
Check spelling in the active worksheet or selected range.
F7
Insert a note Open and edit a cell note
Shift+F2
