Shortcut Keys of MS-Excel and their Descriptions
F2 – Edit the selected cell.
F5 – Go to a specific e.g., C6
F7 – Spell chech 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 – Strike through highlighted selection.
Ctrl + P – Bring up the print dialog box to begin printing.
Ctrl + Z – Undo last action.
Ctrl + F9 – Minimize current workbook.
Ctrl + F10 – Maximize currently selected workbook.
Ctrl + F6 – Switch between open workbooks/windows.
Ctrl + Page up – Move between Excel worksheets in the same Excel document.
Ctrl + Page down – Move between Excel worksheets 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 time format.
Ctrl + Arrow key – Move to next section of text.
Ctrl + Space – Select entire column.
Shift + Space – Select entire row.
