Computer Important Shortkey

Computer Important Shortkey 

What is the function of CTRL A to Z?

• Ctrl + A - Select All
• Ctrl + B - Bold 
• Ctrl + C - Copy
• Ctrl + D - Fill
• Ctrl + F - Find
• Ctrl + G - Find next instance of text
• Ctrl + H - Replace
• Ctrl + I - Italic
• Ctrl + K - Insert a hyperlink
• Ctrl + N - New workbook
• Ctrl + O - Open
• Ctrl + P - Print
• Ctrl + R - Nothing right
• Ctrl + S - Save
• Ctrl + U - Underlined
• Ctrl + V - Paste
• Ctrl + W - Close
• Ctrl + X - Cut
• Ctrl + Y - Repeat
• Ctrl + Z - Cancel

• F1 - Help
• F2 - Edition
• F3 - Paste the name
• F4 - Repeat the last action
• F4 - When entering a formula, switch between absolute / relative references
• F5 - Goto
• F6 - Next Pane
• F7 - Spell Check
• F8 - Extension of the mode
• F9 - Recalculate all workbooks
• F10 - Activate Menubar
• F11 - New graph
• F12 - Save As

• Ctrl + : - Insert the current time
• Ctrl + ; - Insert the current date
• Ctrl + " - Copy the value of the cell above
• Ctrl + ' - Copy the formula from the cell above

• Shift - Offset Adjustment for Additional Functions in the Excel Menu

• Shift + F1 - What is it?
• Shift + F2 - Edit cell comment
• Shift + F3 - Paste the function into the formula
• Shift + F4 - Search Next
• Shift + F5 - Find
• Shift + F6 - Previous Panel
• Shift + F8 - Add to the selection
• Shift + F9 - Calculate the active worksheet
• Shift + F10 - Popup menu display
• Shift + F11 - New spreadsheet
• Shift + F12 - Save

• Ctrl + F3 - Set name
• Ctrl + F4 - Close
• Ctrl + F5 - XL, size of the restore window
• Ctrl + F6 - Next Workbook Window
• Shift + Ctrl + F6 - Previous Workbook Window
• Ctrl + F7 - Move window
• Ctrl + F8 - Resize Window
• Ctrl + F9 - Minimize the workbook
• Ctrl + F10 - Maximize or Restore Window
• Ctrl + F11 - Inset 4.0 Macro sheet
• Ctrl + F1 - Open File

What is the function of Alt key?

• Alt + F1 - Insert a graph
• Alt + F2 - Save As
• Alt + F4 - Output
• Alt + F8 - Macro dialog
• Alt + F11 - Visual Basic Editor
• Ctrl + Shift + F3 - Create a name using the names of row and column labels
• Ctrl + Shift + F6 - Previous Window
• Ctrl + Shift + F12 - Printing
• Alt + Shift + F1 - New spreadsheet
• Alt + Shift + F2 - Save
• Alt + = - AutoSum
• Ctrl + `  - Toggle value / display of the formula
• Ctrl + Shift + A - Insert the argument names in the formula
• Alt + down arrow - automatic view list
• Alt + '  - Format Style Dialog
• Ctrl + Shift + ~  - General Format