ASAP Utilities, description of our Excel tools

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

Information » Find too narrow columns (####)

This utility will inspect your worksheet for columns that are too narrow to display the contents.
When a column is too small to display a number or date, Excel will show cross hatches (####) in the cell instead of the actual value.
Especially when your worksheet contains a lot of data then this utility can be useful.

Remark:
The utility only reports columns that are too small to display numbers or dates.

Starting this utility

In the Excel menu choose: ASAP Utilities » Information » Find too narrow columns (####)

« Return to the list of “Information” tools.

« Previous
Find bad cell references (#REF!)

Next »
Display your screen resolution

You can do this too

Download "The one essential add-in for all Excel users."

Printer friendly page

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at: