about copy plz help

  • Thread starter Thread starter MAN3282
  • Start date Start date
M

MAN3282

i have num in call A1 whan i push enter i want the same number in A2

how i can do it ??

thx
 
I'm sorry I must point out my question more

I'm have at approximately four thousand row in the first column there Bahey
figures

To be equivalent or any method urges When I click the introduction of the
figure in the row former replication

If the equation you must be introduced in each cell
No Warning only after the completion of these deficiencies and the problem


Thank you for assistance and I hope I explained my question and help me
 
Enter =IF(A1="","",A1) in B1

Select B1.

In NameBox type B1:B4000 and hit ENTER key.

CTRL + d to copy the B1 formula down to B4000


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADD (A3+A1) IN MS EXCEL & I WANT OUTPUT IN CELL A3 HOW ? 2
For a Cell A3, i use '=A2' ..i want to copy the format of A2 also, 3
formula required (2nd time) 6
is it possitle i write"1"and "one" will show in next coloumn. 1
copy formula with same cells involved 3
Identify text nums in scrambled fashion 3
copy and paste the cell with formula ="1" 3
how to have cells automatically fill when entering value in ref 2

Back
Top