Showing posts with label Column width. Show all posts
Showing posts with label Column width. Show all posts

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: