|
|
You can do this too
Download "The one essential add-in for all Excel users."
“Working in Excel will be fun again with all these extra supersmart tools”
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 |
 - 750px - ribbon.png "Download ASAP Utitilities")
Download ASAP Utilities
Follow ASAP Utilities on Facebook
© 1999-2018 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands
Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
