Question

Excel: column width in cm

Answer 1

Excel: How to display the column width in cm
1st step:
2nd step:
3rd step:
4th step:
quick start Guide

---

Would you like to know how to convert the column width to centimeters in Excel? We show you how it works..

Sometimes you create tables in Excel that you want to print out later. Then it is helpful to know how wide the columns actually are. By default, Excel calculates this in pixels, but you can also display the column width in centimeters. We'll show you how to do this in this article.

Excel: How to display the column width in cm

Follow our step-by-step instructions or take a look at the brief instructions .

1st step:

Switch to the " View " tab .

2nd step:

In group " Workbook Views " click " Page Layout ". Excel will now switch to layout mode and you will see a ruler above your worksheet . You can use it to read the width of the columns and the table in centimeters .

3rd step:

To find out the width of individual columns without reading them, right-click on the corresponding letter . Then select " Column Width ".

4th step:

A small window appears with the column width in cm. You can also change the width here if necessary .

Note: You can find out the line height in cm in the same way..

quick start Guide

1. Go to the " View " tab and then in the " Workbook Views " area to " Page Layout ". A ruler will appear above your table.
2. To find out the width of individual columns , right-click on the letter above the column.
3. Select " Column Width ". A window with the width in cm opens.
4. You can also change the width here .

---