The BEST Excel Shortcut

Zach October 16, 2020

I have another Excel shortcut for you. This is my favorite Excel shortcut. If I had to pick only one, this would be it. WATCH NOW

Zach DeGregorio

www.WolvesAndFinance.com

Want to chat with me live? I have daily live streams on my gaming YouTube channel. I stream every day at 5:00pm Phoenix Time except on Saturday 10:30am. https://www.youtube.com/channel/UCyA6hunVgBiE3QEDn9GpQtw

VIDEO SUMMARY

Has this ever happened to you? You are working with an Excel spreadsheet and the numbers get too wide to fit in the cell. So you end up with number signs. This happens all the time if you are working with spreadsheets in accounting. So what you need to do is widen the column until all the number fit.

The typical way you would do this, is to grab the top of the column and drag. An easier way, is you can actually double click on the edge of the column and it will auto-size for you.

But I am going to give you an even easier way by using a keyboard shortcut. Excel makes this very easy. You can get to any button on the ribbon, using a shortcut. All you need to do is start with pressing “Alt”.

When you press “Alt” you will notice a series of letters show up at the top of your window. This is telling you what key to press next in sequence depending on what tab of the ribbon you want. We are going to press “H” for Home. Then the next series of letters show up depending on where you want to go. And you can keep pressing letters until you get to the command you want.

In our case, we want to autofit the column width to the numbers. Normally, this is in a drop down menu at the top of the ribbon, that takes a couple of mouse clicks to get to. With the correct cell selected, you can just use the shortcut “Alt + H O I” . It is super easy to remember. It is also easy to press because all the letters are very close together.

So whenever you get these numbers on your spreadsheet. Just put the cursor in the cell, and press Alt + H O I and it will automatically resize the column to the correct width.

Over all the years I have used Excel, this has saved me so much time and mouse clicks I can’t even count. I hope you find this helpful. Go out and have fun on your Excel projects.

Leave a comment down below letting me know what you think!

If you find these videos helpful, please subscribe to my YouTube channel.

Neither Zach De Gregorio or Wolves and Finance shall be liable for any damages related to information in this video. It is recommended you contact a CPA in your area for business advice.

Categories: General
Zach
Zach De Gregorio has worked in most accounting positions from bookkeeping, to writing financial statements, to Chief Financial Officer (CFO). Zach has an active CPA license since 2015. Zach De Gregorio began his studies at the University of Southern California in Los Angeles where he received a Bachelor Degree in Cinema and Business. He also holds a M.B.A in Finance from Arizona State University. Zach went on to complete a Master’s Certificate in Project Management from George Washington University and a Master of Accounting Degree from the University of New Mexico. Zach lives in Phoenix, AZ and enjoys trail-running in the beautiful southwest landscape.

Related Articles

Report

Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .