Some Useful Different - Different Shortcut keys for Microsoft Excel by Keyboard


Excel is a spreadsheet program from Microsoft Office; this component is office product group for Business application.. Excel is automated version of the paper base spreadsheet that makes it easier to manipulate process and view the data. Microsoft excel is spreadsheet application that enable to manipulate and graph data. Excel application is the most used and widely available spreadsheet application.
  

(I)- Navigation in worksheets and selecting cell

Excel worksheet have 16,777,216 cells in 2003. These are divided in to 65,536 rows and 256 columns.

There are some shortcut keys of navigation in worksheet and selecting.

Tab                -      Select the next Element.
Esc            -     Exit /Close any open dialog box.
Up Arrow      -      jump the down to up cell.
Down Arrow        -    jump the Up to Down cell.
Left Arrow   -       jump the Right to left cell.
Right Arrow  -       jump the Left to Right cell.
Shift+Tab          -      Select the previous Element.
Ctrl + A     -       Select the all paragraph and figures
Ctrl+ C        -       Copy the select the paragraph.
Ctrl+ V     -        Paste the content of the clipboard.
Delete        -        Delete the select      paragraph.
Ctrl+ X      -        Cut the select         shape.
Shift+Delete    -        Also Cut the select     shape.
Shift+ Right Arrow-Select the Horizontal shape Large.
Shift+ Left Arrow-Select Horizontal shape Reduce.
Ctrl+ Z  -        Undo the last action.               
Ctrl+ F2 -        Open the print preview.
Backspace       -     Delete the left character.
Shift+ Up Arrow  - Select the Vertical shape in Large.
Shift+ Down Arrow -Select Vertical shape in Reduce.

(II)- Smart – Art Graphics : Work with Text



A smart-Art graphics is a visual representation of your information that you can quickly and easily create, choosing from among many different layouts, to effectively communicate your message or ideas.

There are some shortcut keys of Smart-Art Graphics.

Left Arrow       - Move one character to the left.
Right Arrow     -        Move one character to the right.
Ctrl+ Right Arrow  -        Move one Word to the right.
Ctrl+ Up Arrow   -        Move the one paragraph up.
Ctrl+ Down Arrow -    Move the one paragraph down.
End                       -        Move to the end of a line.
Home           -        Move to the beginning of the line.
Ctrl+ End      -        Move to the end of a text box.
Ctrl+ Home   -    Move to the beginning of a text box.
Ctrl+ X          -        Cut Select Line/paragraph/Text.
Ctrl+ C           -        Copy selected Text/paragraph.
Ctrl+ V        -        Paste the selected text.
Ctrl+ Z               -        Undo the last action.
Ctrl+ Y            -        Redo the repeat action.
Backspace         -        delete one character to left.
Ctrl+ Backspace -        Delete one word to the left.
Up Arrow       -        Move the up first line.
Delete           -        Delete one character to the right.
Ctrl+ Delete       -        Delete one word to the right.
Down Arrow              -        Move the down one line.
Ctrl+ Left Arrow     -        Move one Word to the left.

You can suggest me anything related to this post, so I can improve this post better. Sent your suggesting in comment box, if you want to mail me please go on contact page. You can share and like this post so others and like this post so others is benefited by this post.

No comments:

Post a Comment

Blogger Widget