Microsoft Excel shortcut keys-1

Action	Excel shortcut
Alternates between displaying cell values and displaying formulas in the worksheet.	CTRL+`
Alternates between hiding objects, displaying objects, and displaying placeholders for objects.	CTRL+6
Applies or removes bold formatting	CTRL+2
Applies or removes bold formatting	CTRL+B
Applies or removes italic formatting	CTRL+3
Applies or removes italic formatting	CTRL+I
Applies or removes underlining	CTRL+4
Applies or removes underlining	CTRL+V
Applies the Currency format with two decimal places	CTRL+$
Applies the Date format with the day, month, and year	CTRL+#
Applies the Exponential number format with two decimal places	CTRL+^
Applies the General number format	CTRL+~
Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values	CTRL+!
Applies the outline border to the selected cells	CTRL+&
Applies the Percentage format with no decimal places	CTRL+%
Applies the Time format with the hour and minute, and AM or PM	CTRL+@
Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation	CTRL+ALT+F9
Calculates all worksheets in all open workbooks	F9
Calculates the active worksheet	SHIFT+F9
Closes and reopens the current task pane	CTRL+F1
Closes the selected workbook window	CTRL+F4