Home Screenshots 10 Languages Why use it?

Tip of the Day | Thursday March 5th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Find Columns Showing #### Errors (Too Narrow)

This tool checks your active worksheet for columns that are too narrow to display numbers or dates in full.

When a column is too narrow, Excel shows crosshatches (####) in the cell instead of the actual value.
This tool helps you quickly find those issues, so that you can fix them before printing, exporting, or sharing your file.

How it works:

It scans your worksheet for cells displaying #### due to column width.

When it finds a cell that is too narrow, it shows a message telling you which column and cell are affected and that cell is selected.

You can then choose to continue searching or fix the issue immediately.

This is useful when you want to:

Quickly find and correct columns with #### errors

Ensure all numbers and dates are fully visible

Prepare a clean and readable worksheet

Note:
This tool only detects problems with numbers and dates that can't be displayed in full due to narrow columns.
Cut-off text values are not detected, because Excel does not show an error when text is too long.

Starting this tool

Click ASAP Utilities › Info & List › 18. Find Columns Showing #### Errors (Too Narrow)
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Info & List › Find Columns Showing #### Errors (Too Narrow)

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Today's Tip

Download

©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.