Monday, 13 May 2013

Formatting sheet using Row height and Column Width:


Formatting sheet using Row height and Column Width:

By default width of a column in Excel sheet is 8.43 and height of row is 15. But we can change row height and column width according to our requirement. For this we need to use Home Tab---Cell group---Format option.

Manually we can change row height and column width using mouse pointer. Keeping mouse handle at splitter between each column and rows, by dragging mouse we can resize rows and columns. By double clicking on Splitter between rows/Columns, Auto Fit Row height and column width feature can be used. 

No comments:

Post a Comment