Skip to main content

Microsoft Excel Shortcuts

It is so much easier to use keyboard shortcuts than using mouse for every command. So for excel, if the shortcut keys are known it will be so much helpful. So here are the list of the shortcuts that are used in 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

Popular posts from this blog

Minecraft - Pocket Edition - $4.91 game for free

Mine Craft, a widely known game name worldwide. It is one of the most favorite games in the world. This game is now available for android mobile. Mine craft - pocket edition is all about building and surviving. This game is mostly created based on graphical blocks.  Google play store has this game up for $4.91. ETT is giving away the game absolutely for free. Download Minecraft - Pocket Edition from the bellow link. Minecraft - Pocket Edition

Download Apple Mac Theme for Windows

Most of the computer users in the world use clone PCs other than apple mac. So none of them gets the feeling of using an apple mac operating system. There is no easy way to use apple mac OS in the general clone PCs, but the user interface can be made like apple just by using this apple mac theme. This apple mac theme is very easy to install and use.  It can be installed normally.

How to create Windows 10 ISO from current installation

Microsoft Windows 10 is the most popular & need to use operating system these days. For both official and personal purposes. Each time you install a fresh windows 10 you have to install a bunch of required software. What if we could avoid that by making an ISO installation file of our own along with all of our required software already installed in it! Yup! For those who are looking for these options, this tutorial is for them. Let's find out how to create an installation media (ISO file) of Windows 10 from the current installation. To create an ISO file from the currently running Windows 10, you have to follow the below steps. 1. Download Microsoft's media creation tool. 2. Choose  Create installation media (USB flash drive, DVD, or ISO) for another PC  and hit Next . 3. Choose your preferred version of windows, architecture (32/64/amd), and language. Hit Next . 4. Choose ISO and hit Next  to start the ISO creation process. 5. Once complete, you will have an ISO ima...