Tuesday Tip: Save Time in Excel with Autofit

When starting a new excel spreadsheet, columns are set to a standard width of 8.43. Simply put: you’ve only got so many characters you can type into cells before you start seeing something like this:

It is easy to manually widen those cells so you can see the data, but by using a very basic macro the columns can autofit on the fly as you enter and subtract data.

FYI: A macro is an embedded command in excel that automates tasks in the spreadsheet. Note – sometimes your ‘IT’ department will disable macros in office products as they can be used to distribute malicious code, so check with your IT team if you aren’t able to get this to work.

  1. Right click on the sheet tab at the bottom and select View Code
  2. A new window will pop up called Microsoft Visual Basic for Applications
    • Select Worksheet in the first drop down menu
    • In the area below that, type: Cells.EntireColumn.AutoFit

Close out of that window once you have entered the code. This command is now embedded in your sheet, so as you populate data into cells, Excel will automatically adjust the width of your columns to fit the data you are entering.

If you are dealing with lots of data, this can be a great time saver.

Richard Stokes: As the Director of Sales for Network 1, Richard identifies “future” clients that can benefit from the support of an experienced, outsourced IT team. He helps clients and prospects find technology solutions they need to achieve better productivity and efficiency so they can focus on making money and growing their businesses.

Network 1 designs, builds and supports the IT you need to run your business more securely, productively and successfully. Whether you want to outsource all of your IT needs to a reliable, responsive, service-oriented company, or need to supplement the work of your internal IT staff, we will carefully evaluate where you are now, discuss where you want to go and implement and support a plan to get you there with as little interruption as possible.

Leave a Comment

Related Posts