May 9, 2011

How to Set Auto Height of Row in Excel 2007


Ah, you may think this is a dummy question, and I agree it is. But it took me half an hour to figure out how to do it. Below is the method:
1, double click the left bar boundary of a row (Not a cell, but the row number in a row)
2, Select rows that you want your operations on, and then mutiple rows: you can choose Format--> AutoFit Row Height

PS: It really took me a long time to find out where the "Format" option locates.Haha!

No comments: