How to Modify Column Width in Microsoft Excel 2016?

Sometimes, when you enter text or numbers in Excel 2016, they don’t fit in the column. You might see cut-off words or even a row of pound signs (#######). Don’t worry — this just means the column is too narrow to display the data. The good news is that adjusting the column width is super easy!

Why Modify Column Width?

When your data doesn’t fit properly, it not only looks messy but can also make your sheet hard to read. By resizing columns, you can:

• Make all content visible.
• Improve readability of your spreadsheet.
• Keep your layout organized and professional.

Methods to Change Column Width in Excel 2016

1. Using Your Mouse (Quick and Easy)

This is the most common way to adjust a column’s width.

• Step 1: Move your mouse pointer to the top of the worksheet where the column letters are (like A, B, C, etc.).
• Step 2: Hover over the line between two column headers. The cursor will turn into a double-headed arrow.
• Step 3: Click and drag to the right to make the column wider, or to the left to make it narrower.
• Step 4: Release the mouse when the width looks good.

2. AutoFit Column Width (Automatic Adjustment)

AutoFit automatically resizes a column to fit the content perfectly.

• For one column: Double-click the line between two column headers.
• For multiple columns: Select them first, then double-click the boundary between any two selected columns.

3. Using the Ribbon (Set Exact Width)

If you want more control, you can set a specific column width using the Ribbon.

• Step 1: Select the column(s) you want to modify.
• Step 2: Go to the Home tab.
• Step 3: Click Format in the Cells group.
• Step 4: Choose Column Width from the list.
• Step 5: Enter a number (for example, 20) and click OK.

4. Using Keyboard Shortcuts (For Fast Users)

If you prefer using the keyboard, Excel 2016 offers quick shortcuts:

• AutoFit Column Width: Select the column(s) and press Alt + H + O + I.
• Set Specific Width: Select the column(s) and press Alt + H + O + W.

Extra Tips for Better Formatting

• Use AutoFit for data that changes often.
• Adjust manually when working with text-heavy columns.
• Keep columns uniform for cleaner presentations.

5 FAQs on Modifying Column Width in Excel 2016

1. Why do pound signs (#######) appear in my Excel cell?

They appear when the column is too narrow to display the number. Widen the column to fix it.

2. What is the quickest way to fit content in a column?

Double-click the column boundary — Excel will AutoFit it instantly.

3. Can I adjust multiple columns at once?

Yes, select all the columns you want to resize and drag or use the AutoFit option together.

4. Is there a way to set all columns to the same width?

Yes, select all columns and set a specific width using Home > Format > Column Width.

5. Do these methods work in other Excel versions?

Yes, these steps work in Excel 2013, 2019, 2021, and Microsoft 365 as well.

Conclusion

Modifying column width in Excel 2016 is an essential skill for keeping your data organized and readable. Whether you prefer using your mouse, Ribbon, or keyboard shortcuts, you now know multiple ways to do it. The next time your text looks squeezed or hidden, just adjust the width — and your spreadsheet will look neat and professional again.