Forum Discussion
Excel spreadsheet creation
I have a spreadsheet that I am working with that has a lot of information already entered. I want to creat a new column that has the "house Number" only in this new column, and it is adjacent to the...
Sergei, That is What I was doing. I had the Address column in column E and I inserted a new column in D and then I began to fill in the HOUSE NUMBER in D1, D2, D3 and so on. Then after a few were filled in, I HIGHLIGHTED D1-D6 and tried to pull the bottom right corner of the highlighted area down so it would auto-fill, but it does NOT recognize that the data I want is from the adjacent cells E1-E6. It thinks I am filling in some mathematic formula and does NOT pick up the House numbers from the adjacent cells. I USED TO DO THIS with no problem in past efforts, but it seems Excel has changed the way auto-fill works and it will not look for the correlation to the adjacent cells and see that pattern. HOW CAN I DO THIS NOW????
- SERGEI, OH! Now I see, I'm on the wrong side! Thanks!! It didn't used to be that way, but now that I know, I can use it. And thanks to all the other suggestions! I'll try them too!