notmyrealnamehahaha
New Member
- Joined
- Mar 13, 2004
- Messages
- 5
I want to copy links to another spreadsheet down a column. The info I'm looking for is located in every other cell. ie F3, F5, F7. I want to fill the series (=$F3, =$F5, =$F7) automatically to save on typing. Fill series will do this with real numbers 3, 5, 7. Can it be down with a formula?
Also, is there a way to delete every other row with minimal keystrokes? Selecting with ctrl+mouseclick gets tedious when there is HUNDREDS to delete!
many tks[/img]
Also, is there a way to delete every other row with minimal keystrokes? Selecting with ctrl+mouseclick gets tedious when there is HUNDREDS to delete!
many tks[/img]