Hi Hui,
I did the same thing u said in the second step.I have ticked the autmatic check box and now it is working fine now.
Thanks a lot.It was real urgent. thanks a lot.
When i am copying a formula to next cell it is just taking the same value as appearing in the first formula.i.e. it is not appyling the formula in next cell but when I open the formula with F2 and press enter then it updates the formula.
Please help me to resolve this issue.
Hi All,
I am facing a problem while applying vlookup.
When we apply vlookup to a data then if in the table array (i.e. the column from which the data is to be vlookedd up) if lookup value is coming more than once then vlookup picks up the value of the first line item only.Is there a way where...
If in a cell i have applied a formlua of sum form two differnnt sheets of the same file then by pressing Ctrl & [ I get to see the first value only but if after seeing the first value i want to go to second value directly then how i can go to it.
Thanks in advance
Please revert
when i am saving my excel file it shows an error saying -"errors were detected while saving file & file can be saved by repairing or removing some feature.To make repairs in new file click continue"
and then after that when i click continue then a diaglogue box shows some log of liosting...
I am not able to add more rows between two rows.
I am trying CTRL+Shift+PLUS.but it says cannot shift object
Please help i am a beginner.dnt knw much about excel