Tag: ##### error

Last updated: June 2025

Are you seeing ##### symbols, cut-off text, or missing numbers in your Excel spreadsheet? This frustrating display issue occurs when your column is too narrow to show the complete content. Don't worry – this comprehensive guide will show you exactly how to fix narrow columns in Excel and prevent this problem from happening again.

What Causes Excel Columns to Display Incorrectly

When Excel can't display your data properly, you'll typically see:

• Hash symbols (#####) instead of numbers or dates
• Truncated text that gets cut off mid-word
• Missing decimal places in financial data
• Compressed date formats that become unreadable

This happens because Excel prioritizes preserving your data integrity over forcing it into spaces that are too small. Instead of corrupting your information, Excel shows these visual indicators that more space is needed.

Method 1: Auto-Fit Columns (Fastest Solution)

Double-Click Method

The quickest way to fix column width issues:

1. Locate the column border between the column headers (the line between column A and B, for example)
2. Position your cursor over the right edge of the column header until you see a double-headed arrow (↔)
3. Double-click the border
4. Excel will automatically resize the column to fit the widest content

Auto-Fit Multiple Columns

To fix several columns at once:

1. Select the columns you want to resize by clicking and dragging across column headers
2. Right-click on any selected column header
3. Choose "Column Width" from the context menu
4. Click "Best Fit" or use the keyboard shortcut Alt + H + O + I

Auto-Fit All Columns

To resize every column in your worksheet:

1. Select all data by pressing Ctrl + A or clicking the triangle in the top-left corner
2. Double-click any column border while all columns are selected
3. All columns will automatically adjust to their optimal width

Method 2: Manual Column Width Adjustment

Drag-and-Drop Resizing

For precise control over column width:

1. Click on the column header to select the entire column
2. Hover over the right border of the column header until you see the resize cursor
3. Click and drag the border to your desired width
4. Release the mouse when you reach the optimal size

Set Specific Column Width

To set an exact width measurement:

1. Right-click the column header you want to resize
2. Select "Column Width" from the menu
3. Enter your desired width (measured in characters)
4. Click OK to apply the change

Pro Tip: Standard column width is 8.43 characters. For most text content, 12-15 characters works well, while financial data might need 10-12 characters.

Fixing Specific Content Types

Long Numbers and Financial Data

Financial data often triggers the ##### error because of:

• Decimal places requiring extra space
• Negative numbers needing space for parentheses or minus signs
• Currency symbols adding width requirements

Solution: Set column width to at least 12 characters for currency, or use auto-fit and add 2-3 extra characters of padding.

Date and Time Formatting

Dates can display incorrectly when columns are too narrow because:

• Full date formats (January 1, 2025) need more space than short formats (1/1/25)
• Time stamps require additional width for hours, minutes, and seconds

Solution: Either widen the column to accommodate the full format, or change to a shorter date format via Format Cells.

Long Text Entries

Text handling in narrow columns:

• Wrapped text flows to multiple lines within the cell
• Overflow text spills into adjacent empty cells
• Truncated text gets cut off if adjacent cells contain data

Solution: Use auto-fit or enable text wrapping via Format Cells > Alignment > Wrap Text.

Advanced Column Width Techniques

Setting Default Column Width

To change the default width for new columns:

1. Go to Format menu > Column > Default Width
2. Enter your preferred default width
3. Click OK to apply to all new columns

Keyboard Shortcuts for Quick Resizing

• Alt + H + O + I: Auto-fit column width
• Alt + H + O + W: Open Column Width dialog
• Ctrl + Space: Select entire column
• Shift + Space: Select entire row

Using Format Painter for Consistent Widths

1. Select a column with your desired width
2. Click Format Painter in the Home tab
3. Click other column headers to apply the same width

Preventing Future Column Width Issues

Best Practices for Column Setup

• Plan your data types before entering information
• Set appropriate column widths during initial setup
• Use consistent formatting throughout your spreadsheet
• Test with sample data to ensure adequate width

Template Creation

Create templates with pre-set column widths for common data types:

• Text columns: 15-20 characters
• Number columns: 10-12 characters
• Date columns: 12-15 characters
• Currency columns: 12-15 characters

Troubleshooting Common Issues

Auto-Fit Not Working

If auto-fit doesn't work properly:

• Check for hidden characters or extra spaces in your data
• Verify merged cells aren't interfering with column borders
• Look for very long entries that might be skewing the auto-fit calculation

Columns Keep Reverting to Narrow Width

This usually indicates:

• Template or formatting issues with the spreadsheet
• Shared workbook settings that restrict column modifications
• Protected worksheet that prevents column width changes

Performance Issues with Large Spreadsheets

When working with thousands of rows:

• Avoid auto-fitting entire columns with massive datasets
• Set manual widths for better performance
• Use filtering to work with smaller data sections

Mobile and Web Excel Considerations

Excel Mobile Apps

Column width adjustment on mobile devices:

• Tap and hold column borders to resize
• Use pinch gestures for quick width adjustments
• Access Format menu for precise width settings

Excel Online (Web Version)

Browser-based Excel has similar functionality:

• Double-click borders for auto-fit
• Right-click headers for width options
• Use keyboard shortcuts for faster navigation

Summary: Quick Reference Guide

Fastest fixes:

1. Double-click column border for auto-fit
2. Drag column border for manual adjustment
3. Right-click > Column Width for precise control

Prevention strategies:

• Set appropriate default widths
• Plan column sizes during setup
• Use templates for consistent formatting
• Test with realistic data samples

Remember: Excel's ##### display isn't an error – it's a helpful indicator that your content needs more space. With these techniques, you can quickly resolve display issues and create professional-looking spreadsheets that properly showcase your data.

By mastering column width management, you'll save time, reduce frustration, and create more readable Excel documents that effectively communicate your information to others.