ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Series Capture Feature is Turned Off (https://www.excelbanter.com/excel-discussion-misc-queries/195080-series-capture-feature-turned-off.html)

DOUG ECKERT[_2_]

Series Capture Feature is Turned Off
 
The little black cross which allows me to capture and to extend data series,
such as months, is turned off. Re-booting did not correct the problem.
Please advise. I am using Office 2007.

DOUG

Bob Phillips

Series Capture Feature is Turned Off
 
ToolsOptionsAllow cell drag and drop

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"DOUG ECKERT" wrote in message
...
The little black cross which allows me to capture and to extend data
series,
such as months, is turned off. Re-booting did not correct the problem.
Please advise. I am using Office 2007.

DOUG




DOUG ECKERT[_2_]

Series Capture Feature is Turned Off
 
.... or Excel OptionsAdvancedAllow cell drag and drop. (I had to query the
Help feature until I figured out that the little black cross is called the
fill handle, then to look up "Enable Fill Handle" - although, I did not
remember disabling it in the first place).

Thanks, Bob!

"Bob Phillips" wrote:

ToolsOptionsAllow cell drag and drop

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"DOUG ECKERT" wrote in message
...
The little black cross which allows me to capture and to extend data
series,
such as months, is turned off. Re-booting did not correct the problem.
Please advise. I am using Office 2007.

DOUG






All times are GMT +1. The time now is 04:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com