size of different cell of same row questions

Frequent Contributor



Like to check I have a table in row 

3 to 6 column E the wide needs to be 30 "


and the row for 7 onwards on column E wide to be 15"


is there any way to lock the size for row 3 to 6 column E so that the width dont change and

Row 7 column E to be 15"


Please advise 

2 Replies


The maximum width of an Excel column is the width of 255 characters. You'd have to use a very large font size to get that to 30". Moreover, a column cannot span multiple pages, so unless your paper was wider than 30", the printed output would be cut off...

Thank you