Simple Excel Shortcuts that will make your life easier

×

SEARCH FOR

Input your search keywords and press Enter.

Life

Simple Excel Shortcuts that will make your life easier

22-Jan-2021
By WufPerry

Excel is one of the greatest invention that supposed to help us to manage large sets of data in a quickest and most efficient way.

Sometimes using the mouse to select or edit data could be time-consuming. Some shortcuts will definitely save your precious minutes as well as helping you to manage your worksheet in a much easier way.


1. Auto Sum (Alt + =)

The quickest way to sum up the numbers instead of manually inserting =sum() formula

https://image.goody25.com/images/catalog/60376/20210122_16113074877601_mobile.jpg

2. Fill the cell

Still using Copy (Ctrl + C) & Paste (Ctrl +V)? Or fill handle (small square in the bottom-right corner of the selected cell)?

Here are some of the alternatives to fill the cell, either with value or formula:

a. Ctrl + D (Down) or Ctrl + R (Right)

https://image.goody25.com/images/catalog/60376/20210122_16113074879422_mobile.jpg

Repeat the same way by using Ctrl + R if you wish to fill the cell to the right!


b. Ctrl + Enter

https://image.goody25.com/images/catalog/60376/20210122_16113074880903_mobile.jpg

c. (Ctrl + Alt + V) or (Alt + E + S)

If you wish to paste the copied cell as special value/format, you may use this shortcut instead of selecting from the paste button in the menu bar

https://image.goody25.com/images/catalog/60376/20210121_16112380811261_mobile.jpg

3. Columns / Rows

Selecting rows and columns is one of the most frequent tasks when managing data sets. Mastering a few shortcuts below will definitely save yourself the hassle!

https://image.goody25.com/images/catalog/60376/20210121_16112384482411_mobile.jpg

4. Table / Formatting

a. Filter (Ctrl + Shift + L)

https://image.goody25.com/images/catalog/60376/20210122_16113074882624_mobile.jpg

b. Cell Format (Ctrl + 1)

https://image.goody25.com/images/catalog/60376/20210121_16112394194141_mobile.jpg

c. Insert Comment (Shift + F2)
https://image.goody25.com/images/catalog/60376/20210121_16112395427091_mobile.jpg


5. Formats

https://image.goody25.com/images/catalog/60376/20210121_16112396498071_mobile.jpg

6. Conditional Functions

You might already be familiar with Sum, Count, Average functions. What if we combine them with "If" function?

https://image.goody25.com/images/catalog/60376/20210121_16112389020361_mobile.jpg


BONUSSSSS:

Try (Ctrl + ; ) or (Ctrl + : ) on any empty cell and see what appeared!


From now on, start to minimize the usage of your mouse and be a keyboard Excel pro!


Microsoft excel tips tricks shortcuts simple easy hacks computer master


WufPerry

Hi, thank you for visiting!

Report

Trending


Malaysians Can Now Check Their Unclaimed Money From The Government Online

Finance   29-Jan-2021

WATCH: Father Brings Out Iron Rod & Ready To Hit The Referee When His Son Gets A Red Card In Football

Trending   1 Week ago

Angry Man Accidentally Spits On Himself While Attempting To Spit On A Woman In Road Rage Incident, Netizens Amused

Trending   2 Days ago