+ Reply to Thread
Results 1 to 9 of 9

how can i eliminate blank rows that exist beyond the last non-bank row?

  1. #1
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    how can i eliminate blank rows that exist beyond the last non-bank row?

    my spreadsheet has more than a million blank rows after the last non-blank row.
    how can i eliminate those blank rows?
    Last edited by Joe Miller; 06-03-2018 at 11:38 AM. Reason: edited link to cross post

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Cool Re: how can i eliminate blank rows that exist beyond the last non-bank row?

    maybe try hide rows

    hiderows.gif
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,601

    Re: how can i eliminate blank rows that exist beyond the last non-bank row?

    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: how can i eliminate blank rows that exist beyond the last non-bank row?

    ''Click on the first blank, ctrl-shift-down arrow, hide the rows'' worked for me.

    thanks all you guys, you are a great resource!

    please let me know if it was me that cross posted? i don't think it was?

    how do i mark this thread as ''answered''

  5. #5
    Banned User!
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: how can i eliminate blank rows that exist beyond the last non-bank row?

    Quote Originally Posted by Joe Miller View Post
    please let me know if it was me that cross posted? i don't think it was?
    Unless by coincidence somebody else with the same name as you asked the exact same question as you on another forum a few hours before you asked it here, then yes, it was definitely you.

  6. #6
    Forum Contributor
    Join Date
    12-26-2005
    Location
    annapolis, Md.
    MS-Off Ver
    2007
    Posts
    260

    Re: how can i eliminate blank rows that exist beyond the last non-bank row?

    Quote Originally Posted by jason.b75 View Post
    Unless by coincidence somebody else with the same name as you asked the exact same question as you on another forum a few hours before you asked it here, then yes, it was definitely you.
    sorry about that... i have no idea how it happened?

    how do i mark the thread solved?

  7. #7
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: how can i eliminate blank rows that exist beyond the last non-bank row?

    If that takes care of your original question, & to say Thanks and for better Motivation, please
    1. click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
      then
    2. select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
    If you did it already - ignore it.
    Thank you.

  8. #8
    Banned User!
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: how can i eliminate blank rows that exist beyond the last non-bank row?

    Quote Originally Posted by Joe Miller View Post
    sorry about that... i have no idea how it happened?
    Not something that can happen by accident, you would have to sign in (or create a profile if you didn't already have one there), start a new thread, type the question, and submit it.

    That is quite a lot to do and not be aware of, especially as you have been back there and replied to the help provided several times.

    The only reasonable assumption I can make is that you do not fully understand the meaning of cross posting. Please take a moment to read post #3, and the page that Ford has provided a link to there.

    After doing so, please also take the time to edit your first post in this thread with a link to your cross post.

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,601

    Re: how can i eliminate blank rows that exist beyond the last non-bank row?

    I suppose it IS possible that someone with the same name OR the same question posted on the other forum, but when BOTH match, that is a bit of a stretch.

    It's not that it is prohibited, just that you are required to notify where else you may have posted (both ways), so members dont waste time answering something that may already have been answered elsewhere

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 02-23-2015, 09:42 PM
  2. SumIF and eliminate blank rows
    By jkktx81 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-06-2015, 07:34 PM
  3. [SOLVED] Eliminate blank rows when pulling criteria based data from one spreadsheet to another
    By Terisammis in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-28-2014, 10:39 AM
  4. Replies: 7
    Last Post: 02-01-2014, 01:48 AM
  5. VBA Macro to eliminate cells with a blank value
    By paulxl in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-27-2012, 10:23 AM
  6. Eliminate Blank Cells
    By ruby1766 in forum Excel General
    Replies: 20
    Last Post: 06-18-2009, 05:24 PM
  7. Eliminate blank rows by shifting rows up
    By jman0707 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-06-2008, 02:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1