Can't drag outside selection to extend series!!!!!!!

[taulant01]

Hi. I am new here, and i am very happy that those forums exist.
I have a little problem.

Problem:

-I am doing a project in Exel, and on my project i must write down the date for example from 1 December to 31 December, and on some Sheets on the exel file i can only write the Date and in the right corner i can drag outside selection to extend series. But in some sheets i can't do that! How can i make in alla sheets to drag outside selction to extend series??

Sorry for my bad english.

Thnx for ur help

 

[Ginny2222]

Is your date in the right format in the sheets that won't allow the extend series? The date must be recognised correctly by Excel. Try a simple test in those sheets. Type the date in 2 formats - 01/01/2010 and also 01.01.2010. The one with the "/" should extend, but the one with the "." won't. You can see that the 01.01.2010 stays on the left of the cell - this is also an indication that it's not in date format.

rgs
Ginny

 

[HaHoBe]

Hi, taulant01,

are these sheets protected?

Ciao,
Holger