| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
deleting every other row in Excel
I have a spreadsheet with copy and pasted information. The information
includes a blank row between data rows. Is there a formula I can use to eliminate the blank rows? Thanks, RuthZ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
deleting every other row in Excel
Select a column then F5SpecialBlanksOK
EditDeleteEntire Row. Gord Dibben MS Excel MVP On Sat, 6 Jan 2007 20:50:01 -0800, RuthZ wrote: I have a spreadsheet with copy and pasted information. The information includes a blank row between data rows. Is there a formula I can use to eliminate the blank rows? Thanks, RuthZ |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
deleting every other row in Excel
Thanks!
"Gord Dibben" wrote: Select a column then F5SpecialBlanksOK EditDeleteEntire Row. Gord Dibben MS Excel MVP On Sat, 6 Jan 2007 20:50:01 -0800, RuthZ wrote: I have a spreadsheet with copy and pasted information. The information includes a blank row between data rows. Is there a formula I can use to eliminate the blank rows? Thanks, RuthZ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Rows in MS Excel | Excel Discussion (Misc queries) | |||
| deleting sheets in Excel 2007 ( Beta 2 ) | Excel Worksheet Functions | |||
| Multiple Excel versions. | Excel Discussion (Misc queries) | |||
| Extract MS Excel Data embedded in MS Word | Excel Discussion (Misc queries) | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Linear Mode
