excel2007 operational problems?
Users questions: Column A, B column C column two sets of data to be added to a set of data, C plus or minus other values listed in column D so get get a lot of column data. I want column C to copy data to another worksheet for the size of the sort, then the error # REF! I want column C value using the numeric keypad to re-play it again It can copy the formula to eliminate tired. What is a good way to do a number a number of heavy fighting, my current worksheet data but also to retain, what a way to keep the formula to calculate the value of the formula to remove.
Experts answer: you copy or as it was copied in the paste when the point selection Of the paste, the value selected out of the box like,