Sabtu, 19 November 2011

Setting column width and row height in excel 2007 at centimeter (cm) or inci

Setting column width and row height In Excel 2007 at centimeter (cm) or inch

Default width 1 column in excel is 8,43. Unit for default column width is character (we don’t know more what is the meaning of character, but for while we can deem that 1 number is 1). So, default of 1 column width is 8,43 characters, so that in 1 column only include typed 8,43 characters, or we can say that 1 excel column only include 8 characters and for 9th character is not include completely in the column, please try to type 8 number characters, when we type 8 number characters still include in 1 column, and when we type 9th character is not include more. Like that approximately size for 8,43 characters.


As while for excel row height by default is 15. Unit for excel row height by default is point (pt). 1 pt approximately is 0,03533 cm.
Ok, Now how to change column width and row height at centimeter (cm) or inch? The manner is below:

  1. Click on View tab


  2. Click on Page Layout

    and display of work sheet will change like below:
  3. Then, please change column width and row heigth as usually before, for this time column width unit and row height unit at centimeter (cm) or inch. For measurement at centimeter (cm), add “cm” after value entered and for measurement at inch, add “in” after value entered.
  4. And then, to back to before display, click on View tab (look at number 1), and click on Normal

Like that how to change column width and row height at centimeter (cm0 or inch, hope useful, if any doubt please send your question to sahabathypheninformasi@gmail.com, bye ^_^

0 komentar:

Posting Komentar