Share via

How to remove all trailing blank lines in an Excel worksheet?

Anonymous
2021-07-14T22:15:37+00:00

I have an Excel worksheet containing many lines of data followed by many blank lines. I hope I can navigate to the bottom of data by pressing Ctrl-End, but since there are many blank lines after the data, the cursor actually goes to the last blank line, rendering me nothing but a whole white screen. So, I want to delete these trailing blank lines. I select the first blank line and press Shift-Ctrl-End, so it looks to me that all trailing blank lines are selected. But after clicking Home -> Delete -> Delete Sheet Rows, these lines still remain there; not a single line was deleted. What's the matter? What do I do to remove these annoying trailing blank lines in an Excel worksheet? I'm using Office Professional Plus 2019 on Windows 10 PC.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

9 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-09-08T17:11:41+00:00

    I'm facing right now the same issue, I found the following two solutions:

    1. rather long and boring, not tested - you can select the rows (not the cells) to delete and, of course, delete them
    2. way smarter - select rows or cells you want to keep and copy them to a new sheet

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2021-07-15T08:24:48+00:00

    I was asking: without add-on or VBA code, is there absolutely no way to remove trailing blank rows in a sheet?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2021-07-15T05:12:50+00:00

    Does your reply suggest that this task is so hard (e.g., I have to accomplish it by writing VBA code) (I would be very surprised that it is a hard task) that I have to install an add-on to do it easily?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2021-07-15T06:45:01+00:00

    For most users writing any VBA code is a difficult or impossible task, so using an add-on is a completely code free solution. Unfortunately advise isn't generally given here on how to write complete code segments.

    Kind Regards,

    Elise

    0 comments
  5. Anonymous
    2021-07-14T22:52:55+00:00

    Hi, I'm Elise, an Independent Advisor and I'd be happy to help with your issue.

    There is an add-on you can get for Excel which has a function for this, you might fin it useful:

    https://www.asap-utilities.com/

    Please let me know if you need any further assistance.

    Kind Regards,

    Elise

    Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

    0 comments