How to get rid off #### entries in excel???
General November 29th, 2007
If an entry in a particular cell is too long, its value will be displayed as bunch of hash keys (#####). This is not an error and you can get around this problem by using the “Autofit selection” feature of excel. This can be found under “Column” tab of “Format”
drop down menu. Autofit selection option will expand the column to the size of the longest entry. If you want to expand all the columns then just press(Ctrl+A) to select the whole data and press(Alt+O+C+A) which is the shortcut for the Autofit selection option.
Popularity: 8%
nice to know