How to Fit Data in Excel

Nothing brings your data analysis to a halt faster than cells that cut off your text or display a confusing mess of pound signs. When your data doesn't fit correctly in Excel, it makes your spreadsheets hard to read, messy to share, and nearly impossible to print presentably. This guide will walk you through all the essential methods to perfectly fit your data in Excel, from quick automatic adjustments to precise manual controls.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Does Data Get Cut Off in Excel?

Before jumping into the solutions, it helps to understand the common culprits behind poorly fitting data. This usually happens for one of two reasons:

• Column width is too narrow: This is the most frequent issue. If a column isn't wide enough to display its entire contents, Excel will handle it in a couple of ways. For text, it will either overlap into the adjacent cell to the right (if it's empty) or get cut off. For numbers and dates, it will display a series of pound signs (e.g., #######), which is Excel's way of telling you there's a value there, but you can't see it all.
• Row height is too short: This typically happens when you have multiple lines of text within a single cell (using wrap text). If the row height isn’t tall enough, you’ll only see the top line or two of the text, hiding the rest of the information.

Fixing these formatting issues is not just about making your sheet look tidy. It's about ensuring data accuracy and readability, especially when reports are shared with team members or stakeholders who need to understand the information at a glance.

Solution 1: The Quickest Fix with AutoFit

Excel's AutoFit feature is your go-to tool for a fast and easy solution. It automatically adjusts the width of a column or the height of a row to perfectly match the size of its largest entry. Think of it as the "one-click" fix for most fitting problems.

AutoFit a Single Column or Row

This is the method you'll probably use most often. It’s incredibly fast and intuitive.

1. Move your mouse cursor to the right border of the column header you want to resize (e.g., the line between column B and C).
2. Your cursor will change from a white cross to a black double-sided arrow.
3. Double-click this border.

Instantly, the column will snap to the perfect width needed to display the longest piece of data within that column.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

AutoFit Row Height

1. Move your cursor to the bottom border of the row header you want to resize (e.g., the line between row 2 and 3).
2. Once your cursor changes to the double-sided arrow, double-click it.

The row height will adjust to fit all the lines of text in its cells.

AutoFit Multiple Columns or Rows at Once

If you have several columns or your entire sheet needs resizing, doing it one by one is a waste of time. Here’s how to do them all in one go.

1. Select the columns or rows you want to AutoFit by clicking and dragging across their headers.
2. To select all columns on the sheet, click the triangle icon in the top-left corner (at the intersection of the row and column headers) or press Ctrl + A (Cmd + A on Mac).
3. Move your cursor to the border of any of the selected column or row headers.
4. Double-click the border.

Every column or row you selected will simultaneously snap to its optimal size.

Solution 2: Gaining More Control with Manual Adjustments

Sometimes AutoFit doesn't give you the exact look you want. Perhaps it makes one column extremely wide because of a single long entry, throwing off the visual balance of your sheet. In these cases, manual adjustments give you a finer degree of control.

Drag to Resize

This is the manual version of double-clicking. Instead of double-clicking the column or row border, simply click and hold, then drag it left/right or up/down to your desired size. A tooltip will show you the exact width (in characters and pixels) or height (in points and pixels) as you drag.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Set a Specific Width or Height Numerically

For uniform formatting, you can set an exact size for one or more columns or rows.

1. Select the column(s) or row(s) you want to adjust.
2. Right-click on any of the selected headers.
3. From the context menu, choose Column Width... or Row Height...
4. A small dialog box will pop up. Enter a number representing the size you want (e.g., 25 for column width or 30 for row height).
5. Click OK.

This is perfect for creating tables where C-level executives want every column to be uniform width regardless of their cell contents as well as to keep your data organized visually.

Solution 3: Fitting Long Text with “Wrap Text”

What if you want to keep your column width fixed but have a lot of text in a cell, like a long note or description? Instead of letting it get cut off, you can use Wrap Text. This feature breaks up the text into multiple lines within the same cell, automatically increasing the row height to accommodate it.

Here’s how to apply it:

1. Select the cell or range of cells containing the long text.
2. Go to the Home tab on the Ribbon.
3. In the Alignment group, click the Wrap Text button.

Your text will now be fully visible within the cell's borders. Remember, after wrapping text, you might need to AutoFit the row height by double-clicking the row border to ensure the entire multi-line text is displayed.

Solution 4: An Alternative to Wrapping - "Shrink to Fit"

Shrink to Fit offers a different approach to the same problem. Instead of increasing the row height, this feature automatically reduces the font size of the text within a cell until it fits inside the existing column width and row height.

This is useful when you want to avoid changing your carefully set row heights but still need to see all the data. Use it with caution, as very long entries might become too tiny to read.

To enable Shrink to Fit:

1. Select the cell(s) you want to format.
2. Right-click and choose Format Cells... (or press Ctrl + 1 on Windows / Cmd + 1 on Mac).
3. In the Format Cells dialog box, go to the Alignment tab.
4. Under Text control, check the box for Shrink to fit.
5. Click OK.

The text will now automatically resize as you change the column width, ensuring it never gets cut off.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Bonus Tip: Forcing Data to Fit on a Printed Page

Often, the end goal is to print your report. Excel’s "Scale to Fit" options are a game-changer for this.

Before you print, go to the Page Layout tab. Look for the Scale to Fit group. Here, you have a few powerful options:

• Width: Drop this down and select "1 page" to force all your columns onto a single printed page. Excel will automatically scale everything down to make it fit.
• Height: Similarly, you can force all rows onto a specific number of pages.
• Scale: If you want more granular control, you can shrink the entire sheet by a specific percentage (e.g., 90% of its normal size).

This setting only affects the printed output, not the on-screen view, so it’s a non-destructive way to get your report picture-perfect on paper.

Final Thoughts

Mastering how to fit data is a fundamental Excel skill that transforms cluttered spreadsheets into clean, professional reports. By using a combination of AutoFit for speed, manual adjustments for precision, and text controls like Wrap Text or Shrink to Fit, you can ensure your data is always presented clearly and effectively.

Constantly adjusting columns and exporting CSVs just to build a readable report is a daily frustration for many teams. We built Graphed because we believe getting insights shouldn't involve fighting with spreadsheets. Instead of wrangling cells, you can connect your data sources and simply ask for what you need - like, "show me website traffic by country as a line chart" - and get a live, interactive dashboard in seconds. You get to skip straight to the insights and leave the formatting headaches behind.