Auto fill

[Eamon]

If I enter Jan in cell A1, how can I fill in the months Feb, Mar, Apr etc!
in cells A1 to A12 without using the mouse. How can I do this by using the
keyboard.

Thanks in advance

Eamon

 

[Peo Sjoblom]

There is no real good way of doing this. The best is probably recording a
macro like this

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 11/22/2003 by Peo Sjoblom
'

'
Selection.DataSeries Rowcol:=xlColumns, Type:=xlAutoFill, Date:=xlDay, _
Trend:=False
End Sub

When you record the macro assign a short cut key, put it in your
personal.xls

Now type Jan in a cell, hold down shift and select the cell with Jan and 11
more cells,
Then run the macro using your short cut key

I recorded this after I put Jan in a cell and selected the range.
then doing alt>fill>series and autofill
Otherwise you have to do

Alt + e, i, s, 6 tabs and finally f and enter

 

[Guest]

Peo is not providing accurate information

All you have to do is..
1. Type "Jan" into the first cell
2. hold down your shift key and use your arrow keys to highlight 11 other cells to the right.
3. Press Alt-E to get the edit men
4. Press I to get the Fill men
5. Press S to get the Series dialog bo
6. Choose the appropriate month option and press [Enter]

 

[Peo Sjoblom]

What was inaccurate?

Also using your description, how do you get to appropriate month option
using keyboard and how would that
help in this case? Did you try it yourself?

 

[Gord Dibben]

Peo

Why the 6 tabs?

After entering Jan and selecting 11 more cells ALT + e,i,s,f>OK works for me.

Gord Dibben XL2002

 

[Peo Sjoblom]

Not for me Gord.. You are correct that 6 tabs are not needed but
2 are needed for me, then f

If just do alt + e,i,s I always end up in the step value box and I
can't put f there, one tab takes me to stop value, the second to trend from
where I can
us f to select autofill

Btw, shouldn't you be at the moonshine rink tonight to watch hockey the real
way (-10 degrees)?
--

Regards,

Peo Sjoblom

Peo

Why the 6 tabs?

After entering Jan and selecting 11 more cells ALT + e,i,s,f>OK works for me.

Gord Dibben XL2002

 

[Gord Dibben]

Peo

That is strange.

Are you holding the ALT key all the way through?

ALT + e,i,s,and f for "autofill".

Too far from balmy Parksville just to watch the old-timers play.

Gord

 

[Peo Sjoblom]

Oops!

I never held down alt more than once
to get to the menu dropdown.
Thanks for the correction..

--

Regards,

Peo Sjoblom

Peo

That is strange.

Are you holding the ALT key all the way through?

ALT + e,i,s,and f for "autofill".

Too far from balmy Parksville just to watch the old-timers play.

Gord