Excel Tutorials

Learn Excel - Chapter 3

Format Cells

The Format Cells command is the most used command in Excel. Using this command, we can change the Format of Numbers, alignment of text, fonts, apply border and fill colour in selected cells. There are 6 tabs i.e. Number, Alignment, Font, Border, Fill and Protection

Format Cells - Number Command

With the help of this command, we can change the format of any number entered in the cell. The Number contains following Sub Commands 1) General 2) Number 3) Currency 4) Accounting 5) Date 6) Time 7) Percentage 8) Fraction 9) Scientific 10) Text 11) Special 12) Custom

Format Cells - Number

Format Cells - Alignment

The Alignment contains the following Sub Commands - 1) Text Alignment - Horizontal / Vertical 2) Text Control - Wrap Text, Shrink To Fit, Merge Cells 4) Right-to-left 5) Orientation

Format Cells - Alignment

Format Cells - Fonts

The Fonts contains the following Sub Commands - 1) Font 2) Font Sytle 3) Size 4) Underline 5) Color 6) Effects

Format Cells - Fonts

Format Cells - Border

The Border contains the following Sub Commands - 1) Line - Style, Color 2) Presets 3) Border

Format Cells - Border

Format Cells - Fill

The Fill contains the following Sub Commands - 1) Background Color 2) Pattern Color 3) Pattern Style 4) Fill Effects 5) More Colors

Format Cells - Fill

Format Cells - Protection

The Protection contains the following Sub Commands - 1) Locked 2) Hidden

Format Cells - Protection

Using Advanced Excel commands like Excel Macros, you can store multiple commands into a single command. To Learn Advanced Excel Whatapp/Call 8422000829. Disount Code WEBSAB501

Home Chapter 1 Chapter 2 Chapter 4 Chapter 5 Chapter 6 Chapter 7 Chapter 8 Chapter 9 Chapter 10 Excel Shortcuts

Keep Learning...

Tumcha Amcha IT Buddy