|
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | Consultancy | | | 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 | - | Patterns Tab |
| Step By Step | - | Colours |
| Step By Step | - | Automatic Format Expansion |
| Step By Step | - | Table Styles |
Advanced |
| More Details | - | AutoFormat |
| More Details | - | Styles |
| More Details | - | Shading Rows and Columns |
| More Details | - | Flashing Text |
| More Details | - | Advanced Techniques |
| More Details | - | Office Online |
| More Details | - | Knowledge Base |
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. |
Tools > 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 Topics |
| GoTo | - | Conditional Formatting |
| GoTo | - | Text Manipulation |
| Copyright © 2010 Better Solutions Limited. All Rights Reserved. | Top |