Introduction To MS Excel tutorial
Chapter 1: MS Excel Basics

Chapter 2: Editing Worksheet In Excel

Chapter 3: Formatting Cells

Chapter 4: Formatting Worksheets

Chapter 5: Working With Formulas

Chapter 6: Advanced Operations

How To Use Styles In MS Excel 2010

MS Excel offers Named styles that are extremely easier to apply on a set of the predefined formatting options for a cell or range. In MS Excel, a Style can consist of settings that can be applied to six different attributes.

  • Number format
  • Border
  • Font
  • Alignment
  • Pattern
  • Protection

Applying Styles

In order to apply styles, choose Home, followed by Styles, then click on Cell styles.

MS Excel tutorial

Creating Custom Style in MS Excel

In order to create custom style in MS Excel, follow these steps.

    • Select a cell and click on the Cell Styles from the Home Tab.
    • Click on the New Cell Style and give a style name.
    • Click on Format in order to apply formatting to the cell.

MS Excel tutorial

  • Once formatting is applied, click on OK and it will add new style to the pre-loaded styles. You can view the custom style by going to the Home, followed by Styles.

MS Excel tutorial

Tags

You may also like...

Sorry - Comments are closed

Australia

Unknown
Humidity: 65
Wind: 9 km/h
71 F
65 93
25 Mar 2016
63 87
26 Mar 2016

Slideshow