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 |