Microsoft Excel Shortcut Keys [you can use]

Microsoft Excel Shortcut Keys

 Some of the most useful shortcut keys of Microsoft Word are listed below

Mouse shortcuts

Shortcut	Description
Double-click (on a cell)	Edit the cell contents.
Double-click (on a row/column divider)	Adjust height/width to auto-fit
Triple-click	Select the entire contents in the cell
Click on row/column divider then drag	Adjust height/width of the row/colunn
Ctrl + Mouse wheel	Zooms in and out of document.
Hold Shift + Click the cells	Select multiple cells

Keyboard shortcuts

Shortcut		Description
F2		Edit the selected cell.
F5		Goto a specific cell. For example, C6.
F7		Spell check selected text and/or document.
F11		Create chart.
Ctrl + A		Select all.
Ctrl + B		Bold.
Ctrl + C		Copy.
Ctrl + F		Find (same as Shift + F5).
Ctrl + G		Go To.
Ctrl + H		Replace.
Ctrl + I		Italic.
Ctrl + K		Insert link.
Ctrl + N		New Workbook.
Ctrl + O		Open Workbook.
Ctrl + P		Print dialog.
Ctrl + S		Save.
Ctrl + U		Underline.
Ctrl + V		Paste.
Ctrl + Z		Undo.
Ctrl + Y		Redo.
Ctrl + X		Cut.
Ctrl + 5		Strikethrough text.
Ctrl + F3		Define Name.
Ctrl + F4		Exit Excel.
Ctrl + F6		Switch between open workbooks.
Ctrl + F9		Minimize current window.
Ctrl + F10		Maximize current window.
Shift + F1		Activate Help on Item.
Shift + F2		Insert Comments
Shift + F3		Insert Function.
Ctrl + Shift + ;		Enter the current time.
Ctrl + ;		Enter the current date.
Ctrl + Page down		Move to next worksheet.
Ctrl + Page up		Move to previous worksheet.
Ctrl + Shift + #		Number Format: Date
Ctrl + Shift + @		Number Format: Time.
Ctrl + Shift + !		Number Format: Commas.
Ctrl + Shift + $		Number Format: Currency
Ctrl + Shift + %		Number Format: Percentage
Ctrl + Shift + ^		Number Format: Scientific.
Ctrl + Space		Select entire column.
Shift + Space		Select entire row.
Ctrl + (Arrow key)		Move to next section.

Posted in: