Using fill in Excel 2007 results in incorrect values, how come? - only one d2 copy may that run
I have a list of values in my first column. I am creating a VLOOKUP to get something from another site. This works well until I double-click the bottom corner on the right or use to fill. Excel fills the cells with the value of the first cell and not the value to cell coorespond. It also happened while I = B2 + D2. When I fill in the next cell, said: = B3 + D3, but reflects the value of D2 = B2 + instead. I am of what you can copy the correct formula for confusion, but it shows the value of only the first. I tried to manually work in the following functions in cells and good, but since I have 22.000 lines, which is not a solution. Please help!
Sunday, February 21, 2010
Only One D2 Copy May That Run Using Fill In Excel 2007 Results In Incorrect Values, How Come?
2 comments:
Well, it seems to have a common problem, and here a distance, quick and easy. To enter a formula for a number of first category in the formula and the use is highlight, copy and A1. Then select the whole line to paste and paste. Then select the entire column A. format, click on the toolbar and set the number of cells. Now go to the top of a column 2 Highlight and select the number format again and mark the lines from A1 to A? depending on how many of them have to be copied and pasted. is that since both sides are as the number of those who say that defining the same. Ugh! lol. I hope that works out, so I think Excel check the manual. Bye for now
Well, it seems to have a common problem, and here a distance, quick and easy. To enter a formula for a number of first category in the formula and the use is highlight, copy and A1. Then select the whole line to paste and paste. Then select the entire column A. format, click on the toolbar and set the number of cells. Now go to the top of a column 2 Highlight and select the number format again and mark the lines from A1 to A? depending on how many of them have to be copied and pasted. is that since both sides are as the number of those who say that defining the same. Ugh! lol. I hope that works out, so I think Excel check the manual. Bye for now
Post a Comment