如何找到在Excel中选择的列的总宽度? [英] how to find total width of columns selected in excel?

问题描述

我不想使用宏等来计算宽度.我只想选择excel中的列(只需单击每个字母A，B，C等)，然后得到一个神奇的答案，即我选择的每个列的宽度之和为px.Excel仅允许我知道每列的宽度，并且如果我更改任何列的宽度，它只会使所有选定的列变宽.

I do not want to calculate the width using macro or so. I just want to select the columns in excel (just by clicking on each letter A,B,C and so on), then have a magic answer that the sum of width of each column I selected is some px. Excel only allows me to know width of each column only and if I change width of any column, it just makes all selected column that much wide.

任何提示都值得赞赏.

推荐答案

这不会给您一个神奇的答案，但是它可能会很快使您在没有任何VBA的情况下得到答案.

This won't give you a magic answer, but it might make it quick to get an answer without any VBA.

1)在文档顶部插入空白行

1) Insert a blank row at the top of your document

2)在单元格A1中，输入以下公式:

2) In cell A1, enter the following formula:

=CELL("width", A1)

3)通过拖动A1的细长黑色十字准线(将其悬停在单元格的右下角，将其应用于其他所有列).

3) Apply the formula to all the other columns by dragging A1's slim-black-crosshair (it appears upon hover on the bottom-right corner of your cell).

您将获得的是每列宽度的四舍五入的Pixel值.然后，只需为要添加的所有列选择第一行中的单元格，然后查看Excel窗口的底部.进行选择时，应该看到值的总和.例如，如果您想对A，B和D列的宽度求和，选择A1，按住CTRL键并单击B1，然后按CTRL键并单击D1.在右下角，您将看到它们的总宽度.

What you'll get is a rounded Pixel value of each column's width. Then, simply select the the cells in row one for all the columns you want to add and look at the bottom of your Excel window. You should see the sum of your values as you make your selection. For example, if you want to sum the widths of columns A, B and D, select A1 CTRL+click B1 and CTRL+click D1. In the bottom right, you'll see their summed widths.

我希望这会有所帮助.

这篇关于如何找到在Excel中选择的列的总宽度?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！