Nov 21, 2007 Re: Column width problem in excel remc0 Nov 21, 2007 6:47 AM ( in response to Tim Dexter-Oracle ) Hi Tim, I just saw the excel analyze is working.
Afternoon all. I'm running into a really weird issue here. We have one user experiencing issues with a spreadsheet that was emailed to him.
Myself and two others have opened this spreadsheet and we do not have any problems with it. The user with the issues is seeing a lot of ###### inside columns within the spreadsheet.
This to me indicated that the columns are not wide enough. Sure enough, I expand all the columns and everything is fine.
This wouldn't be a problem if this worksheet wasn't 10 pages with a ton of columns. Needless to say, I don't want to have to tell my CEO to manually adjust these every time, while others can just open it and it has no problems for them.
Does anyone have any suggestions? I could not find anything in my searches.
Any help would be greatly appreciated. Things I've Tried: Checked screen resolution to make sure we are all on the same (we are). Checked the magnification level within excel (same as ours). Checked Excel options item by item.
I saw this problem recently and this was the solution. What is his screen resolution set to? New excel sheets workbooks defaulting to 13.20. Unable to set the row height to 12.75 manually. Setting it to this makes it 12.8 when hovered over and if you go into the row height settings it states the height to be 12.6. I was able to reproduce the problems on my PC last week - screen resolution was 125%.
In Screen Resolution it was set to Zoom in at 125%. Reset this and problem went away. Here is some info on column width and height. Change the column width and row height On a worksheet, you can specify a column width of 0 (zero) to 255.
This value represents the number of characters that can be displayed in a cell that is formatted with the standard font. The default column width is 8.43 characters. If a column has a width of 0 (zero), the column is hidden. You can specify a row height of 0 (zero) to 409. This value represents the height measurement in points (1 point equals approximately 1/72 inch or 0.035 cm). The default row height is 12.75 points (approximately 1/6 inch or 0.4 cm). If a row has a height of 0 (zero), the row is hidden.
If you are working in Page Layout view (View tab, Workbook Views group, Page Layout button), you can specify a column width or row height in inches. In this view, inches are the measurement unit by default, but you can change the measurement unit to centimeters or millimeters (On the File tab, click Options, and then click the Advanced category).
On a worksheet, you can specify a column width of 0 (zero) to 255. This value represents the number of characters that can be displayed in a cell that is formatted with the standard font.
The default column width is 8.43 characters. If a column has a width of 0 (zero), the column is hidden. You can specify a row height of 0 (zero) to 409.
This value represents the height measurement in points (1 point equals approximately 1/72 inch or 0.035 cm). The default row height is 12.75 points (approximately 1/6 inch or 0.4 cm). If a row has a height of 0 (zero), the row is hidden. If you are working in Page Layout view (View tab, Workbook Views group, Page Layout button), you can specify a column width or row height in inches.
In this view, inches are the measurement unit by default, but you can change the measurement unit to centimeters or millimeters (On the File tab, click Options, and then click the Advanced category). Here is some info on column width and height. Change the column width and row height On a worksheet, you can specify a column width of 0 (zero) to 255. This value represents the number of characters that can be displayed in a cell that is formatted with the standard font. The default column width is 8.43 characters. If a column has a width of 0 (zero), the column is hidden. You can specify a row height of 0 (zero) to 409.
This value represents the height measurement in points (1 point equals approximately 1/72 inch or 0.035 cm). The default row height is 12.75 points (approximately 1/6 inch or 0.4 cm). If a row has a height of 0 (zero), the row is hidden. If you are working in Page Layout view (View tab, Workbook Views group, Page Layout button), you can specify a column width or row height in inches. In this view, inches are the measurement unit by default, but you can change the measurement unit to centimeters or millimeters (On the File tab, click Options, and then click the Advanced category). On a worksheet, you can specify a column width of 0 (zero) to 255.
This value represents the number of characters that can be displayed in a cell that is formatted with the standard font. The default column width is 8.43 characters. If a column has a width of 0 (zero), the column is hidden. You can specify a row height of 0 (zero) to 409. This value represents the height measurement in points (1 point equals approximately 1/72 inch or 0.035 cm). The default row height is 12.75 points (approximately 1/6 inch or 0.4 cm). If a row has a height of 0 (zero), the row is hidden.
If you are working in Page Layout view (View tab, Workbook Views group, Page Layout button), you can specify a column width or row height in inches. In this view, inches are the measurement unit by default, but you can change the measurement unit to centimeters or millimeters (On the File tab, click Options, and then click the Advanced category).
Drezriel, Have you tried seeing how his Excel handles column width in a regular Excel sheet? Like starting a fresh sheet and see if it auto-fits when you enter in some text into A1. I just tried it on mine, and the columns all auto-fit automatically when I enter in 10 characters.
![Excel auto column width Excel auto column width](https://cdn.extendoffice.com/images/stories/doc-excel/doc-lock-cell-width-and-height/xdoc-lock-cell-width-height-3.png.pagespeed.ic.MjrzefzKNb.png)
It'd be interesting to see if it auto-fits or not. Because if it does auto-fit, his installation of Excel may just not like that workbook in particular, and if it doesn't auto-fit either, there is something different about his Excel-what that difference could be, I haven't a clue, but it sounds like you haven't found it yet either. Regardless, it might be quicker and easier to just reinstall/repair his Office.