To copy formatting using fill handle, consider the following example:
In cell B2, type Calibri 16pt, change the color of text to red. On the Home tab, in the Font group, click the Font dropdown box and click Calibri and change the font size to 16.
In cell B3, type Cambria 14pt, change the background color of the cell to yellow. On the Home tab, in the Font group, click the Font dropdown box and click Cambria and change the font size to 14.
Select cells B2 and B3. Keep the right click mouse button in pressed state and drag the mouse cursor down to few cells (say till B6). You will see the list of options for Auto Fill. Click Fill Formatting Only.
Enter some information in cell B4, it will have the Calibri font with 16 point and color of the text will be red. Similarly in B5, the font will be Cambria with 14 point size and the background color of the cell will be yellow.
Apr 2, 2011
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment