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


Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×