Knowledge Base |

# Works: Pasting "Values Only" Pastes Formatting Also

Article ID: 110581

Article Last Modified on 1/21/2000

APPLIES TO

- Microsoft Works 3.0 Standard Edition

This article was previously published under Q110581

## SYMPTOMS

The Values Only option under the Paste Values command in the Spreadsheet module is referring to pasting only values as opposed to formulas. The Values Only option does not refer to any cell formatting. If you use the Paste Special command to paste the contents of a cell that contains formatting, the formatting is copied as well, even if you choose to copy values only. Formatting such as font, color, and pattern are all copied to the new cell.

## WORKAROUND

If the destination cell does not have any information in it, you can paste the information without formatting by selecting Add Values under Paste Special.

### Steps to Reproduce Problem

1. In a new spreadsheet, type a number into a cell.
2. Select the cell and change the font, color, and pattern formatting. Give the cell a border. These options are in the Format menu.
3. From the Edit menu, choose Copy.
4. Select a different cell.
5. From the Edit menu, choose Paste Special. Choose Values Only and choose OK.

The number pastes into the new cell, formatted like the original.

Additional query words: style include ss fmt

Keywords: KB110581