Fill Series Disabled

  • Thread starter Thread starter Lukin
  • Start date Start date
L

Lukin

Normally when right-dragging the corner handle of a cell containing
number I can choose to Fill Series but on one of the sheets of
spreadsheet a friend has sent me this and all the other options on th
'Fill menu' are grayed out. Any ideas why this could be
 
The only reason i can think of if he hasn't specified any fill serie
options. Or you have chosen an initial field that doens' match any o
the available series
 
Are your values formulas?

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Thanks for your quick responses :).

The cell values are eight-digit numbers preceded by the ' (singl
quote) character (the first number is a 0 and he didn't realise it wa
possible to format the cell as text to retain it).

There are two sheets in the workbook both with identically formatte
numbers (as above). In one it's possible to Fill Series but not in th
other.

I've tried removing the single quote and formatting the cell as tex
but this doesn't solve the problem. I've even tried typing a numbe
into a blank cell on the problem sheet but I can't Fill Series fro
that either
 
Back
Top