Article ID: 183898
Article Last Modified on 9/11/2002
APPLIES TO
- Microsoft Excel 98 for Macintosh
This article was previously published under Q183898
SYMPTOMS
If you press CTRL+SHIFT+" (quotation mark) to copy a cell value, the value
that you paste into the active cell may contain fewer characters than the
value that you copied.
CAUSE
The CTRL+SHIFT+" keyboard shortcut, which is designed to copy the value
(not the formula) from the cell above the active cell into the active cell
or formula bar, is limited to copying 1,024 characters.
WORKAROUND
To work around this behavior, copy the value, and then use the Paste
Special command. To do this, follow these steps:
- Select the cell you want to copy.
- On the Edit menu, click Copy.
- Select the cell in which you want to paste the value.
- On the Edit menu, click Paste Special.
- In the Paste Special dialog box, click Values, and then click OK.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
MORE INFORMATION
In Microsoft Excel 98, the limit to the number of text characters that you
can type in a cell has increased to 32,767 characters. Although the
CTRL+SHIFT+" keyboard shortcut works as described in this article, the
shortcut is designed to copy only the first 1,024 characters in the cell.
REFERENCES
For more information about keyboard shortcuts, click Contents And Index
on the Help menu (or on the Balloon Help menu if you are using a version of
the Macintosh operating system earlier than 8.0), click the Index button in
Microsoft Excel Help, type the following text
and then click Show Topics. Select the "Use shortcut keys in
Microsoft Excel" topic, and click Go To. If you are unable to find the
information you need, ask the Office Assistant.
Additional query words: XL97 8.0 quotes XL98
Keywords: kbbug kbualink97 kbpending KB183898