Microsoft Excel 2010 keyboard shortcuts

Excel 2010 Keyboard Shortcuts

Ctrl combination shortcut keys Key	Description	Key	Description
CTRL+PgUp	Switches between worksheet tabs, from left-to-right.	CTRL+SHIFT+Plus (+)	Displays Insert dialog box to insert blank cells.
CTRL+PgDn	Switches between worksheet tabs, from right-to-left.	CTRL+Minus (-)	Displays Delete dialog box to delete selected cells.
CTRL+SHIFT+(	Unhides hidden rows within the selection.	CTRL+;	Enters current date.
CTRL+SHIFT+&	Applies outline border to selected cells.	CTRL+'	Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+SHIFT_	Removes outline border from selected cells.	CTRL+1	Displays Format Cells dialog box.
CTRL+SHIFT+~	Applies General number format.	CTRL+2	Applies or removes bold formatting.
CTRL+SHIFT+$	Applies Currency format with two decimal places (negative numbers in parentheses).	CTRL+3	Applies or removes italic formatting.
CTRL+SHIFT+%	Applies Percentage format with no decimal places.	CTRL+4	Applies or removes underlining.
CTRL+SHIFT+^	Applies Scientific number format with two decimal places.	CTRL+5	Applies or removes strikethrough.
CTRL+SHIFT+#	Applies Date format with day, month, and year.	CTRL+6	Alternates between hiding and displaying objects.
CTRL+SHIFT+@	Applies Time format with the hour and minute, and AM or PM.	CTRL+8	Displays or hides the outline symbols.
CTRL+SHIFT+!	Applies Number format with two decimal places, thousands separator, and minus sign (-) for negative values.	CTRL+9	Hides selected rows.
CTRL+SHIFT+*	Selects current region around active cells. In PivotTables, it selects entire PivotTable reports.	CTRL+0	Hides the selected columns.
CTRL+SHIFT+:	Enters the current time.	CTRL+A	Selects entire worksheet.
CTRL+`	Alternates between displaying cell values and displaying formulas.	CTRL+SHIFT+A	Inserts argument names and parentheses when insertion point is to the right of function names in formulas.
CTRL+SHIFT+"	Copies value from cell above an active cell into the cell or the Formula Bar.	CTRL+B	Applies or removes bold formatting.