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.