logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel 365, 2021, 2019, 2016, 2013, 2010 or 2007 with ASAP Utilities in its menu

Find too narrow columns (####)

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

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 tool

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

Download
Find bad cell references (#REF!)



Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us