'fill/series' option is not available even though I have been into
tools/options/edit and ticked the 'allow cell drag and drop'. Tried
formatting cells as text, number or general.

Hi,

We need more details - what do you mean is not available? You are selecting
a range with something in the first cell and choosing Edit, Fill, Series but
the command is grayed out?

Show us a sample of what you are trying to file, show us what you get, show
us what you expect. Tell us how you are attempting the Fill - toolbar
button, menu, right-mouse button, left-mouse button? What version of Excel
are you using?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"ognavtra" wrote:

'fill/series' option is not available even though I have been into
tools/options/edit and ticked the 'allow cell drag and drop'. Tried
formatting cells as text, number or general.

I am having the same issue in MS Excel 2003 and have no experience of this
happening in other files or even in older versions of this file.

Another thread mention that 'Protection' might be the problem. No worksheet
protection is evident in this particular MS Excel 2003 file that is causing
the problem.

The 'Fill Series' is not available (grayed out) when I use the right-click
and drag at the corner of the source cell and drag to the desination cell or
highlight the cell and attempt to choose the 'Fill Series' from the Edit
menu. Only the 'Copy Cells' option is available in either case.

Where do I look for a setting that will resolve this issue?
--
Walking before running


"Shane Devenshire" wrote:

Hi,

We need more details - what do you mean is not available? You are selecting
a range with something in the first cell and choosing Edit, Fill, Series but
the command is grayed out?

Show us a sample of what you are trying to file, show us what you get, show
us what you expect. Tell us how you are attempting the Fill - toolbar
button, menu, right-mouse button, left-mouse button? What version of Excel
are you using?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"ognavtra" wrote:

'fill/series' option is not available even though I have been into
tools/options/edit and ticked the 'allow cell drag and drop'. Tried
formatting cells as text, number or general.