excel更改指定表格列宽
Do you ever wish that the letters in the Excel column headers were bigger? Did someone send you an Excel file, with a different font in the headers, and you can't figure out what they did to change font in Excel column headers?
您是否曾经希望Excel列标题中的字母更大？ 是否有人向您发送了一个Excel文件，标题中使用了不同的字体，而您不知道他们做了什么更改Excel列标题中的字体？
Here's how you can change the settings in a workbook, so the column and row headers look different.
这是在工作簿中更改设置的方法，因此列标题和行标题看起来有所不同。
[Note: If you're trying to fix column headers that appear as numbers, click here: Column Headings Show Numbers]
[注意：如果您要修复显示为数字的列标题 ，请单击此处： 列标题显示数字 ]
(The Default Settings)
When you create a new file in Excel, the row and column headers are displayed in your workbook Normal Style's font. The Normal Style's font is also used in the worksheet cells, unless you select a different format in some or all of the cells.
当您在Excel中创建新文件时，行标题和列标题将以工作簿的标准样式字体显示。 除非您在某些或所有单元格中选择了不同的格式，否则工作表单元格中也会使用“普通样式”的字体。
In my workbooks, the default font is Arial Narrow 11. In the screen shot below, you can see that the column and row headers are in that font, and so is the data in cells A1 and B1.
在我的工作簿中，默认字体为Arial Narrow11。在下面的屏幕快照中，您可以看到列标题和行标题均使用该字体，单元格A1和B1中的数据也是如此。
(Change the Normal Style Settings)
If you find the default font size too small, or if you'd prefer a different type of font, you can change the Normal Style settings.
如果您发现默认字体大小太小，或者您希望使用其他类型的字体，则可以更改“标准样式”设置。
(To change the Normal font in Excel 2010:)
- On the Excel Ribbon, click the Home tab
- In the Styles group, click Cell Styles, to open the Cell Styles palette.
- Click OK, twice, to close the dialog boxes.
(Crazy Column Headers)
It's too late for this year, but you could use this technique to fool your colleagues on April 1st next year. You know that guy who thinks he knows everything about Excel? See if he can figure this out.
今年还为时已晚，但是您可以在明年4月1日使用此技术来欺骗您的同事。 您知道那个以为自己了解Excel的所有知识的人吗？ 看看他是否能解决这个问题。
Change the Normal font to a graphic font, such as Wingdings, and the row and column headers will turn into pictures, like the happy/sad faces shown below. Then, send the file to your co-worker, and ask him to check the numbers in the Sad Face column. Ha!
将“普通”字体更改为图形字体(例如Wingdings)，并且行和列标题将变成图片，如下面显示的高兴/悲伤面Kong。 然后，将文件发送给您的同事，并请他检查“悲伤的面Kong”列中的数字。 哈！
Remember to format the cells in a non-graphic font, such as Arial, after you change the Normal style, so the data is readable.
记住，在更改“普通”样式之后，请以非图形字体(例如Arial)格式化单元格，以便数据可读。
You'll find more Excel tips and solutions in the Excel Frequently Asked Questions (FAQ) section of the Contextures website. ___________
您可以在Contextures网站的Excel常见问题 (FAQ)部分中找到更多的Excel技巧和解决方案。 ___________
翻译自: https://contexturesblog.com/archives/2012/05/01/change-font-in-excel-column-headers/
excel更改指定表格列宽
