Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select every other Row to copy/cut????
How do I select every other row on a large Excel Document?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select every other Row to copy/cut????
This is easy...
Simply hold down CTRL while clicking on the row number. -- Anne Murray "Too much data - Too little time" wrote: How do I select every other row on a large Excel Document? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select every other Row to copy/cut????
I do this with a helper column. In the helper column, I enter
=mod(row(),2) The result is wither 0 or 1. Autofilter the data and delete either 0 or 1 (whatever you want). Keep in mind that when you delete the data, it will recalculate. Remove the autofilter and the helper column and VIOLA (I know I spelled it wrong), you're done. "Too much data - Too little time" <Too much data - Too little wrote in message ... How do I select every other row on a large Excel Document? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Still can select locked cells in protected sheet | New Users to Excel | |||
SELECT large amount of data in a worksheet | Excel Discussion (Misc queries) | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions |