Like us on facebook to get more free pro tricks daily...!

Liked us?

Tuesday 22 November 2011

Pin It

Shortcut function keys in excel


Here is a list of shortcut keys in Microsoft Excel.

F1: Opens a help task pane
F1 + Ctrl: Opens or closes the help window
F2: To edit the text in the active cell
F2 + Shift: To write a comment in the active cell
F2 + Alt: Opens the save as dialog box
F3 + Shift: opens the insert dialog box
F3 + Ctrl: Opens the define name dialog box

F3 + Shift + Ctrl:  Opens the create name dialog box
F4:  To redo the last command
F4 + Ctrl: To close the workbook window
F4 + Alt: To close the excel program
F5: Opens the Goto dialog box
F5 + Ctrl: brings back to the first level of workbook
F6: To shift between help taskbar and the excel window
F6 + Shift: To goto the previous square in the open worksheet
F6 + Ctrl: If more than one workbook is open to switch between them
F7: To open spelling correction window
F7 + Ctrl: When workbook window is not maximised it will move the window
F8: To activate / deactivate extended mode
F9: Will calculate all the worksheets in all open workbooks
F9 + Shift: Will calculate the active worksheet
F9 + Ctrl: To Minimise the workbook window
F10: Will select the menu bar
F10 + Ctrl: To open minimised window
F11: Will create a chart using the current range
F11 + Shift: To select a new worksheet
F11 + Alt: To switch between visual basic editor and the worksheet
F11 + Alt + Shift: Opens microsoft script editor
F12: Opens save as dialog box
F12 + Shift: Saves the active workbook
F12 + Ctrl: To open the Open dialog box
F12 + Ctrl + Shift: Opens the print dialog box

Kindly Bookmark this Post using your favorite Bookmarking service:
Technorati Digg This Stumble Reddit Facebook Twitter
Do you Like this Article..?

Get Subscribe to Free Email Updates!!

*Your email address will not be shared with anyone.



Link To This Page:


Link To Home Page:

0 Responses to Shortcut function keys in excel

Confused? Feel free to ask

Your feedback is always appreciated. We will try to reply to your queries as soon as time allows.

Note:
1. To add HTML CODE in comments then please use our HTML Encoder.
2. If you are including a link, Please include it using html tags. However irrelevant links are not tolerated.
3. Please do not spam, Spam comments will be deleted immediately after our review.

Regards,
Rupesh.

 

Total Pageviews

Translate

7TeraByte © 2012. All Rights Reserved | DMCA Protected | Back To Top