Sunday 27 January 2013

How to Adjust column width or row height in Excel

There are many ways to adjust column width or row height in Excel worksheet. I personally use following methods:

  1. Manual adjusting: Move mouse pointer to column/row header between two columns/rows. Mouse pointer turns in to two headed arrow. Now you can adjust column width / row height by just dragging with mouse.
  2. Automatic adjusting: Instead of dragging, you can double click between two columns/rows when mouse pointer is two headed arrow. That will result column/row automatic adjustment to the optimal width/height.
  3. Adjusting several columns/rows at the same time. Actions above adjust all selected widths/heights. You can select some columns/rows or entire worksheet by clicking crossing of column and row headers on top left corner of the table.
Following video demonstrates this:



No comments:

Post a Comment