Recently, Ive run into a little problem with Excel that I can't seem to solve myself. After hours
upon hours of research, google-ing, HELP file reading, and general frustration...I absolutely can NOT find any way to disable
the Autofit feature on microsoft excel.
My office 2003 system information is as follows, just in case this
information is useful:
OS Name: Microsoft Windows XP Professional
Version: 5.1.2600 Service Pack 2 Build 2600
The reason I want to be able to turn this feature off is simple; I
like to control the size of my cells manually. I have my entire workbook set to 20x20 pixels, such that the height and width
of all cells is uniform. I like to import and export things between my workbooks, as well as from my friends' workbooks, so
we all have no difficulties with sizing our data. But when the computer decides to autofit the text and change the widths of
the columns, it skrews-up all my margins, my print areas, my borders, and generally makes everything look horrible. I
understand the premise behind the whole concept. I know how to turn autofit ON, but I can't seem to lock the size of my
cells. Even by changing the Standard Column Width, it still seems to alter the width whenever an error message like #DIV/0!
or #NAME! pops-up.
Ultimately, I want to have control over how my document looks, and I can't have that with the
sizes of my cells changing all the time. I tend to merge, unmerge, and combine cells as I need them. Autofit is not a
feature that works well with my workbooks. Perhaps there is another possibility as to why the widths of my cells keep
changing, but everything seems to point to this feature. I've managed to find an option which allows one to turn this off in
Powerpoint, but not in Excel.
Could this problem be due to a virus, spyware, or malfunctioning Add-in of some
kind? I haven't found anything malicious on my computer, and my add-ins work fine...or so it seems. But I could be wrong.
If anyone has ANY ideas on how I can lock the widths of my cells, disable Autofit, add a VBA which can let me turn it off, or
something else I'm not thinking of...please let me know. It might very well be an easy solution, but I think the aggrevation
of this process has blinded me to any quick-fixes. I'm perfectly willing to entertain anything at this point.
Thank you for any information you may have, as well as recommendations on where I might go or who I can ask to find an