Wednesday, May 4, 2011

Auto Row Height


On the rare occasion that a particular font size is bigger than the height of cell, you may need to adjust the height of the rows on the Excel sheet so you can see all the data easily. You can adjust each row one at a time; however if you have many rows that need adjusting, it is much quicker to adjust them all at the same time.


The first ting you need to do is select all the rows that need to be adjusted. Using your mouse, position your cursor on the row header (numbers down the left side of the Excel sheet), then click and drag from the first row that contains data down to the last row that contains data. (If you have a lot of data, you may want to press Ctrl-a; this will select the entire Excel worksheet)

 


Now position your mouse cursor between any two of the selected row headers and double-click.
 

As you can see, all of the rows have adjusted to the proper height.



That’s all for today, come back tomorrow and we’ll talk about adjusting the Column Width.


Keep Excelling!!!

Do you like this post? Comment below and / or share on Facebook or Twitter!

No comments:

Post a Comment

Chitika