Thursday, December 11, 2008

Excel short cut keys

Hi friends .. here is the list of Excel short cut keys .. make use of it and save your valuable time :)



Shortcut Keys

Description

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 + Shift + $

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.

Shortcut Keys

Description

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 + Shift + $

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.


cheers ...

shrikky :)

0 comments: