Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill series option not available
'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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill series option not available
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill series option not available
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill series option not available
ToolsOptionsCalculation can be Auto or Manual.
Excel takes the Calculation mode each session from the settings on the first workbook opened in that session. i.e. If you saved Book1 with calc mode in manual and opened it first, calc mode would be in Manual. If you saved Book2 with calc mode in auto and opened it after Book1, Book2 would be in manual mode(Excel ignores the auto calc mode in this case). If you close Book1 before opening Book2, Book2 will be in auto calc mode. Confusing enough? <g Gord Dibben MS Excel MVP On Wed, 23 Sep 2009 09:39:40 -0700 (PDT), Eirann wrote: I had this same problem and was able to resolve it by fixing the calculation settings in Excel 2003. Try: Tools Options Calculation and make sure the option is checked for automatic calculation. I hope that helps - it fixed the issue for me, although I have no idea how it got changed in the first place. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill Series Dates: not letting me change the series from year to m | Excel Discussion (Misc queries) | |||
How do I make the "series" option available under the Fill Menu? | Excel Discussion (Misc queries) | |||
IN ONE PARTICULAR EXCEL97 FILE CANT SEE FILL-SERIES-OPTION | Excel Discussion (Misc queries) | |||
The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
Fill Series option grayed out | Excel Discussion (Misc queries) |