formula dun update itself

  • Thread starter Thread starter cmiaoqin
  • Start date Start date
C

cmiaoqin

Hi All,

i got this formula

=CONCATENATE(A15,B15,C15)

wheni drag down, the formula does increase to =CONCATENATE(A16,B16,C16
but the result does nt change until i hit "enter" on formula. is there
way that it auto had the new result n doesnt need to hit enter after
drag
 
It sounds like sheet calculation in set to manual. Go to
Tools>Options>Calculation tab and select Automatic under calculation. If you
want to keep your sheet recalculation as manual, ignore what I just said and
hit F9 after dragging the formula which will force a recalculation.
 

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

formula or code help 3
Replication of Excel formulas [automatic cell update feature] 3
help with vlookup 3
Time update 9
calculations do not update unless page is saved 1
Challenging formatting formula 12
Match, then autopopulate, based on condition 3
Error Saving: "a formula in a cell... could not be converted..." 2

Back
Top