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-2013Top