Select the product you need help with

XL98: CTRL+SHIFT+" Keyboard Shortcut Limited to 1,024 Characters

Article ID: 183898 - View products that this article applies to.

Retired KB Content Disclaimer

This article was previously published under Q183898

kbclone: 156836

(http://support.microsoft.com/kb/156836/EN-US/ )

, 211587

(http://support.microsoft.com/kb/211587/EN-US/ )

Expand all | Collapse all

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.

Back to the top | Give Feedback

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.

Back to the top | Give Feedback

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.

Back to the top | Give Feedback

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Back to the top | Give Feedback

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.

Back to the top | Give Feedback

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

keyboard shortcuts

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.

Back to the top | Give Feedback

Properties

Article ID: 183898 - Last Review: September 11, 2002 - Revision: 1.0

APPLIES TO

Microsoft Excel 98 for Macintosh

kbbug kbpending kbualink97 KB183898

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top | Give Feedback