• Excel Video Tutorials

Using Styles in Excel 2010


Advertisements

Using Styles in MS Excel

With MS Excel 2010 Named styles make it very easy to apply a set of predefined formatting options to a cell or range. It saves time as well as make sure that look of the cells are consistent.

A Style can consist of settings for up to six different attributes −

  • Number format
  • Font (type, size, and color)
  • Alignment (vertical and horizontal)
  • Borders
  • Pattern
  • Protection (locked and hidden)

Now, let us see how styles are helpful. Suppose that you apply a particular style to some twenty cells scattered throughout your worksheet. Later, you realize that these cells should have a font size of 12 pt. rather than 14 pt. Rather than changing each cell, simply edit the style. All cells with that particular style change automatically.

Applying Styles

Choose Home » Styles » Cell Styles. Note that this display is a live preview, that is, as you move your mouse over the style choices, the selected cell or range temporarily displays the style. When you see a style you like, click it to apply the style to the selection.

Applying Style

Creating Custom Style in MS Excel

We can create new custom style in Excel 2010. To create a new style, follow these steps −

  • Select a cell and click on Cell styles from Home Tab.
  • Click on New Cell Style and give style name.
  • Click on Format to apply formatting to the cell.
Creating Custom Style
  • After applying formatting click on OK. This will add new style in the styles. You can view it on Home »; Styles.

Added Styles

Useful Video Courses


Video

MS Excel Online Training

Most Popular

102 Lectures 10 hours

Pavan Lalwani

Video

Excel VBA Online Training

101 Lectures 6 hours

Pavan Lalwani

Video

Advanced Excel (Power Query) Online Training

Best Seller

56 Lectures 5.5 hours

Pavan Lalwani

Video

Excel Dashboard Crash Course

63 Lectures 3.5 hours

Yoda Learning

Video

Advanced Excel Crash Course

134 Lectures 8.5 hours

Yoda Learning

Video

Microsoft Excel Masterclass for Business Managers

33 Lectures 3 hours

Abhishek And Pukhraj

Advertisements