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.
Learn how to hide your Disk Drive.
0 comments:
Post a Comment