×
英语
很抱歉。本文没有你的语言版本。

Format data by using shortcut keys

Press

To

CTRL+1

Display the Format dialog box for the selected chart item

CTRL+SHIFT+~

Apply the General number format to the selected chart axis or data labels

CTRL+SHIFT+$

Apply the $#,##0.00 Currency format to the selected chart axis or data labels (negative numbers appear in parentheses)

CTRL+SHIFT+%

Apply the 0% Percentage format to the selected chart axis or data labels

CTRL+SHIFT+^

Apply the Scientific number format with two decimal places to the selected chart axis or data labels

CTRL+SHIFT+#

Apply the d-mmm-yy Date format to the selected chart axis or data labels

CTRL+SHIFT+@

Apply the h:mm AM/PM Time format to the selected chart axis or data labels

CTRL+SHIFT+!

Apply the #,##0.00 Number format (negative values preceded by a minus sign) to the selected chart axis or data labels

CTRL+B

Apply or remove bold formatting

CTRL+I

Apply or remove italic formatting

CTRL+U

Apply or remove an underline

CTRL+5

Apply or remove strikethrough formatting


扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×