Tips & Insights

Tips & Insights provides advice on and examples of technology used to simplify and streamline IR activities, as well as real world examples of visual displays of data (e.g., charts, graphs, maps, tables, pictures). These eAIR features are developed by members.

Did you know there are many keyboard shortcuts built into Microsoft Office that can save you time and make your life easier? It’s time to get friendly with your Control key!

Here are 25 “Ctrl and” functions for Word and Excel to get you started.

Shortcut	Key	Excel	Word
Add today’s date	;	X
Add the current time	:	X
Reset formatting of selection	[space]		X
Select entire column	[space]	X
Set number format to Percentage	%	X
Set number format to Date	#	X
Set number format to Currency	$	X
Reset number format to General	~	X
Change a Range into a Table	T	X
Add cells, rows, or columns (select a row/column to add)	+	X
Delete cells, rows, or columns (select a row/column to delete)	-	X
Decrease font size	[		X
Increase font size	]		X
Paste Special	Alt-V	X	X
Add an outline border	&	X
Remove an outline border	_	X
Fill down	D	X
Insert hyperlink	K	X	X
Hide selected rows*	9	X
Use superscript*	+		X
Add or remove line spacing before paragraph*	0		X
Print preview	Alt-I		X
Insert a page break	Enter		X
Copy formatting	Shift-C		X
Paste formatting	Shift-V		X

* These use the main keys, not those on the numeric keypad.

Back to Tips & Insights