Change the unit of measurement

Earlier versions of Excel measured column width as the number of characters in the standardskrifttype that would fit on a single line in that column. This value was determined by using the average width of the ten digits 0 through 9 in that font. Excel now uses standard measurement units, such as inches, to establish column widths, row heights, and the graduations of the horizontal and vertical sheet rulers.

You can change the default units for the rulers.

Bemærk: If you don't see the rulers on your sheet, on the View menu, click Page Layout. Then, on the View menu, click Ruler.

  1. On the Excel menu, click Preferences.

  2. Under Authoring, click General  Knappen Generelle indstillinger .

  3. On the Ruler units pop-up menu, click the unit of measurement that you want to use.

    Tip: You can still measure the column width in terms of number of standard font character units by dragging the column separator on the sheet and observing the Skærmtip as you drag. In the ScreenTip, the first number after Width is the width of the column in character units. If you don't see the ScreenTip, on the View menu, point to Toolbars, and then click Customize Toolbars and Menus. On the Toolbars and Menus tab, select the Show ScreenTips for toolbar commands check box.

See also

Control how workbooks and sheets are created

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!