|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 11th, 2004, 10:17 PM
|
|||
|
|||
Contiguous cells are blank - Delete
Excel 2000
I have a spreadsheet with four columns: July, August, September, October. Various cells have a number in them, some are blank. When all four cells in a row are a blank, I want to delete that row. So, if row 10 for July, August, September and October are blank, I want to delete that row. How do I do that? -- Howard 
|
|
#2
October 11th, 2004, 10:20 PM
|
|||
|
|||
|
Hi
one way: http://www.cpearson.com/excel/deleti...eleteBlankRows -- Regards Frank Kabel Frankfurt, Germany "Howard" schrieb im Newsbeitrag ... Excel 2000 I have a spreadsheet with four columns: July, August, September, October. Various cells have a number in them, some are blank. When all four cells in a row are a blank, I want to delete that row. So, if row 10 for July, August, September and October are blank, I want to delete that row. How do I do that? -- Howard
|
|
#3
October 11th, 2004, 10:41 PM
|
|||
|
|||
|
Thanks, Frank!
HF "Frank Kabel" wrote: Hi one way: http://www.cpearson.com/excel/deleti...eleteBlankRows -- Regards Frank Kabel Frankfurt, Germany "Howard" schrieb im Newsbeitrag ... Excel 2000 I have a spreadsheet with four columns: July, August, September, October. Various cells have a number in them, some are blank. When all four cells in a row are a blank, I want to delete that row. So, if row 10 for July, August, September and October are blank, I want to delete that row. How do I do that? -- Howard
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Blank values in Pivot table cells | Sue | Worksheet Functions | 3 | June 3rd, 2004 03:38 AM |
| Excel VBA - Counting Blank Cells | Frank Kabel | Worksheet Functions | 1 | April 9th, 2004 07:34 PM |
| delete all cells with no formula | Todd | Worksheet Functions | 5 | September 23rd, 2003 05:58 PM |
| count blank cells? | Gregg Stone | Worksheet Functions | 2 | September 22nd, 2003 07:26 PM |
Linear Mode
