G Guest Feb 14, 2004 #1 How do I rapidly move data from cells A1 - A5 to A1-F1? I did this a couple years ago and thought is was in paste special but no luck this time.
How do I rapidly move data from cells A1 - A5 to A1-F1? I did this a couple years ago and thought is was in paste special but no luck this time.
D Dave Peterson Feb 14, 2004 #2 I think you want copy|paste special|check transpose. but the "from" range can't overlap the "to" range. maybe paste somewhere else first and then move it (two steps, now).
I think you want copy|paste special|check transpose. but the "from" range can't overlap the "to" range. maybe paste somewhere else first and then move it (two steps, now).
