Adjusting Size of Rows and Columns

**Aumkar** · 02-15-2010, 01:47 AM

Hi Everyone

How can we increase or decrease the size of rows and columns? Suppose, i want to decrease the size of all rows and columns than the default size in excel, how to go about it?

I am attaching a sample excel sheet in which Sheet 1's rows and columns are a bit bigger than normal. Sheet 2 and Sheet 3 are default size. I would like to know, how can we decrease the size of rows and columns than the default size.

**teylyn** · 02-15-2010, 01:51 AM

<what> than the default size? wider or narrower than the default size? You can select all columns and click Home ribbon - format - autosize.
Also, your sheet1 has font size 14, which accounts for higher rows and wider columns than the other sheets with default font size 10.