Need some help in Excel

V

virtualc08

Supreme Member

Mar 23, 2010

1,380

859

• Feb 13, 2011

• #1

Hey all,

I was wondering how to put the same value in all the cells in Excel . For eg: I want the value "xyz" from A1 to A100 or something. How do I do it in excel?This question might be a little silly but I am so lost

Thanks in advance

 

lablinks

Senior Member

Apr 22, 2010

960

175

• Feb 13, 2011

• #2

type it in A1
click on the cell
click & hold on the little thingy on the right/bottom of the cell & drag it down

 

A

Adewale

Registered Member

Aug 18, 2009

83

41

• Feb 13, 2011

• #3

lablinks is right.
But if the last digit is a number, dragging down will only increase the count.
e.x. if you have ax1 in A1, dragging will make the next cell ax2, ax3,....

Another way is to copy the content of A1, then highlight all the all other cells you want the value appear, then just paste.

Hope this helps

 

haridada

Senior Member

Oct 9, 2008

1,000

346

• Feb 13, 2011

• #4

virtualc08 said:

Hey all,

I was wondering how to put the same value in all the cells in Excel . For eg: I want the value "xyz" from A1 to A100 or something. How do I do it in excel?This question might be a little silly but I am so lost

Thanks in advance

Click to expand...

type xyz in A1. When that A1 cell is selected, if you take your mouse over the big black square, the cursor changes to a black "+" sign. Then start dragging the mouse, a tooltip shows whether its raising the count by 1 or just xyz in the cells being filled.

Simple as that.

Hope that clears your confusion.

 

V

virtualc08

Supreme Member

Mar 23, 2010

1,380

859

• Feb 14, 2011
• Thread Starter Thread Starter

• #5

Thanks a lot guys. I got it