Translate this page

Tuesday, April 19, 2011

Microsoft Excel shortcuts


0 comments


Many professional uses the Microsoft excel for their work. Microsoft Excel makes their work easy and fast and easy to understand. It is used by the number of people in this world. Microsoft Excel uses the table to collecting the data and mange these data. It will be more easy when the people who uses the Excel know its shortcuts.
Many useful shortcuts are given below. They are described with their functions.





F5
Go to a specific excel cell
F11
Create the chart
F2
Edit selected cell
F7
Spell check for selected text
Ctrl+;
Enter current date.
Ctrl+Shift;
Enter current time.
Shift +F3
Open the formula window.
Shift +F5
BringUp search box.
Alt +Shift+F1
New worksheet insertion.
Ctrl +Page down
Move between Excel worksheets.
Ctrl +page up
Move between Excel worksheets.
Alt+=
Create formula for sum all above cells
Ctrl+tab
Move beteen two Open Excel files.
Ctrl +’
Insert the value of above cell into currently selected cell
Ctrl +shift +$
Format number in Currency format
Ctrl +shift +!
Format number in comma format
Ctrl +shift +#
Format numbers in date format
Ctrl +shift +@
Format number in time format
Ctrl +shift +^
Format number in scientific formats
Ctrl +shift +%
Format in percentage format
Shift +space
Entire row selection
Ctrl+space
Entire column selection
Ctrl +F6
Switch between open windows/workbooks.
Ctrl +f10
Maximize selected window
Ctrl +f9
Minimize current selected window
Ctrl +5
Strike through highlighted portion
Ctrl +P
Open print dialog box
Ctrl +z
 Undo last action
Ctrl+B
Bold selected text
Ctrl+A
Select all contents
Ctrl +I
Italic selected text.
Ctrl+k
 Insert link.
Ctrl +U
Underline selected portion.

just bookmark this page and enjoy your work in excel. it will be very helpful for you....
Learn how to hide your Disk Drive.

0 comments:

Post a Comment

Subscribe

Subscribe to get free email updates...

Delivered by FeedBurner

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Grants For Single Moms
Facebook RSS Feed Twitter Delicious Digg Stumbleupon Favorites More