Latest update 1. Resize Columns and Rows The Excel default cell height and width is hardly one size fits all. Chances are, you’ll need to adjust the column width and row height to accommodate your data. To do that, click the column or row, select the Home tab, then click the Format button within the Cells group. Choose whether you want to adjust the height or width. Enter the amount then click OK. The column or row should be adjusted to the exact measurement. You can also manually resize columns and rows using the mouse. Place the mouse pointer between the column or row, click the left mouse button, observe the floating balloon then drag and expand until the desired size is achieved. And here’s a handy tip: simply double-click the right border of a column to auto-size the width to the data. 2. Add or Remove Columns, Rows or Cells If you need an additional column, row, or cell, you can easily insert it using the Insert and Delete Cells commands. Click the Insert ...
Comments