Microsoft Office Tutorials and References
In Depth Information
Copying formats with Format Painter
Copying formats with Format Painter
After you create a format for a cell or group of cells, you can
copy the format to another group of cells using Format Painter.
Format Painter lets you copy the format quickly, saving you
the time and effort it takes to copy the contents of another cell
with the formats that you want and then changing the data or
Copy styles with Format Painter
1 Select the cells with the formatting that you want to copy.
2 Click the Home tab.
3 In the Clipboard group, click the Format Painter button.
4 Select the cells where you want the formatting applied.
TIP You can apply cell’s style multiple times by
doubleclicking the Format Painter button. Clicking additional cells
applies the copied format until you press the Esc key.
Search JabSto ::

Custom Search