Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Try it!

Adjust row and column size in tables when you need to fit text, make all rows or columns a uniform size, or simply make the table look how you want.

Change column and row width

To change the width, do one of the following:

  • Select the boundary of the column or row you want to move and drag it to the width or height you want.

  • Select the rows or columns and then select Layout and choose your height and width.

  • Select View > Ruler checkbox, select the cell you want, and then drag the markers on the ruler.

    Note: In Excel, select Home > Format, and then select Column Width.

Change column and row height

To change the height, do one of the following:

  • To make all rows in the table the same height, select Layout > Distribute Rows.

  • To make all the columns in the table the same height, select Layout > Distribute Columns.

    Note: In Excel, select Home > Format, and then select Row Height.

Adjust cells to fit the text with AutoFit

  • To adjust a column, select it, and then select Layout > AutoFit > AutoFit Contents.

  • To adjust a table, select it, and then select Layout > AutoFit > AutoFit Contents.

Want more?

Move or resize a table

Word training

Excel training

PowerPoint training

Outlook training

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.