The information in this article applies to:
SYMPTOMSThe Fill Values command on the worksheet cell shortcut menu fills series instead of values. CAUSEWhen the active cell contains merged cells formatting and you hold down the CONTROL key and click the cell to access the Fill Values command on the shortcut menu, Microsoft Excel fills series instead. WORKAROUND
To fill values when your data contains a merged cell, do not use the
CONTROL and mouse-click method to fill values. Instead, do the following:
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. REFERENCESFor more information about Fill Values, click the Index button in Microsoft Excel Help, type the following text filling cells, fill seriesand then double-click the selected text to go to the "Automatically fill in data based on adjacent cells" topic. Additional query words: XL98 autofill
Keywords : xlformat |
Last Reviewed: January 13, 2000 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |