XL: AutoFill Limited to 255 Characters (199503)
The information in this article applies to:
- Microsoft Excel 2000
- Microsoft Excel 2002
This article was previously published under Q199503 For a Microsoft Excel 97 version of this article, see 156350.
SYMPTOMS
When you fill a series in a range of cells, the AutoFill feature may not
update the series values in these cells. This behavior occurs if you either
use the fill handle to fill a cell value down (or across) a range of cells
or if you point to Fill on the Edit menu and then click Series.
CAUSE
In Microsoft Excel, you may enter 32,767 characters into a cell, but the
AutoFill feature will not work on cells that contain more than 255
characters. Instead of detecting and filling a series, Microsoft Excel will
instead copy the cells.
REFERENCESFor more information about using autofill in cells, click Microsoft Excel Help on the Help menu, type Automatically fill in data based on adjacent cells in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type: | Major | Last Reviewed: | 11/5/2003 |
---|
Keywords: | kbprb KB199503 |
---|
|