Deleting empty cells/rows

  • Thread starter Thread starter RedForeman ©®
  • Start date Start date
R

RedForeman ©®

How do you delete 100s empty rows, with one simple click or several... as
long as it's not right click+delete...

I tried conditional formatting, macro, visual basic, and have nothing to go
on...

--
RedForeman ©® future fabricator and creator of a ratbike streetfighter!!!
==========================
2003 TRX450ES
1992 TRX-350 XX (For Sale)
'98 Tacoma Ext Cab 4X4 Lifted....
==========================
ø¤°`°¤ø,¸¸¸,ø¤°`°¤ø,¸¸¸,ø¤°`°¤ø,¸¸,ø¤°`°¤ø,¸¸¸,ø¤°`°¤ø,¸¸,ø¤°`°¤ø


is that better??
 
Pick any column that you can rely on being able to say "If the cell in this
column is blank, then the entire row may be deleted" - Then select that column
and do Edit / Go To / Special / Blanks, then do Edit / Delete / Entire Row
 
as long as it's not right click+delete...

??? ; maybe you have no right mouse button.

One way ; View -- Toolbars -- Customize. On the Commands tab, choose the
Edit category. In the Commands listbox, scroll down until you see the Delete
Rows command. Drag this to one of your toolbars, then close the dialog.

HTH,
Andy
 
LOL - I think he was hinting at the fact that he didn't want to do that hundreds
of times Andy :-)
 
Pick any column that you can rely on being able to say "If the cell
in this column is blank, then the entire row may be deleted" - Then
select that column and do Edit / Go To / Special / Blanks, then do
Edit / Delete / Entire Row
Click to expand...

Most excellent, sir, Thank you very much.

--
RedForeman ©® future fabricator and creator of a ratbike
streetfighter!!! ==========================
2003 TRX450ES
1992 TRX-350 XX (For Sale)
'98 Tacoma Ext Cab 4X4 Lifted....
==========================
ø¤°`°¤ø,¸¸¸,ø¤°`°¤ø,¸¸¸,ø¤°`°¤ø,¸¸,ø¤°`°¤ø,¸¸¸,ø¤°`°¤ø,¸¸,ø¤°`°¤ø


is that better??
 
LOL - I think he was hinting at the fact that he didn't want to do
that hundreds of times Andy :-)
Click to expand...

Thats it, I have a sheet that's 2190 rows long, and I couldn't imagine
having to do this manually, Ken, your suggestion is gold, and saves me hours
of time... Thanks again...

--
RedForeman ©® future fabricator and creator of a ratbike
streetfighter!!! ==========================
2003 TRX450ES
1992 TRX-350 XX (For Sale)
'98 Tacoma Ext Cab 4X4 Lifted....
==========================
ø¤°`°¤ø,¸¸¸,ø¤°`°¤ø,¸¸¸,ø¤°`°¤ø,¸¸,ø¤°`°¤ø,¸¸¸,ø¤°`°¤ø,¸¸,ø¤°`°¤ø


is that better??
 
Back
Top