How to change column width in excel

can you have multiple column widths? No, you can‘t do that – all cells in a column have the same width. You can simulate different widths by merging some cells together from columns A and B (or more), but merged cells cause other problems with formulae and macros so they are best avoided.

To change the column width, press Alt+O and then press C (for Column) and then W (for width).

Click the column header for column B to select that column and then choose Home→Format→AutoFit Column Width.

Using AutoFit in Excel

To use AutoFit, click a cell in the row or column you want to change. Within the ribbon menu, click “Home.” Under “Cells,” click the “Format” button. Under “Cell Size” click “AutoFit Column Width” or “AutoFit Row Height” as desired.