| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to reduce table?
I have a table with over 5000 rows. However, only about 2500 rows contain
info, the rest are empty rows (one row with info, next empty, etc). I deleted a few rows by clicking on them and holding Ctrl key. But is there a way to delete several hundreds of empty rows at once? If there is, may someone please tell me how to do it! -- Ilya Zeldes Fort Myers, Florida |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to reduce table?
Select a column that has empty cells.
F5SpecialBlanksOK. EditDeleteEntire Rows. Gord Dibben MS Excel MVP On Mon, 7 Aug 2006 21:56:51 -0400, "ilyaz" wrote: I have a table with over 5000 rows. However, only about 2500 rows contain info, the rest are empty rows (one row with info, next empty, etc). I deleted a few rows by clicking on them and holding Ctrl key. But is there a way to delete several hundreds of empty rows at once? If there is, may someone please tell me how to do it! |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to reduce table?
Gord,
you must be The Genius... Thanks, it worked like a charm... Ilya "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Select a column that has empty cells. F5SpecialBlanksOK. EditDeleteEntire Rows. Gord Dibben MS Excel MVP On Mon, 7 Aug 2006 21:56:51 -0400, "ilyaz" wrote: I have a table with over 5000 rows. However, only about 2500 rows contain info, the rest are empty rows (one row with info, next empty, etc). I deleted a few rows by clicking on them and holding Ctrl key. But is there a way to delete several hundreds of empty rows at once? If there is, may someone please tell me how to do it! |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to reduce table?
Well, but I'm not out of the woods, yet...
I one column, along with the text in the cells there are small pictures in the corner of each cell. Each picture consist of an orange triangle and four circles around it. The size of this group is 0.07" x 0.16". I don't need this "picture". Neither Del or Clear option delete them. I removed several of them individually by moving them out of the cell and then Ctrl+Del (just Del would not delete). Again, how to "mass delete" these pics, but keep the text? Hope there is solution... Ilya "ilyaz" wrote in message ... Gord, you must be The Genius... Thanks, it worked like a charm... Ilya "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Select a column that has empty cells. F5SpecialBlanksOK. EditDeleteEntire Rows. Gord Dibben MS Excel MVP On Mon, 7 Aug 2006 21:56:51 -0400, "ilyaz" wrote: I have a table with over 5000 rows. However, only about 2500 rows contain info, the rest are empty rows (one row with info, next empty, etc). I deleted a few rows by clicking on them and holding Ctrl key. But is there a way to delete several hundreds of empty rows at once? If there is, may someone please tell me how to do it! |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to reduce table?
Nice measurements - did you get a micrometer out for them ?
Puzzled, you only wanted to delete the blank rows So why do you want to delete these *pictures* on celles with text ? Steve On Tue, 08 Aug 2006 04:46:23 +0100, ilyaz wrote: Well, but I'm not out of the woods, yet... I one column, along with the text in the cells there are small pictures in the corner of each cell. Each picture consist of an orange triangle and four circles around it. The size of this group is 0.07" x 0.16". I don't need this "picture". Neither Del or Clear option delete them. I removed several of them individually by moving them out of the cell and then Ctrl+Del (just Del would not delete). Again, how to "mass delete" these pics, but keep the text? Hope there is solution... Ilya "ilyaz" wrote in message ... Gord, you must be The Genius... Thanks, it worked like a charm... Ilya "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Select a column that has empty cells. F5SpecialBlanksOK. EditDeleteEntire Rows. Gord Dibben MS Excel MVP On Mon, 7 Aug 2006 21:56:51 -0400, "ilyaz" wrote: I have a table with over 5000 rows. However, only about 2500 rows contain info, the rest are empty rows (one row with info, next empty, etc). I deleted a few rows by clicking on them and holding Ctrl key. But is there a way to delete several hundreds of empty rows at once? If there is, may someone please tell me how to do it! -- Steve (3) |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to reduce table?
If you want to delete pictures, go to edit--go to--special--select objects
and press delete. "SteveW" wrote: Nice measurements - did you get a micrometer out for them ? Puzzled, you only wanted to delete the blank rows So why do you want to delete these *pictures* on celles with text ? Steve On Tue, 08 Aug 2006 04:46:23 +0100, ilyaz wrote: Well, but I'm not out of the woods, yet... I one column, along with the text in the cells there are small pictures in the corner of each cell. Each picture consist of an orange triangle and four circles around it. The size of this group is 0.07" x 0.16". I don't need this "picture". Neither Del or Clear option delete them. I removed several of them individually by moving them out of the cell and then Ctrl+Del (just Del would not delete). Again, how to "mass delete" these pics, but keep the text? Hope there is solution... Ilya "ilyaz" wrote in message ... Gord, you must be The Genius... Thanks, it worked like a charm... Ilya "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Select a column that has empty cells. F5SpecialBlanksOK. EditDeleteEntire Rows. Gord Dibben MS Excel MVP On Mon, 7 Aug 2006 21:56:51 -0400, "ilyaz" wrote: I have a table with over 5000 rows. However, only about 2500 rows contain info, the rest are empty rows (one row with info, next empty, etc). I deleted a few rows by clicking on them and holding Ctrl key. But is there a way to delete several hundreds of empty rows at once? If there is, may someone please tell me how to do it! -- Steve (3) |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to reduce table?
Thanks, Dave! Worked fine.
Appreciate your help. Ilya "Dave F" wrote in message ... If you want to delete pictures, go to edit--go to--special--select objects and press delete. "SteveW" wrote: Nice measurements - did you get a micrometer out for them ? Puzzled, you only wanted to delete the blank rows So why do you want to delete these *pictures* on celles with text ? Steve On Tue, 08 Aug 2006 04:46:23 +0100, ilyaz wrote: Well, but I'm not out of the woods, yet... I one column, along with the text in the cells there are small pictures in the corner of each cell. Each picture consist of an orange triangle and four circles around it. The size of this group is 0.07" x 0.16". I don't need this "picture". Neither Del or Clear option delete them. I removed several of them individually by moving them out of the cell and then Ctrl+Del (just Del would not delete). Again, how to "mass delete" these pics, but keep the text? Hope there is solution... Ilya "ilyaz" wrote in message ... Gord, you must be The Genius... Thanks, it worked like a charm... Ilya "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Select a column that has empty cells. F5SpecialBlanksOK. EditDeleteEntire Rows. Gord Dibben MS Excel MVP On Mon, 7 Aug 2006 21:56:51 -0400, "ilyaz" wrote: I have a table with over 5000 rows. However, only about 2500 rows contain info, the rest are empty rows (one row with info, next empty, etc). I deleted a few rows by clicking on them and holding Ctrl key. But is there a way to delete several hundreds of empty rows at once? If there is, may someone please tell me how to do it! -- Steve (3) |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to reduce table?
"SteveW" wrote in message news:op.tdyj7yikevjsnp@enigma03... Nice measurements - did you get a micrometer out for them ? You don't need microscope either. In Excel, just highlight the picture, click FormatPicture and then Size Tab. It'll tell you the exact size of the pic. So much even I knew... Puzzled, you only wanted to delete the blank rows So why do you want to delete these *pictures* on celles with text ? My first concern was to reduce the size of the table. Now, I'd like to improve it appearance... Ilya On Tue, 08 Aug 2006 04:46:23 +0100, ilyaz wrote: Well, but I'm not out of the woods, yet... I one column, along with the text in the cells there are small pictures in the corner of each cell. Each picture consist of an orange triangle and four circles around it. The size of this group is 0.07" x 0.16". I don't need this "picture". Neither Del or Clear option delete them. I removed several of them individually by moving them out of the cell and then Ctrl+Del (just Del would not delete). Again, how to "mass delete" these pics, but keep the text? Hope there is solution... Ilya "ilyaz" wrote in message ... Gord, you must be The Genius... Thanks, it worked like a charm... Ilya "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Select a column that has empty cells. F5SpecialBlanksOK. EditDeleteEntire Rows. Gord Dibben MS Excel MVP On Mon, 7 Aug 2006 21:56:51 -0400, "ilyaz" wrote: I have a table with over 5000 rows. However, only about 2500 rows contain info, the rest are empty rows (one row with info, next empty, etc). I deleted a few rows by clicking on them and holding Ctrl key. But is there a way to delete several hundreds of empty rows at once? If there is, may someone please tell me how to do it! -- Steve (3) |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to reduce table?
Thanks for your feedback
I hardly ever put pics in excel and didn't know that feature Steve On Tue, 08 Aug 2006 20:36:52 +0100, ilyaz wrote: "SteveW" wrote in message news:op.tdyj7yikevjsnp@enigma03... Nice measurements - did you get a micrometer out for them ? You don't need microscope either. In Excel, just highlight the picture, click FormatPicture and then Size Tab. It'll tell you the exact size of the pic. So much even I knew... Puzzled, you only wanted to delete the blank rows So why do you want to delete these *pictures* on celles with text ? My first concern was to reduce the size of the table. Now, I'd like to improve it appearance... Ilya On Tue, 08 Aug 2006 04:46:23 +0100, ilyaz wrote: Well, but I'm not out of the woods, yet... I one column, along with the text in the cells there are small pictures in the corner of each cell. Each picture consist of an orange triangle and four circles around it. The size of this group is 0.07" x 0.16". I don't need this "picture". Neither Del or Clear option delete them. I removed several of them individually by moving them out of the cell and then Ctrl+Del (just Del would not delete). Again, how to "mass delete" these pics, but keep the text? Hope there is solution... Ilya "ilyaz" wrote in message ... Gord, you must be The Genius... Thanks, it worked like a charm... Ilya "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Select a column that has empty cells. F5SpecialBlanksOK. EditDeleteEntire Rows. Gord Dibben MS Excel MVP On Mon, 7 Aug 2006 21:56:51 -0400, "ilyaz" wrote: I have a table with over 5000 rows. However, only about 2500 rows contain info, the rest are empty rows (one row with info, next empty, etc).. I deleted a few rows by clicking on them and holding Ctrl key. But is there a way to delete several hundreds of empty rows at once? If there is, may someone please tell me how to do it! |
|
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to reduce table?
You are welcome, Steve.
Ilya "SteveW" wrote in message news:op.tdzeyscvevjsnp@enigma03... Thanks for your feedback I hardly ever put pics in excel and didn't know that feature Steve On Tue, 08 Aug 2006 20:36:52 +0100, ilyaz wrote: "SteveW" wrote in message news:op.tdyj7yikevjsnp@enigma03... Nice measurements - did you get a micrometer out for them ? You don't need microscope either. In Excel, just highlight the picture, click FormatPicture and then Size Tab. It'll tell you the exact size of the pic. So much even I knew... Puzzled, you only wanted to delete the blank rows So why do you want to delete these *pictures* on celles with text ? My first concern was to reduce the size of the table. Now, I'd like to improve it appearance... Ilya On Tue, 08 Aug 2006 04:46:23 +0100, ilyaz wrote: Well, but I'm not out of the woods, yet... I one column, along with the text in the cells there are small pictures in the corner of each cell. Each picture consist of an orange triangle and four circles around it. The size of this group is 0.07" x 0.16". I don't need this "picture". Neither Del or Clear option delete them. I removed several of them individually by moving them out of the cell and then Ctrl+Del (just Del would not delete). Again, how to "mass delete" these pics, but keep the text? Hope there is solution... Ilya "ilyaz" wrote in message ... Gord, you must be The Genius... Thanks, it worked like a charm... Ilya "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Select a column that has empty cells. F5SpecialBlanksOK. EditDeleteEntire Rows. Gord Dibben MS Excel MVP On Mon, 7 Aug 2006 21:56:51 -0400, "ilyaz" wrote: I have a table with over 5000 rows. However, only about 2500 rows contain info, the rest are empty rows (one row with info, next empty, etc). I deleted a few rows by clicking on them and holding Ctrl key. But is there a way to delete several hundreds of empty rows at once? If there is, may someone please tell me how to do it! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
| reduce size of pivot table file | Excel Discussion (Misc queries) | |||
| How to import a table on a Web page to Excel? | Excel Discussion (Misc queries) | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
Linear Mode
