How do I delete blank rows at the bottom of my data

**Interesting Ian** · 11-17-2014, 02:01 PM

Hi, I have a huge number of worksheets with a huge number of tabs which all scroll down to around 1,000,000 rows even though I only have around 5000 rows of data in each tab. I've googled and none of the proposed solutions work. The only thing that works is if I copy my data, create a new tab, then paste it in there. But I have to format it again etc and will take ages for hundreds of tabs. Is there a quicker way?

It's no good at the moment because it's extraordinarily difficult to get to a specific row eg if I try to get to the row 2000, I'm liable to go to 200,000 instead. And it's all jerky when I scroll down. And sometimes I get that ever circling circle and have to wait an eternity before excel does something.

**Sam Capricci** · 11-17-2014, 02:07 PM

not sure i'm following your issue. the usual way i get around a large amount of data is to hold down control and shift then hit the down arrow, this takes me to the bottom of my data.
a way to get to a specific cell quickly is to simply type that cell address in the blank area to the left of the function bar (fx). That takes you right there.

**Interesting Ian** · 11-17-2014, 02:12 PM

Originally Posted by Sambo kid

not sure i'm following your issue. the usual way i get around a large amount of data is to hold down control and shift then hit the down arrow, this takes me to the bottom of my data.
a way to get to a specific cell quickly is to simply type that cell address in the blank area to the left of the function bar (fx). That takes you right there.

I want to delete the 995,000 blanks rows in each tab.

**Interesting Ian** · 11-17-2014, 02:33 PM

I think I've sorted it. Followed instructions of ACE XL from here:

http://www.excelforum.com/excel-gene...el-2013-a.html

Seemingly the only person on the Internet who knows how to delete blank rows in Excel!

**Sam Capricci** · 11-17-2014, 02:51 PM

Glad you found your solution. I've done what Ace recommended many times but I had trouble discerning that is what you needed from your narrative (probably my problem). I almost thought you wanted to only show the rows with data and no others. Don't forget to mark your post as solved AND, you are able to give kudos to ANY and ALL who've helped you here - ACE XL included even from that past post. I'm sure he'd appreciate it

**newdoverman** · 11-17-2014, 03:42 PM

This addin for Excel resets the last of your data and gets rid of excess formatting. I use it quite often and it works beautifully.
http://support.microsoft.com/kb/244435

**Interesting Ian** · 11-17-2014, 04:57 PM

Originally Posted by Sambo kid

Glad you found your solution. I've done what Ace recommended many times but I had trouble discerning that is what you needed from your narrative (probably my problem). I almost thought you wanted to only show the rows with data and no others. Don't forget to mark your post as solved AND, you are able to give kudos to ANY and ALL who've helped you here - ACE XL included even from that past post. I'm sure he'd appreciate it

Nobody ever seems to understand what I'm talking about. That is despite being able to articulate myself vastly better than the average person. I have absolutely no idea what you couldn't understand in my original post. How much detail do I need to go into??

**Interesting Ian** · 11-17-2014, 04:59 PM

I have no idea how to thank ACE XL?

How do I delete blank rows at the bottom of my data

LinkBack

Thread Tools

Rate This Thread

Display

How do I delete blank rows at the bottom of my data

Re: How do I delete blank rows at the bottom of my data

Re: How do I delete blank rows at the bottom of my data

Re: How do I delete blank rows at the bottom of my data

Re: How do I delete blank rows at the bottom of my data

Re: How do I delete blank rows at the bottom of my data

Re: How do I delete blank rows at the bottom of my data

Re: How do I delete blank rows at the bottom of my data

Thread Information

Users Browsing this Thread

Similar Threads

Delete all the extra blank rows at the bottom of spreadsheet

[SOLVED] Delete all unused blank rows at the bottom in excel 2013

How do I reset my vertical scroll and/or delete unwanted blank rows at the bottom?

[SOLVED] Excel 2007 : Blank Rows At Bottom of Sheet Will Not Delete

[SOLVED] How do I delete blank rows at the bottom of a spreadsheet to get .

Bookmarks

Bookmarks

Posting Permissions