Auto fill

E

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
 
P

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
 
C

CJ Rhoads

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]
 
P

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?
 
G

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
 
Top