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.

Comments

  1. Thanks for sharing this excel shortcuts.It is really useful.Continue sharing more like this.
    Regards,
    Excel Advanced Training | MS excel Training in Chennai | Excel Macro Training in chennai

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

      Delete

Post a Comment

Popular posts from this blog

Best Cables for 144Hz Monitors - DisplayPort

144Hz monitors have a few different inputs, like DisplayPort , Dual-link DVI and HDMI to choose from, but which is the most recommended one? We've definitely come a long way from the days when monitors offered only a single VGA port. This article will explain which is the recommended port and type of cable to use for your 144Hz monitor.

Big Home Routers | Best WiFi Routers for a 4000 sq ft House

One of the great frustrations of living in a large or multi-story house is that a single Wi-Fi router isn't able to cover the entire house. Even homes around 2,000 square feet in size are likely to be plagued by Wi-Fi dead spots. If you'd like to say goodbye to terrible Wi-Fi, this guide will explain what Wi-Fi mesh is - one of the most exciting router technologies to emerge in recent years and also highlight what are some of the best mesh routers on the market today.

44 Best Free Responsive Blogger Templates

One of the most important decisions you can make when starting your blog or site is it's theme design or template. Your site's them not only sets the mood for your readers, but also plays a big part in SEO, multi-device usability and social-sharing, all of which play a big part in determining the success of your blog. Unfortunately, the default options available in Blogger have not been refreshed, looking like they're from the early 00's. Not to worry - many HTML and CSS designers have stepped in to fill the void with custom theme designs being made available for Blogger. We've trawled through the newer offerings to bring you 44 terrific free Blogger templates  - check them out!