autofilling cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Smith - 01 Apr 2004 10:54 GMT

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

Reply to this Message

Andy B - 01 Apr 2004 11:28 GMT

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.

> 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

Reply to this Message

Dave Hawley - 01 Apr 2004 11:37 GMT

Hi Andy

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

Reply to this Message

Rajkumar - 01 Apr 2004 11:47 GMT

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

--
Message posted from http://www.ExcelForum.com

Reply to this Message

Debra Dalgleish - 01 Apr 2004 13:16 GMT

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

> 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

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message

John Smith - 01 Apr 2004 15:36 GMT

great help
thank u!

> 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

Reply to this Message