All the Tips and Tricks posted in this blog are gathered from various web sites. We are not responsible for any damage occurred due to these posts.

My Links
Java J2EE Practise

Thursday, March 16, 2006

EXCEL SHORTCUT KEYS

Shortcut Keys
Description

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.

Ctrl + Shift + !
Format number in comma format.

Ctrl + Shift + $
Format number in currency format.

Ctrl + Shift + #
Format number in date format.

0 Comments:

Post a Comment

<< Home