XL98: Fill Values Fills Series with Merged Cells Formatting (178964)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q178964 SYMPTOMS
The Fill Values command on the worksheet cell shortcut menu fills series
instead of values.
CAUSE
When 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:
- Select the merged cell and select down or across enough to
highlight an area that is exactly the same size and shape as the
merged cell.
- Press CONTROL+D (or point to Fill on the Edit menu and click Down or
Right, depending on which direction you have chosen to fill). The
value of the merged cell will be filled into the area highlighted
along with merge cell formatting.
- To remove the merge cell formatting, click Cells on the Format menu.
Click the Alignment tab and click to clear the Merge cells check box.
STATUS
Microsoft 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.
REFERENCES
For more information about Fill Values, click the Index button in Microsoft
Excel Help, type the following text
filling cells, fill series
and then double-click the selected text to go to the "Automatically fill in
data based on adjacent cells" topic.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbprb KB178964 |
|---|
|