If you’re like most people, you probably use Microsoft Excel to keep track of your financial data. But if you’re like me, you also use it to fit text into the spreadsheet. There are a few different ways to do this, but the one I’m going to show you is the easiest and most common way. First, open Microsoft Excel and create a new worksheet. Then, type in a few lines of text and press enter. The first thing that will happen is that Excel will try to find all of the cells in your sheet that have text in them. If it can’t find any, it’ll just show you a list of all the cells with text in them. The next thing that will happen is that it’ll start filling in the data for those cells according to what you’ve typed into them. The first thing that’ll happen is that it’ll fill in the data for all of the cells with text in them with just basic information like their name and value. But then it’ll also add any special formatting information like bold or underline. And finally, it’ll give those cells a color so that you can see how much data they’ve got filled in! But there’s one more thing that’s going to happen before everything else: Microsoft Excel will start trying to make sure that all of your text is inside quotation marks! This means that if there’s anything inside quotation marks (like “,” or “,”), then Excel won’t let you type anything else into those cells until you remove those quotation marks!
When entering data in Excel, you’ll notice cells have limited space for displaying their contents. This can cause data to display cut off. Whether text or numbers, you can automatically resize cells to fit the contents.
You can certainly adjust the sizes of cells in columns and rows manually in Microsoft Excel. But for a quick way to shrink or expand cells to fit the text or numbers, you can use one of these easy automatic methods.
Automatically Resize Cells Using AutoFit
Microsoft Excel provides a feature called AutoFit that you can use to format cells in both columns and rows. We’ll show you how this works using an example.
Here, you can see our data is squished and unreadable for both our column headers and dollar amounts. So, we’ll expand the cells in these columns.
RELATED: How to Convert Currency in Microsoft Excel
Select the columns you want to resize. You can drag through them with your cursor or hold Ctrl as you select each one. Then, head to the Home tab and Cells section of the ribbon.
Click the Format drop-down arrow and choose “AutoFit Column Width.”
And there we go! As you can see, those columns were expanded just enough to display the contents clearly for the headers and currencies.
The AutoFit feature works the same way for shrinking the sizes of cells. Maybe you have a column of single characters, as in our example below. We can gain some space in our sheet by making the cells smaller to fit the text.
Select the column(s), click the Format drop-down arrow on the Home tab, and pick “AutoFit Column Width” as described above.
And this time, you can see our column width decreased to accommodate the contents.
You can use the AutoFit feature to shrink or expand cells in rows the same way. Simply select your row(s) and choose “AutoFit Row Height” in the Format drop-down list.
Automatically Resize Cells Using Your Cursor
Another quick and easy way to automatically resize cells in columns and rows is using your cursor.
Select the column(s) or row(s) that you want to shrink or expand to fit the contents. Place your cursor on the right side of a column or the bottom of a row. When you see the double-sided arrow display, double-click.
Just like with the AutoFit feature, you’ll see your column(s) or rows(s) adjust to fit the contents. Whether the cells shrink or expand depends on how wide the text or numbers are.
If you want to resize the cells for your entire sheet, this trick works just as easily. Select the sheet by clicking the triangle on the top left between column A and row 1. Then double-click when you see the double-sided arrows between both the columns and the rows.
Manually resizing cells in Excel to fit your contents is helpful in many situations. But to see the data that’s cut off, quickly and with minimal effort, try one of these automatic resizing options.
For another way to see your cell contents clearly, learn how to add space between text and cell borders in Excel.
