|
Microsoft Office Development and Consultancy |
| Home | | | Excel | | | VBA | | | C# | | | Finance | | | Tools | | | Newsletter | | | Feedback | | | Contact |
| Excel > Formatting | < Previous | Next > |
Basic |
| Expand | - | Getting Started |
| Step By Step | - | Format Painter |
| Step By Step | - | Alignment Tab |
| Step By Step | - | Font Tab |
| Step By Step | - | Border Tab |
| Step By Step | - | Fill Tab |
| Step By Step | - | Colours |
| Step By Step | - | Automatic Format Expansion |
| Step By Step | - | Styles |
| Step By Step | - | Styles - Cell |
| Step By Step | - | Styles - Table |
| Step By Step | - | Themes |
Advanced |
| More Details | - | Protection Tab |
| More Details | - | Shading Rows and Columns |
| More Details | - | Flashing Text |
| More Details | - | AutoFormat |
| More Details | - | Too Many Cell Formats |
| More Details | - | Advanced Techniques |
| More Details | - | Version Changes |
| More Details | - | Office Online |
| More Details | - | Knowledge Base |
| More Details | - | Knowledge Base - Numerical |
| More Details | - | VBA Code |
Shortcut Keys |
(Alt + ' ) - Displays the (Format > Style) dialog box. | ||
(Alt + Enter) - Enters a carriage return in a cell. | ||
(Ctrl + 1) - Displays the (Format > Cells) dialog box. | ||
(Ctrl + Shift + 7) - Applies the outline border to the selection. | ||
(Ctrl + Shift + - ) - Removes all the borders from the selection. |
Options |
(Edit tab, Extend data range formats and formulas) - Automatically formats any new items added to the end of a list to match the format of the other items in the list. For formats to be extended automatically they must appear in at least three of the last five rows preceding the new row. |
Related Sections |
| GoTo | - | Conditional Formatting |
| GoTo | - | Text Manipulation |
| © Better Solutions Limited 10-May-2013 | Top |