Is there a max width the column can be in excel. I have a worksheet and it has a column width of 69.71 and will not open anymore unless I double click....the row height is 165.75. There is more text in the field but if you widen it then close the worksheet when you open it back up you can not see all the text. Any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Column Width
- Thread starter Santee
- Start date
VulcanJedi
Technical User
I tried XL and it says the cell max can't be more than (409x255)?
You could write a macro to establish your sizes to maintain them since they seem to lose the values?
Sub CellSize()
Cell(your row, your col).RowHeight = YOUR SIZE
Cell(your row, your col).ColumnWidth = YOUR SIZE
End Sub
Tranpkp
************************************
- Let me know if this helped/worked!
Please remember to give helpful posts the stars they deserve!
This facilitates navigating through the threads / posts!
You could write a macro to establish your sizes to maintain them since they seem to lose the values?
Sub CellSize()
Cell(your row, your col).RowHeight = YOUR SIZE
Cell(your row, your col).ColumnWidth = YOUR SIZE
End Sub
Tranpkp
************************************
- Let me know if this helped/worked!
Please remember to give helpful posts the stars they deserve!
This facilitates navigating through the threads / posts!
- Thread starter
- #3
VulcanJedi
Technical User
Excel specifications and limits
Worksheet and workbook specifications
Feature : Maximum limit
Open workbooks : Limited by available memory and system resources
Worksheet size : 65,536 rows by 256 columns
Column width : 255 characters
Row height : 409 points
Page breaks : 1000 horizontal and vertical
Length of cell contents (text): 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.
Tranpkp
************************************
- Let me know if this helped/worked!
Please remember to give helpful posts the stars they deserve!
This facilitates navigating through the threads / posts!
Worksheet and workbook specifications
Feature : Maximum limit
Open workbooks : Limited by available memory and system resources
Worksheet size : 65,536 rows by 256 columns
Column width : 255 characters
Row height : 409 points
Page breaks : 1000 horizontal and vertical
Length of cell contents (text): 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.
Tranpkp
************************************
- Let me know if this helped/worked!
Please remember to give helpful posts the stars they deserve!
This facilitates navigating through the threads / posts!
- Thread starter
- #5
VulcanJedi
Technical User
Sorry getting all that info is the best I can do, i can't keep up! I can only suggest utilizing the comments field(no don't know limits nor could I find specs) or presumably not using XL, thinking maybe should convert to access. Tranpkp
************************************
- Let me know if this helped/worked!
Please remember to give helpful posts the stars they deserve!
This facilitates navigating through the threads / posts!
************************************
- Let me know if this helped/worked!
Please remember to give helpful posts the stars they deserve!
This facilitates navigating through the threads / posts!
- Status
Similar threads
- Locked
- Question
- Locked
- Question