Trending
  • How To Save Youtube Videos On iPhone
    How To Save Youtube Videos On iPhone
  • Protect Your Privacy on WhatsApp with These Useful Tips
    Protect Your Privacy on WhatsApp with These Useful Tips
  • Top 10 Best Free PDF Editor Softwares For Windows
    Top 10 Best Free PDF Editor Softwares For Windows
  • How to Create A Safe And Strong Password
    How to Create A Safe And Strong Password
  • Security Settings You Should Have on Your iOS 10 Device

    Security Settings You Should Have on Your iOS 10 Device

    The security setting you either need to turn off or on are only a few taps away. You won't have to go through a sea of settings jut to get to it. Let's get to it and secure your iOS 10 device!

    Read more...

  • How You Can Keep Your WiFi Safe

    How You Can Keep Your WiFi Safe

    Even if having to deal with WiFi security is a real pain for some, it is something that needs to attention. Someone could steal your WiFi and use it for who knows what and cross your fingers that it is not for anything illegal.

    Read more...

  • What You Should Keep in Mind Before Buying a Used Smartphone

    What You Should Keep in Mind Before Buying a Used Smartphone

    As long as the phone works fine and has what you need, who care if it's not this years model. So, you've decided that the best thing you can do is buy a used phone. Before you go phone shopping, there are some things you need to keep in mind before you buy.

    Read more...

  • The Most Effective Ways to Get More Followers on Instagram

    The Most Effective Ways to Get More Followers on Instagram

    Before you give up and think about closing your Instagram account, there are some tips and tricks on how to increase your Instagram followers you should know about. By following these tips,...

    Read more...

  • How to Make a GIF From a Video (Windows, Mac, iOS, Android)

    How to Make a GIF From a Video (Windows, Mac, iOS, Android)

    ver the certain period of time, GIF images have gained so much popularity, and you can see them on the Social Networking websites. In the comments section of a website or your Twitter timeline, GIF is actually an animated image format which is created from different images or videos.

    Read more...

  • How to Take Great Pictures with Your Android Device

    How to Take Great Pictures with Your Android Device

    When was the last time you used a digital camera to take a picture? It's probably been a while, right? Most of us used our smartphone to take a million pictures of our pets or of that beautiful sunset you were lucky enough to see.

    Read more...

  • The Best iPhone 7 Tips and Tricks You're Probably Not Using

    The Best iPhone 7 Tips and Tricks You're Probably Not Using

    iOS offers an endless amount of great features you can enjoy, but you may not be taking advantage of them because you might not even know they exist or are too afraid you'll mess something up by tampering with it.

    Read more...

Become The Best Excel User with These Useful Guide

Become The Best Excel User with These Useful Guide

7.0/7 rating 1 vote

Some people might be intimidated when they hear the Word, Excel. This can be because they imagine all those cells and all those options than only end up confusing most people. If you open Excel on your own without reading a how-to guide like this one, of course, it can seem overwhelming but trust me, it's not as hard as it may look.

Select All Cells with one Click

If you've used Excel at least once, you may already be familiar with the Ctrl + A way of selecting everything. You can always do that, but there's an easier way, and all you have to do is click the corner button like in the image below.

useful guide excel

How to Open Various Excel Files Simultaneously

Opening one file at a time can be time-consuming, especially if you're in a hurry to meet a deadline. You can quickly open various files at the same time by first, selecting them all and then by just pressing the Enter button. That's it!

Add Shortcuts to the Top Menu

You can work a lot faster when you have easy access to all the tools you need and don't have to waste time searching through the see of option Excel has to offer. Save time and create a shortcut to what you use the most by clicking on the upside down pyramid right next to undo in the upper left-hand corner and selecting More Commands.

useful guide excel

​Now, you should be able to see the Excel option you can create a shortcut for, and now it's up to you to select what you want to add, choose add and see it appear in the options like in the image below.

useful guide excel

​Don't forget to click on OK once you're done to save your options and to check if it was added correctly, check the upper left-hand corner for the icon of what shortcut you decided to add.

How to Add a Diagonal Line in a Cell

