I set the column width to 14,5 and the row height to 14,5. Despite them being set to the same numbers, the column width is MUCH larger than the row height.
我将列宽设置为14,5,行高设置为14,5。尽管它们被设置为相同的数字,但列宽度比行高度大很多。
I don't know why this is, but I might have accidentally changed the unit of column with using VBA when I was working in another Excel file. How do I set the unit of measure back to standard? So that 14,5 is the same when looking at both column width and row height.
我不知道为什么会这样,但是当我在另一个Excel文件中工作时,我可能会意外地使用VBA更改了列的单位。如何将测量单位设置回标准?因此,当查看列宽和行高时,14,5是相同的。
1 个解决方案
#1
0
Source : Change the column width and row height
来源:更改列宽和行高
A ColumnWidth of 14.5 means you get 14.5 standard font characters in each line of each cell of the column.
ColumnWidth为14.5意味着您可以在列的每个单元格的每一行中获得14.5个标准字体字符。
Standard font : The default text font for worksheets. The standard font determines the default font for the Normal cell style.
标准字体:工作表的默认文本字体。标准字体确定正常单元格样式的默认字体。
A RowHeight of 14.5 means you get a row in which each cell is 14.5 points high (when manually adjusting, you'll see this one in the pop-up; Hint: it's not the pixels).
RowHeight为14.5意味着你得到一行,其中每个单元格高14.5分(当手动调整时,你会在弹出窗口中看到这一个;提示:它不是像素)。
Therefore, it is normal that the same numbers don't always display the same sizes. You have to play around with them and avoid changing the standard font once you have good values.
因此,相同的数字并不总是显示相同的大小是正常的。您必须使用它们并避免在具有良好值后更改标准字体。
#1
0
Source : Change the column width and row height
来源:更改列宽和行高
A ColumnWidth of 14.5 means you get 14.5 standard font characters in each line of each cell of the column.
ColumnWidth为14.5意味着您可以在列的每个单元格的每一行中获得14.5个标准字体字符。
Standard font : The default text font for worksheets. The standard font determines the default font for the Normal cell style.
标准字体:工作表的默认文本字体。标准字体确定正常单元格样式的默认字体。
A RowHeight of 14.5 means you get a row in which each cell is 14.5 points high (when manually adjusting, you'll see this one in the pop-up; Hint: it's not the pixels).
RowHeight为14.5意味着你得到一行,其中每个单元格高14.5分(当手动调整时,你会在弹出窗口中看到这一个;提示:它不是像素)。
Therefore, it is normal that the same numbers don't always display the same sizes. You have to play around with them and avoid changing the standard font once you have good values.
因此,相同的数字并不总是显示相同的大小是正常的。您必须使用它们并避免在具有良好值后更改标准字体。