QuickTip: Excel AutoFit

Courtesy of: Chase Petersen, Network 1 Sales Operations Associate

When entering data into an Excel sheet, oftentimes the cells need to be adjusted in order for all of the data to be visible. Instead of manually adjusting the size of each cell, there is a shortcut that will automatically resize each cell in the sheet to display your data.

First, click on the triangle in the upper-left corner of the sheet. This will highlight the entire sheet. Then, double-click the border between a cell to adjust either the height or width. Excel will automatically adjust the height or width of every cell in the sheet to the size of the largest cell contained in the row or column.


Chase Petersen: Chase works at Network 1 as a Sales Operations Associate, where he partners with clients to learn their needs and provide thoughtful recommendations on how to meet each one. He is a graduate of Kennesaw State University where he earned his degree in Economics and Political Science.

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