Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting every other row?
I have a 25000 line spreadhseet and I need to delete every other row of it.
Is there a way to do so without manually deleting every row (12500 lines!!!). Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting every other row?
a nice solution here
http://www.mcgimpsey.com/excel/deleteeverynthrow.html "The Joe" wrote: I have a 25000 line spreadhseet and I need to delete every other row of it. Is there a way to do so without manually deleting every row (12500 lines!!!). Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting every other row?
I would insert a new column A into the worksheet.
Then select A1:A25000 And type this formula (with a1 the active cell) =MOD(ROW(),2) But hit ctrl-enter to enter the formula in all the selected cells. Then with A1:A25000 still selected edit|copy edit|paste special|values Sort all the data by that column. And delete the 12500 rows you don't want--either 0's or 1's in those cells. Then delete column A. The Joe wrote: I have a 25000 line spreadhseet and I need to delete every other row of it. Is there a way to do so without manually deleting every row (12500 lines!!!). Thanks -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting every other row?
On Feb 6, 1:33 pm, The Joe wrote:
I have a 25000 line spreadhseet and I need to delete every other row of it. Is there a way to do so without manually deleting every row (12500 lines!!!). Thanks I think this is simpler than a macro...you can use it for multiple things.. Insert a column to the left of the data Type a number 1 to the left of the data on the first row (in the new column) Fill the column with consectuve numbers using data fill (highlight first row and second row-the blank row, and then drag the little box in the botton of the area highlighted to the end of the sheet). This will product a column of consecutive numbers but on alternating rows. Sort the data (including the new column) The blank rows will all be in the same area of the sheet delete the blank rows delete the new column This will insure that your data is in the same order as previously. Hope this helps.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting HTML form objects? | Excel Discussion (Misc queries) | |||
Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
Deleting a worksheet but retaining values from the worksheet. | Excel Discussion (Misc queries) | |||
Deleting a worksheet but retaining values from the worksheet. | Excel Discussion (Misc queries) | |||
deleting values in a worksheet without deleting the formulas | Excel Worksheet Functions |