If you're making some sort of list, you may need to create a diagonal line, maybe to keep different columns and rows apart. To create a diagonal line, go to the Home tab and the click on the Font settings.

useful guide excel

​I know it may seem weird going to the Font if you want to add a diagonal line, but this is where you find what you're looking for. Now, click on the Border Tab, and that is where you will find your diagonal line.

useful guide excel

useful guide excel

​Keep an Eye on Your Data with a Watch Window

If you need to keep an eye on how a change you make on a cell value will affect other dependent cells, the last thing you want to do is to keep scrolling up and down. Keep things simple by creating a Watch Window. To create this window, you need to click on the Formulas tab and then select Watch Window. A small window will appear and when it does click on Add.

useful guide excel

Once you've added your windows, you will never lose site of your data.

Quickly Copy and Move Data in Cells

There may come a time when you are going to need to move either a cell and its data or copy the complete information in a cell elsewhere. You can easily do this by placing the cursor on the side of a cell until the cursor turns into arrows pointing in every direction. Once this happens, left-click and drag the cell to where you want it to appear. If you want to copy the information in the cell elsewhere, press Ctrl and without letting go drag the cell to where you want to paste the information.

How to Delete Blank Rows

Blank rows are not always useful and sometimes ned to be erased. If that is your case, there is an easier way of deleting the empty rows than erasing them one by one. The first thing you need to do is select the text that contains the blank rows you want to get rid of.

useful guide excel

​Go to Find and Select and in the drop-down menu select Go to Special.

useful guide excel

​Select Blanks and click Ok.

useful guide excel

​Now all the empty rows are going to be chosen and now is where you're going to delete them. Go to Delete in the Cells section.​

useful guide excel

You should now be blank row free, but if what you need is to remove sheet columns, you can repeat the process but choose Delete Sheet Columns.

How to Add the Information of Various Cells Into One

If you need to add text from other cells to a single cell, you can easily do that by using the equal sign and the & sign. For example, I have the days of the week in the B2, B4, and the B6 cell. I want to add those days into the F8 cell. For this to work, I would need first to insert the equal sign into the F8 cell and then separate each cell that I want to add with the & sign, like in the image below.

useful guide excel

​Once you have this setup, press enter and you will get this.

useful guide excel

​Conclusion

As you can see, Excel has a lot to offer, but you can learn everything you need to know if you learn things one step at at time. What's your favorite Excel tip or trick? Let me know in the comments.


Latest

  • Security Settings You Should Have on Your iOS 10 Device
    Security Settings You Should Have on Your iOS 10 Device
  • How You Can Keep Your WiFi Safe
    How You Can Keep Your WiFi Safe
  • How to Hide Pictures, App Icons and Files on Android
    How to Hide Pictures, App Icons and Files on Android
  • What You Should Keep in Mind Before Buying a Used Smartphone
    What You Should Keep in Mind Before Buying a Used Smartphone
  • 10 Best Backpacks for College Students
    10 Best Backpacks for College Students
  • Top 5+ Best Point and Shoot Digital Camera
    Top 5+ Best Point and Shoot Digital Camera

Author

Judy Sanhz
Judy Sanhz

I can never get enough of tech in general, whether it's Android or web apps, but helping others solve their tech problems also brings great satisfaction. I carry a device wherever I go and I'm always connected. Life without Internet just sounds too scary to me. :-).

comment

Leave a comment

You are commenting as guest.

Recent Comment

doesn't work -- using 10.12.1

bc tried several times including cd'ing to /

bernard 03. December, 2016 |

Great article

I run Directory Report as an administrator
That way it can find hidden file
http://www.file-utilities.com

It can...

Allan Man 23. November, 2016 |

This article is best google chorme are install.This extensions are help different email autuomatically introduce to user. This is must...

Tilly Wilson 10. November, 2016 |

About Website

OMG!HOWTO is a technology website where we cover the latest from Apple, Facebook, Microsoft and Tips & Tricks. We seek to present fresh news, useful tips, tutorials, applications that the modern technology user will appreciate. OMGHOWTO.COM is powered by Joomla.

0
Shares
0
Shares