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
Labels:

Popular posts from this blog

Freelance Writing: How to Build a Career as a Blogger

Freelance writing is a great way to build a career as a blogger. If you have a passion for writing and a desire to work from home, freelance writing can be a rewarding and lucrative career. In this guide, we'll cover the steps you need to take to build a successful career as a freelance blogger. Step 1: Choose a niche The first step in building a career as a freelance blogger is to choose a niche. Identify a topic that you are passionate about and that has a market demand. Research your niche and identify your target audience. Make sure your niche is broad enough to provide a steady stream of writing opportunities. Step 2: Build your portfolio The next step is to build your portfolio. Create a blog and write articles on your chosen niche to showcase your writing skills. Use platforms like Medium, LinkedIn, or guest posting to expand your reach and build your brand. Make sure your portfolio showcases your best work and highlights your expertise. Step 3: Network and pitch The third s...
Post a Comment
Read more

YSense: A Legitimate Way to Make Money Online

There are plenty of ways to make money online, but not all of them are legitimate. Some require you to pay a fee to get started, while others promise big earnings but never deliver. That's why it's important to do your research before signing up for any online money-making opportunity. One website that has been around for several years and has a good reputation in the industry is YSense. What is YSense? YSense, formerly known as ClixSense, is an online rewards website that allows users to make money by completing surveys, offers, and tasks. The website was founded in 2007 and has since paid out over $39 million to its members. YSense operates in over 200 countries and has over 7 million registered members. How does YSense work? To get started with YSense, all you need to do is sign up for an account. Once you've created an account, you can start earning money by completing surveys, offers, and tasks. Surveys are typically the highest paying activity on YSense, and you can e...
Post a Comment
Read more

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
Post a Comment
Read more