No. It only copies the formatting. It does not copy content.
The Format Painter.
Format Painter
Format Painter copies formatting from one selection of text to another, thus ensuring formatting consistency in your presentation.
The button that you can use to apply multiple formatting style to selected cell is called format painter (the icon is a little brush on the "standard" toolbar). The way it works is as follows: 1/ select an area of the spreadsheet that already have the formatting that you want to use. 2/ click on the format painter button on the standard toolbar. 3/ select the area of the spreadsheet where you want to copy the formatting. That's all. Note that if you want to apply the same formatting in several places, you can double click on the format painter button in step 2/ instead of a single click. Then you can do step 3/ several times. When you are finished, click again on the format painter button to deactivate it.
The Auto Fill Options button that appears after you release the mouse button lets you specify what is copied. Clicking this button provides a list of Auto-Fill options. Select the Fill Without Formatting option copies the content but not the formatting.
Yes, the Format Painter copies the format of the text (e.g. font style, size, bold, etc.) but not the actual text. To use the Format Painter, highlight the formatted text that you want to mock. Then click the Format Painter icon and highlight the text that you want to format like the previous text.
You would use the format painter to copy formatting from one cell to another cell or cells. You can also use copy and then use Paste Special to copy just the formatting.Use the copy command and then paste format.
two copies of the file allocation table
Clipboard
It copies what is in the selected cell or cells at that time.
Office Clipboard!
paste button