Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Two Inquires
First: Is there a shortcut for me to be able to delete every other line in an excel document. The information on every other line (3,5,7,9 etc) is redundant and I'd hate to have to delete them line by line. Second: When I delete the redundant line, some data from the main line disappears too. I can't have that happen. (that is, if I delete line 3, some important data on line 2 disappears) Please advise. Thank you. -- Templar |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In a helper column adjacent to your data range in row 1 enter xxxxx, in row 2
enter 0, in row 3 enter 1 Select 0 and 1 cells then right-click and drag down as far as you need. Release button and "Copy Cells". Select the column and DataFilterAutofilter on the 1. Select the visible cells and deleteentire row. Then DataFilterAutofilter to disable and see just the even rows remaining. Losing data in row 2 when you delete row 3 sounds like you maybe have merged some cells? Gord Dibben MS Excel MVP On Sat, 1 Mar 2008 16:07:00 -0800, Templar wrote: Two Inquires First: Is there a shortcut for me to be able to delete every other line in an excel document. The information on every other line (3,5,7,9 etc) is redundant and I'd hate to have to delete them line by line. Second: When I delete the redundant line, some data from the main line disappears too. I can't have that happen. (that is, if I delete line 3, some important data on line 2 disappears) Please advise. Thank you. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Further to Gord's reply, if you have formulae in even rows that refer to
cells in odd rows then these will show #REF errors after you remove the odd rows. Pete "Templar" wrote in message ... Two Inquires First: Is there a shortcut for me to be able to delete every other line in an excel document. The information on every other line (3,5,7,9 etc) is redundant and I'd hate to have to delete them line by line. Second: When I delete the redundant line, some data from the main line disappears too. I can't have that happen. (that is, if I delete line 3, some important data on line 2 disappears) Please advise. Thank you. -- Templar |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks Pete.
I forgot to mention that(did not think about it) and did not tell OP to first make a backup. Hope he didn't get too far if there were formulas<g Gord On Sun, 2 Mar 2008 01:38:44 -0000, "Pete_UK" wrote: Further to Gord's reply, if you have formulae in even rows that refer to cells in odd rows then these will show #REF errors after you remove the odd rows. Pete "Templar" wrote in message ... Two Inquires First: Is there a shortcut for me to be able to delete every other line in an excel document. The information on every other line (3,5,7,9 etc) is redundant and I'd hate to have to delete them line by line. Second: When I delete the redundant line, some data from the main line disappears too. I can't have that happen. (that is, if I delete line 3, some important data on line 2 disappears) Please advise. Thank you. -- Templar |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've made backups. Something is not working right at all. I've tried it 20
times I insert a new column as the first column I enter xxxxxx on the title line I enter 0 on line 2 and 1 on line three Nothing happens when I right click, but when I left click I can drag all the way down to the final line entry (5,600) and they are properly highlighted. I right click and hit copy And then I get to authofilter. An arrow box appears at the first entry of every column But nothing happens. By the way, if some cells are improperly merged in this database, is there an easy command to delete the merge command? -- Templar "Gord Dibben" wrote: Thanks Pete. I forgot to mention that(did not think about it) and did not tell OP to first make a backup. Hope he didn't get too far if there were formulas<g Gord On Sun, 2 Mar 2008 01:38:44 -0000, "Pete_UK" wrote: Further to Gord's reply, if you have formulae in even rows that refer to cells in odd rows then these will show #REF errors after you remove the odd rows. Pete "Templar" wrote in message ... Two Inquires First: Is there a shortcut for me to be able to delete every other line in an excel document. The information on every other line (3,5,7,9 etc) is redundant and I'd hate to have to delete them line by line. Second: When I delete the redundant line, some data from the main line disappears too. I can't have that happen. (that is, if I delete line 3, some important data on line 2 disappears) Please advise. Thank you. -- Templar |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Seleting A2 and A3 and left-click dragging will probably increment the numbers
to o,1,2,3,4,5,etc. That's why I mentioned selecting A2 and A3 then right-click and drag then release the button and "Copy Cells". Or you could select A2 and A3 then select from A4 to A5600 and EditPaste Whichever method you use.................... Do you have alternating 0's and 1's in A2:A5600? If so, then you select the autofilter dropdown arrow in A1 and select 1 from the choices. All the rows with 0 should disappear and the rows with 1 will remain. Select what's left from A2 downwards then EditDeleteEntire Row. Now remove the Autofilter to see just the rows with 0 plus the top row. To unmerge cells, FormatCellsAlignment. Uncheck "merge cells". Gord On Sat, 1 Mar 2008 19:44:00 -0800, Templar wrote: I've made backups. Something is not working right at all. I've tried it 20 times I insert a new column as the first column I enter xxxxxx on the title line I enter 0 on line 2 and 1 on line three Nothing happens when I right click, but when I left click I can drag all the way down to the final line entry (5,600) and they are properly highlighted. I right click and hit copy And then I get to authofilter. An arrow box appears at the first entry of every column But nothing happens. By the way, if some cells are improperly merged in this database, is there an easy command to delete the merge command? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Puzzle | Excel Discussion (Misc queries) | |||
Microsoft Excel Puzzle - please help | Excel Discussion (Misc queries) | |||
Excel Puzzle | Excel Worksheet Functions | |||
t-distribution puzzle in Excel | Excel Discussion (Misc queries) | |||
Can you help!!!!! New Puzzle | Excel Discussion (Misc queries) |