Current Date : Computer Troubleshooting

Microsoft Excel shortcut keys

Posted by admin on 22nd August 2009

Shortcut Keys	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 + Shift + ;	Enter the current time.
Ctrl + ;	Enter the current date.
Alt + Shift + F1	Insert New Worksheet.
Shift + F3	Open the Excel formula window.
Shift + F5	Bring up search box.
Ctrl + A	Select all contents of the worksheet.
Ctrl + B	Bold highlighted selection.
Ctrl + I	Italic highlighted selection.
Ctrl + K	Insert link.
Ctrl + U	Underline highlighted selection.
Ctrl + 5	Strikethrough highlighted selection.
Ctrl + P	Bring up the print dialog box to begin printing.
Ctrl + Z	Undo last action.
Ctrl + F9	Minimize current window.
Ctrl + F10	Maximize currently selected window.
Ctrl + F6	Switch between open workbooks / windows.
Ctrl + Page up	Move between Excel work sheets in the same Excel document.
Ctrl + Page down	Move between Excel work sheets in the same Excel document.
Ctrl + Tab	Move between Two or more open Excel files.
Alt + =	Create a formula to sum all of the above cells
Ctrl + ‘	Insert the value of the above cell into cell currently selected.
Ctrl + Shift + !	Format number in comma format.
Ctrl + Shift + $	Format number in currency format.
Ctrl + Shift + #	Format number in date format.
Ctrl + Shift + %	Format number in percentage format.
Ctrl + Shift + ^	Format number in scientific format.
Ctrl + Shift + @	Format number in time format.
Ctrl + Arrow key	Move to next section of text.
Ctrl + Space	Select entire column.
Shift + Space	Select entire row.