Home  • Software Application • Microsoft Excel

Some Excel Shortcut

Excel Shortcut 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

Comments 1


Tnx....

Share

About Author
Md. Sohel Arman
Copyright © 2024. Powered by Intellect Software Ltd