View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
oldLearner57 oldLearner57 is offline
external usenet poster
 
Posts: 119
Default alternate rows with date

10s!..it was wonderful, so easy yet so difficult if not enlighted :)

10s community
--
oldLearner57


"FSt1" wrote:

hi
another way.
enter date 5/1/08in A1
enter next date 5/2/08 in A3
high like range A1:A4
place curson over lower right corner of selected area until curser turn into
a small black cross. click and hold. drag down as far as you want.

regards
FSt1

"oldLearner57" wrote:

hi community

how can i fill up alternate rows with a series of date that runs consecutively

example:

A B C D

1 01-May

2

3 02-May

4

5 03-May

can this sort of series fill possible?


thanks community

:)


--
oldLearner57