IPCI Info

Shortcut Keys of MS-Excel

Shortcut Keys of MS-Excel:-
Key———————— Description
F2 ————————-Edit the selected cell
F5 ————————-Go to a specific cell
F7 ————————-Spell check selected text and/or document
F11————————Create chart
Ctrl + Shift + ;——–Enter the current time
Ctrl + ; ——————Enter the current date
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 + U —————–Underline highlighted selection
Ctrl + P —————–Bring up the print dialog box to begin printing
Ctrl + Z —————–Undo last action
Ctrl + F9 —————Minimise current workbook
Ctrl + F10 ————-Maximise currently selected workbook
Ctrl + F6 ————–Switch between open workbooks/window
Ctrl + page up ——Move between Excel worksheet in the same Excel document.
Ctrl + Page Down–Move between Excel worksheets in the same Excel document
Ctrl + Tab ————Move between two or more opennExcel 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 + Arrow key–Move to next section to text
Ctrl + Space ———Select entire column
Shift + Space——–Select entire row