autofilling cells

[John Smith]

say i have a in A1, b in A7, c in A9
how do i insert a in A2 - A6, b in A8 and
"c" in A10 - A21

TIA

 

[Andy B]

Hi

Select your range of cells in column A. Edit / Go to / Special / Blanks.
Type = and then press up arrow. Then hit Shift Enter.
If you are happy with this result, select the range again and Edit / Copy
then Edit / Paste Special / Values to fix the values in place.

Andy.

 

[Dave Hawley]

Hi Andy

I think John mean't Ctrl+Enter not Shift+Enter

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Rajkumar]

i am not a expert,but let me give a try.

1.select the column A.
2.Press F5 key
3.select special button-->Then select Blanks.
4.Some cells will be selcted,now just type = & select the upper cell
do ctrl+enter.

Experts,
Any correction in this..........pls help.

Rajkuma

 

[Debra Dalgleish]

There are instructions here for filling the cells manually, or with a
macro (if you need to do this frequently):

http://www.contextures.com/xlDataEntry02.html

 

[John Smith]

great help
thank u!