How to change cell size without changing whole column excel. Select the column or columns that you want to change. This will make the selected cells look as if theyre one. Works like a charm.
Under cells click format and click column width under cell size enter the desired. Choose column width from the options in the drop down menu and enter a number to widen the cells. You can also merge cells but that causes many problems.
Before adjusting the column width make sure the tables preferred width option is not checked. In that case perhaps merge the cells above that you need to be large. Under cell size click autofit column width.
On the home tab in the cells group click format. For example if you need 10 characters in a1 and only 3 in a2 make column a wide enough for 3 characters merge cells a1 and b1 make column b wide enough for the remaining characters in cell a1. To resize a column without affecting other columns move the gray column markers on the ruler instead of dragging cell edges.
The default width is 843 but you can set it to any number up to 255. To quickly autofit all columns on the worksheet click the select all button and then double click any boundary between two column headings. Entering 17 roughly doubles the width of the cell.
For example i have 3 pages with default column widths and now i am trying to copy an excel page from a different file that has different column widths.