• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 11: Appendixes > Format Data

Format Data

PressTo
Alt+' (apostrophe)Display the Style dialog box.
Ctrl+1Display the Cells dialog box. (Note that you must use the 1 key above the keyboard, not on the keypad.)
Ctrl+Shift+˜ (tilde)Apply the General number format.
Ctrl+Shift+$Apply the Currency format with two decimal places (negative numbers in parentheses).
Ctrl+Shift+%Apply the Percentage format with no decimal places.
Ctrl+Shift+⁁ (caret)Apply the Exponential number format with two decimal places.
Ctrl+Shift+# (pound)Apply the Date format with the day, month, and year.
Ctrl+Shift+@Apply the Time format with the hour and minute and AM or PM.
Ctrl+Shift+!Apply the Number format with two decimal places, (exclamation point) thousands separator, and minus sign (–) for negative values.
Ctrl+BApply or remove bold formatting.
Ctrl+IApply or remove italic formatting.
Ctrl+UApply or remove underlining.
Ctrl+5Apply or remove strikethrough.
Ctrl+9Hide the selected rows.
Ctrl+Shift+((opening parenthesis)Unhide any hidden rows within the selection.
Ctrl+0 (zero)Hide the selected columns.
Ctrl+Shift+) (closing parenthesis)Unhide any hidden columns within the selection.
Ctrl+Shift+& (ampersand)Apply the outline border to the selected cells.
Ctrl+Shift+_ (underscore)Remove the outline border from the selected cells.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint