MS Office - Excel Keyboard Shortcuts 2010

Advertisement
ad1	ad2

Here is a list of most useful and common shortcuts used in microsoft excel.
These shortcut or hotkeys will help you to work in excel at lightning speed .
Shortcut Key

Functions
F2

Edit the selected cell
F5

Goto a specific cell. For example, C6.
F7

Spell check 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

Strikethrough highlighted selection
Ctrl + P

Bring up the print dialog box to begin printing
Ctrl + Z

Undo last action
Ctrl + F9

Minimize current window
Ctrl + F10

Maximize currently selected window
Ctrl + F6

Switch between open workbooks / windows
Ctrl + Page up

Move between Excel work sheets in the same Excel document
Ctrl + Page down

Move between Excel work sheets 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 + Shif

Format number in currency format
Ctrl + Shift + #

Format number in date format
Ctrl + Shift + %

Format number in percentage format
Ctrl + Shift + ^

Format number in scientific 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
Make some difference learn all the hotkeys of other Softwares also…

Posted in: Techology,Tips and Tricks