Select every other Row to copy/cut????
Or Better yet...
1. If you don't already have one, create a numbered column by creating an
empty column (A), type "1" in A1, highlight the column,
Fill-Series-Increment
2. Next to column A, create a new column (B) and enter this formula:
=IF(ISODD(A1),TRUE,FALSE).
3. Highlight your entire worksheet, and sort by column B. This will group
all even columns together, and likewise for all odd columns. Then, select
the group you want.
--
Anne Murray
"Too much data - Too little time" wrote:
How do I select every other row on a large Excel Document?
|