shortcut keys of excel

Here are some shortcut keys of excel which are very helpful for you....

Ctrl+Z-----> Undo
Ctrl+C------> copy

Enter-------> paste
Ctrl+V-------> Multiple Paste
Ctrl+X-----> Cut

Ctrl+F--------> Find
Ctrl+H--------> Find&Replace

Ctrl+P--------> Print
Ctrl+S--------> Save
Ctrl+F4--------> Close
Alt+F4---------> Close Excel

Ctrl+Arrow------> Move to edge of region

Ctrl+*----------> Select current region

Ctrl+A---------> Select All Cells

Ctrl+Home-------> Select A1
Ctrl+End--------> Select last cell in used range
Ctrl+Shift+End---> Select from active cell to last cell in used range.
Ctrl+Shift+Home---> Select from active cell to A1
Ctrl+Page Down----> Move to the next sheet
Ctrl+Page Up-----> Move to the previous sheet
Ctrl+Tab---------> Move to next open workbook

Ctrl+N----------> Open new workbook
Shift+F11-------> Insert new worksheet
Shift+F3---------> Paste function window

=+FunctionName+Ctrl+A-------> Insert new function
Alt+F11---------------> Open VBE
Ctrl+Shift+Enter--------> Array formula
Ctrl+F3----------> Define Name
F3--------------> Paste Name

Ctrl+Spacebar-----------------> Select columns
Shift+Spacebar----------> Select rows

Ctrl+1 ---------------> Format cells
Ctrl+B ----------------> Bold
Ctrl+U------------------> Underline
Ctrl+; -----------------> Current date
Ctrl+shift+:-------------> Current time


No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: