When using Excel, the Arial font still insists Every time I have to select all the cells, and then set the font to "Microsoft Yahei". What's even more annoying is that when creating a new worksheet, you have to reset it again.
That's right, there are a lot of articles about modifying the default font of Excel in Baidu, and they all look like the following.
Why is it operated according to "Baidu Experience", but the default The font is still "Arial".
Actually, there is nothing wrong with the tutorial itself, but the way you create Excel is wrong. It should be done as follows:
In the opened Excel page, select [File]->[New]->[Blank Workbook]
In the start menu, find the Excel program (or press the win + r combination, enter "excel" and press Enter), click to open, and select [Blank Workbook]
That's right, what is said together in the tutorial is New workbooks, not new sheets, so our attempts always fail.
It should be noted that the Excel files opened by the above two methods are not saved, in order to prevent The content is lost, please press Ctrl + s to save the file before writing the content.
The reason why many netizens said that the "Baidu experience" is not the same, because the common way we create a new Excel file is, [right click]->[New]-> ;【Microsoft Excel Worksheet】
I promise not to kill him
Right-click the newly created worksheet, in fact, copy the template prepared by Excel to the folder you right-click, understand this, modify and right-click to create The default font for worksheets is much simpler.
As far as Laden Dony has learned, there are two [ShellNew] folders below to save the template
C:Program Files (x86)Microsoft Office ootVFSWindowsSHELLNEW
C:WindowsSHELLNEW
There is a file named [EXCEL12.XLSX] under this [ShellNew] file, which is the template we are looking for .Modify the font in this file, or add some content and save it. Right-click the newly created worksheet, and these modifications will be applied accordingly.
Even if the EXCEL12 under the ShellNew folder is modified. XLSX files, when adding a new sheet, will still be defaulted to "Arial". At this time, you need to use the two methods together.
Using the "Baidu experience" method, modify the default font to "Microsoft Yahei"
Use the two methods described above to create a new workbook, and then save the file as EXCEL12.XLSX
Copy the modified EXCEL12.XLSX file to the ShellNew folder, and overwrite the original EXCEL12.XLSX file (remember to back it up)
Done, pull up your pants and leave.
Try your right click to create Worksheet, is it perfect to change the default font to "Microsoft Yahei"?
Welcome to pay attention to Laden Dony's official account: ladeng6666
Click "Read the original text" to view PPT Cao Jiang's "Dry goods! Cao Jiang's font manual! "
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/Set%20Excels%20default%20font%20away%20from%20the%2011th%20font%20of%20the%20Song%20Dynasty.html
支付宝扫一扫 
评论列表（196条）
测试