DW Faisalabad New Version

DW Faisalabad New Version
Please Jump to New Version
  • Working with Tables
  • While there are four types of database objects in Access, tables are arguably the most ... read more

    Friday, 17 February 2017

    Format Painter

    The Format Painter is one of the most underused features of Excel. The Format Painter copies formatting from one place and applies it to another.

    1. For example, select cell B2 below.

    2. On the Home tab, in the Clipboard group, click Format Painter.


    3. Select cell D2.

    Result:


    Note: the Format Painter applies the Currency format, background color and borders of cell B2 to cell D2. That saves time! Double click the Format Painter button to apply the same formatting to multiple cells.