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


Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×