Formatting Cells Shortcut Keys
|
Alt+H+B: |
Add a border |
|
Alt+H+H: |
Select a fill color |
|
Ctrl+0: |
Hide the selected columns |
|
Ctrl+1: |
Open the Format Cells dialog box |
|
Ctrl+5: |
Apply or remove strikethrough |
|
Ctrl+9: |
Hide the selected rows |
|
Ctrl+B: |
Add or remove bold to the contents of a cell or selected range |
|
Ctrl+I: |
Add or remove italics to the contents of a cell or selected range |
|
Ctrl+Shift+$: |
Apply currency format |
|
Ctrl+Shift+%: |
Apply percent format |
|
Ctrl+Shift+&: |
Apply outline border |
|
Ctrl+Shift+_ (Underline): |
Remove outline border |
|
Ctrl+U: |
Add or remove underline to the contents of a cell or or selected range |
See also:
| Excel keyboard Shortcuts |
| Lesson 1 - Excel Fundamentals |
Free Training Course: Lesson 1 - Excel Fundamentals
See also: Index to Excel VBA Code; Index to Excel Freebies; Lesson 1 - Excel Fundamentals; Index to how to… providing a range of solutions
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your
Gallery
