How to find the total width of columns selected in excel?

Question

I do not want to calculate the width using a macro or so. I just want to highlight the columns in excel (just by clicking on each letter A, B, C, etc.), Then I get the magic answer that the sum of the width of each selected column is a few px. Excel only allows me to know the width for each column only, and if I change the width of any column, it just makes the whole selected column very wide.

Any hint is appreciated.

Answer 1

This will not give you the magic answer, but it can quickly get the answer without any VBA.

1) Insert a blank line at the top of the document

2) In cell A1, enter the following formula:

=CELL("width", A1) 

3) Apply the formula to all other columns by dragging the A1 slim-black-crosshair (it appears when you hover in the lower right corner of your cell).

What you get is a rounded pixel value for each column width. Then simply select the cells in the first row for all the columns you want to add, and look at the bottom of the Excel window. You should see the sum of your values ​​as you select. For example, if you want to sum the widths of columns A, B, and D, select A1 CTRL + press B1 and CTRL + press D1. In the lower right corner you will see their total width.

Hope this helps.

Answer 2

You can get the column width by points by giving the cell a specific name. See below using cell A1 as an example:

• Give cell A1 a specific name, such as ColumnWidth
• In RefersTo, enter = get.cell (16, A1)
• In cell A1 or any other cell, make it equal to a specific ColumnWidth name, i.e. = ColumnWidth
• Drag the formula into the columns, the column width will be displayed opposite each corresponding column

Note. Verify that the cell name is not blocked in step 2.

Hope this helps.

Answer 3

Select the entire column and right-click and you will see the Column width option.

Click Column width and you will see the column width in a new window.