XL2000: Pasted Data May Include Hidden Cells

ID: Q245541

The information in this article applies to:
  • Microsoft Excel 2000

SYMPTOMS

When you paste a range of cells from Microsoft Excel 2000 to another Microsoft Office 2000 program, hidden cells may become visible. This happens even when you click Visible cells only in the Go To Special dialog box before copying.


CAUSE

This behavior occurs when the following conditions are true:

  • You copy a range that includes hidden or grouped rows or columns.

    -and-

  • You switch to another Microsoft Office 2000 program and click Paste on the Edit menu to paste the data in the default Clipboard format.


WORKAROUND

To work around this behavior, use the Paste Special command to paste the information as text. For example, follow these steps in Microsoft Word 2000:

  1. On the Edit menu, click Paste Special.


  2. Click Formatted Text (RTF), Unformatted Text, or Unformatted Unicode Text in the As list.


  3. Click OK.



MORE INFORMATION

The new HTML Clipboard format is the default format when copying and pasting data between Office 2000 programs. The HTML Clipboard format displays cells in hidden columns.

For additional information about copying hidden text, click the article number below to view the article in the Microsoft Knowledge Base:

Q228868 XL2000: Hidden Property Not Retained When Pasting Selection from Word
For more information about hiding all or part of a workbook, click Microsoft Excel Help on the Help menu, type hide parts in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

For more information about using grouping and outlining, click Microsoft Excel Help on the Help menu, type outline in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Additional query words: XL2000

Keywords :
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb


Last Reviewed: December 14, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.