Skip to main content

19 MS Excel Shortcuts You Must Know

Important Microsoft Excel Shortcuts

If you work in an office, it's quite hard to run away from Microsoft Excel. Whether you're tracking costs in Finance, putting together a marketing plan or maintaining a list of sales contacts, chances are you'll be using Excel to do these tasks. 

So, to help you go home on time, here are 19 of the most useful Excel shortcuts that every analyst must know.



Navigation
CTRL+ARROW KEY Moves to the edge of the current data region in a worksheet. Useful if you want to reach the last row or column of a worksheet.
SHIFT+ARROW KEY Extends the selection of cells by one cell. Use it to select multiple cells in a small region at a time.
CTRL+SHIFT+ARROW KEY Extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell. Use it to select a row or column of cells within a longer row/column.
CTRL+PgUp Switches between worksheet tabs, from left-to-right.
CTRL+PgDn Switches between worksheet tabs, from right-to-left.

Formatting
CTRL + A Selects the entire worksheet.

If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its summary rows. Pressing CTRL+A a third time selects the entire worksheet.
CTRL+B Applies or removes bold formatting.
CTRL+U Applies or removes underlining.
CTRL+I Applies or removes italic formatting.
CTRL+C Copies the selected cells.
CTRL+X Cuts the selected cells.
CTRL+V Pastes the copied/cut cells including formatting.
ALT + E + S + V Paste values only.
ALT + E + S + T Paste formats only.

One fast way to get rid of formulas is to use a ALT + E + S + V followed by an ALT + E + S + T combo.
CTRL+Y Repeats the last command or action, if possible.
CTRL+Z Uses the Undo command to reverse the last command or to delete the last entry that you typed
CTRL+SHIFT+~ Applies the General number format
CTRL+SHIFT+$ Applies the currency format to 2 d.p.
CTRL+SHIFT+% Applies the Percentage format with no decimal places.

While these may seem like only short time savers, because we spend so much time on Excel, the little things add up. By using shortcut keys instead of clicking the toolbar, you will find that your efficiency and speed improves by leaps and bounds. Simply press two or three key combos on the keyboard rather than having to move your hand to the mouse, move the mouse, and click several times.

It may seem daunting to learn so many shortcuts at once. Well... don't panic! Start by incorporating three to five new shortcuts into your daily routine per day. With experience, you'll get more confident and can start to incorporate even more new short cuts.
Labels:

Comments

  1. Anton ListovNovember 11, 2016 at 1:30 PM

    Glad you found it useful, Jhon. Look out for more tips soon!

    ReplyDelete

Post a Comment

Popular posts from this blog

How to View YouTube Shorts in the Regular YouTube Player

YouTube's "Shorts" is YouTube’s answer to TikTok and Instagram reels but let’s be honest, the YouTube Shorts player lacks some functionality, such as the ability to fast forward and go back in the video. However, you might be surprised to know that every video that loads in the "Shorts" player is actually a regular video, and by changing the URL slightly, you can load the same video in the regular player along with all the functionality of a traditional YouTube video. Changing the URL Changing the URL is the easiest way to switch the player from a technical standpoint. It’s so easy even your grandma can do it, as long as she knows how to type an address into the address bar of a browser.   Let’s use this super popular short video about AI taking over ping pong as an example. Look in the URL bar of a video playing in the "Shorts" player, where you should see the text Shorts/. Replace that text with watch?v= and load the new URL. So in this
Post a Comment
Read more

How To Change Bluetooth Name On Android

This post will take you step-by-step through the process of changing the Bluetooth name of your devices on an Android phone. There are pictures as references in case you get lost along the way. Change Bluetooth Name On Android | Step-by-step 1. Unlock your Android phone and go to Settings Unlock your phone and click on the Settings Icon It goes without saying, but the first thing you need to do is unlock your phone. By default, the settings icon will be on your home page like in the picture above. If you don't have the settings icon, you can search for 'Settings' in the Android search bar. 2. In the Settings page, click on Bluetooth Click on the Bluetooth settings to open up the Bluetooth Settings menu Click on the Bluetooth settings which should be at the top of your Settings page. If it doesn't, scroll down till you find it or just search for it in the search bar at the top of the Settings page. 3. Click On Device Name To Change Your Phone's Bluetooth Name Click o
Post a Comment
Read more

Microsoft Project Oxford: Machines That Recognize Human Emotion

One of the things that separate humans from machines is that we're able to recognize and distinguish between different emotions when we interact with others. With advances in Artificial Intelligence (AI), Machine Learning and computing power in general, apps and programs are being created that are able to recognize speech, identify faces and now even distinguish between different emotions!
Post a Comment
Read more