Prev: Thanks (I'll try it with line-breaks, eh?)
Next: sort 2 column in the same time "" as dictionary ""
From: Caz on 1 May 2010 05:00
Hi,

I am trying to find more info on how to use the functions on the Fill
Command in the Editing group especially regarding dates as I cannot seem to
get this to work.

I know how to fill using the drag handle but would also like to use the fill
command.

If anyone can guide me to a site which discusses this command that would be
good.

Thanks
From: ozgrid.com on 1 May 2010 06:03
See http://www.ozgrid.com/Excel/excel-fill-handle.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Caz" <Caz(a)discussions.microsoft.com> wrote in message
news:0ABB15BD-FEC6-47FC-9986-8B78369AB78E(a)microsoft.com...
> Hi,
>
> I am trying to find more info on how to use the functions on the Fill
> Command in the Editing group especially regarding dates as I cannot seem
> to
> get this to work.
>
> I know how to fill using the drag handle but would also like to use the
> fill
> command.
>
> If anyone can guide me to a site which discusses this command that would
> be
> good.
>
> Thanks

From: Gord Dibben on 1 May 2010 11:59
Enter a date in A1

Select A1:A20 and Edit>Fill>Series

Choose from options.

Do you want an increment of one day, weekday, one week, step of 2 or
wharever?

Play with it and see the various fills.


Gord Dibben MS Excel MVP

On Sat, 1 May 2010 02:00:01 -0700, Caz <Caz(a)discussions.microsoft.com>
wrote:

>Hi,
>
>I am trying to find more info on how to use the functions on the Fill
>Command in the Editing group especially regarding dates as I cannot seem to
>get this to work.
>
>I know how to fill using the drag handle but would also like to use the fill
>command.
>
>If anyone can guide me to a site which discusses this command that would be
>good.
>
>Thanks

 | 
Pages: 1
Prev: Thanks (I'll try it with line-breaks, eh?)
Next: sort 2 column in the same time "" as dictionary ""