Excel Formatting Keyboard Shortcuts

If you want to quickly format items in Excel while keeping your hands on the keyboard, try these out:

Open Style dialog box: Alt+'
Open Format Cells dialog box: Ctrl+1
Bold: Ctrl+B
Italics: Ctrl+I
Underline: Ctrl+U
Strikethrough: Ctrl+5
Currency format: Ctrl+Shift+$
Date format: Ctrl+Shift+#
Exponential number format: Ctrl+Shift+^
General format: Ctrl+Shift+~
Number format: Ctrl+Shift+!
Percentage format:Ctrl+Shift+%
Time format: Ctrl+Shift+@
Add outline border to the selection: Ctrl+Shift+&
Remove outline border from the selection: Ctrl+Shift +_

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.