AutoFill is limited to 255 characters in Excel

This article has been archived. It is offered "as is" and will no longer be updated.
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 notupdate the series values in these cells. This behavior occurs if you eitheruse the fill handle to fill a cell value down (or across) a range of cellsor 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 theAutoFill feature will not work on cells that contain more than 255characters. Instead of detecting and filling a series, Microsoft Excel willinstead copy the cells.
More information
By dragging the fill handle of a cell, you can copy that cell to othercells in the same row or column. If the cell contains a number, date, ortime period that Microsoft Excel can extend in a series, the values areincremented. For example, if you have "Qtr1" (without the quotation marks)in cell A1, and you fill this down to cell A4, you will end up with thefollowing:

   A1: Qtr1   A2: Qtr2   A3: Qtr3   A4: Qtr4				
auto fill XL2000 xl2002 XL2003 XL2007
Properties

Article ID: 199503 - Last Review: 01/12/2015 16:05:09 - Revision: 5.0

  • Microsoft Office Excel 2007
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2002 Standard Edition
  • kbnosurvey kbarchive kbprb KB199503
Feedback