在excel中打开开发工具(文件——》选项——》自定义功能区)
点击visual basic
放上以下这段代码
Sub Fontlistall()
Dim FontList As CommandBarControl
Dim TempBar As CommandBar
Dim i As Long
Set TempBar = Application.CommandBars.Add
Set FontList = TempBar.Controls.Add(ID:=1728)
Range("A:A").ClearContents
For i = 0 To FontList.ListCount - 1
Cells(i + 1, 1) = FontList.List(i + 1)
Next i
TempBar.Delete
End Sub