Borders and shading in Excel

Borders and shading:

Borders and shading in Excel Cell shading and borders can be use to group data visually on a worksheet. The reader can immediately understand specific data. The borders can apply to all sides or certain sides of the cells. The borders can also be format.

Applying cell borders and shading:

The following procedure is use to apply cell borders and shading.

  • Select the cell or range of cells.
  • Click Borders on Formatting toolbar. The most recently selected border style will be apply.
  • Click the arrow on borders button to apply a different border style.
  • Choose a style from the palette.
  • Click Format > Cells….for wider range of choices.
  • Click on Border tab to choose color, line style, size and location around the cell.
  • Add shading by clicking Fill color button on Formatting toolbar.


The styles in Excel are use to quickly format worksheet. They provide consistency and create a professional look. Select styles drop down box from formatting toolbar. Excel provides several predefined styles.

Comma:     It adds commas to the number and two digits beyond a decimal point.

Comma[0]:  it is the comma style that rounds to a whole number.

Currency:   It formats the number as currency of with a dollar sign, commas, and two digits beyond decimal point.

Currency [0]: it is the currency style that rounds to a whole number.

Normal:  It reverts any changes to general number format.

Percent: It changes the number to a percent to a percent and adds a percent sign.

Style Dialog Box:

The following procedure is use to create user defined styles with style dialog box:

  • Highlight the cell (s) to add a style.
  • Select Format > Style ….from menu bar.
  • Modify the attributes by clicking Modify button.
  • Check the desire items under style includes.
  • Click add to preview the formatting changes on the worksheet.
  • Highlight the style to be applied to the paragraph and click apply.

Create a new style:

The following procedure is use to create a new style.

  • Select the cell on worksheet containing the formatting to be used in new style.
  • Click Style box on Formatting toolbar so style name is highlighted.
  • Delete text in style box and type name of new style and press Enter when finished.

Protecting Cells and Objects:

Protection of documents and cells prevents unintentional changes to worksheet. It can be especially helpful if some other user is unfamiliar with worksheets and using worksheet. Excel offers the option of protecting the following:

  • Entire document
  • Individual objects
  • Structure of a Window
  • Specific Cells.

You can also add a password to the file. You can lock cells to prevent other from changing the data within then. Locking cells has no effect unless the sheet is protected. By default. A worksheet is locked. To see the setting, click Format > Cell….and then click protection tab.

Protecting sheet

The following procedure is use to protect worksheet:

  • Select Tools > protection > protect Sheet… The Protect sheet dialog box appears.
  • Select the appropriate options in Protect sheet dialog box.
  • Click OK.  The worksheet is protected.

Removing protection from sheet

The following procedure is use to remove protection from worksheet

  • Select Tools > protection > Unprotecte sheet.

Un-protecting Specific Cells

The following procedure is use to unprotected specific cells:

  • Highlight the cells to be unprotected.
  • Click Format > Cells.
  • Select Protection Tab.
  • Remove the check in Locked box and click OK.


(Visited 8 times, 1 visits today)