Microsoft Excel is a software package. It is a spreadsheet application created and designed by Microsoft Corporation. It is capable of performing calculations and creating charts. I have given below the shortcuts for Microsoft Excel. In your top of your keyboard 12 function keys are available that are f1 to f12. We can write simple coding in Microsoft excel using the Visual Basic Editor. Extension of the excel document is .xls. In Microsoft excel we cannot open the same named documenets at a time. It will show you an error, the named document already opened. We can learn some shortcuts in the following. 

Excel Shortcuts for more efficient working

Edit the Cell

If you wish to edit the selected cell f2 function key is used. 

Go to Specified Cell

In Excel 65536 rows and 256 columns available. If you wish to go for a specified cell, you can use the shortcut f5. Press F5. Enter C6 for example if you wish to go to c6 cell.

Spell Checker

F7 function key is used for checking the spelling of the selected text or document. 

Creation of Chart

F11 function key is used for creation of chart in Microsoft Excel.

Insertion of Current time

If you wish to insert the current time, use Ctrl+Shift+; then time will be inserted. (Ctrl- Control, ;-Semicolon)

Insertion of Current Date

If you wish to insert the current date, use Ctrl+; then date will be inserted.

Insertion of New Worksheet

If you wish to insert the new worksheet, use Alt+Shift+F1 then new worksheet will be inserted in your excel document. 

Excel Formula Window

Shift + F3 is used to open the formula window for your excel document.

Search Box

Shift + F5 is used for bring up the search box for your excel document.

Select all content

Ctrl + A is used for select everything in the document.

Bold

Ctrl + B is used for making your text in bold of your excel document. 

Italics 

Ctrl + I is used for making your text in Italics of your excel document.

Underline

Ctrl + U is used to underline your text of your excel document.

Link 

If you wish to insert the link for your excel document, Ctrl+k Key combinations are used. 

Strike Through the Text

Ctrl + 5 is used for Strike through your highlighted text in Microsoft Excel. 


Like it on Facebook, +1 on Google, Tweet it or share this article on other bookmarking websites.

Comments (0)

There are no comments posted here yet