In Excel 2002, how can I repeat information from a previous row without having to retype the entire thing?

Question

Like, say you have an address, Column A is last names, B is first names, etc. Say you have the name Smith, Joe and you add some other names but around row 15 you want to add the information for Joe Smith again, is there a way to just type Smith and have the rest of the information in the row come up automatically? Kind of like in Quicken when you enter a transaction and you enter the name again later, the whole thing comes up...

Answer 1

Right click on that cell and select the command "Pick from list"
and you will have list of all items above.

Trust me, I am the VBAXLMan

Answer 2

most likely when you type the first letters of say the address in a cell it will come up with that addrtess if you used it in another cell in that colomn.

or you can copy and paste the info

or you use a formula (like =A15). You can drag this formula all over the row where you need to repeat the info and the formula will automatically change for each cell

Answer 3

Try to highlight the info. with your mouse. Then copy it and go down to where you want to go and paste it.

Answer 4

No. Its complicated to implement something 'simple' which is not the case.