Computing Staff
  • 0

Is There A Formula To Skip Blank Rows In Excel?

  • 0

I have a data set that looks like:

9018.010.00008
9018.010.00007
(Blank)
(Blank)
(Blank)
AKM32C-ACC2R-00
(Blank)
152.01.100

I want it to look like:

9018.010.00008
9018.010.00007
AKM32C-ACC2R-00
152.01.100

Share

2 Answers

  1. Remove blank rows in Excel
    This technique works if there’s a column in your table that helps to see if it’s an empty row or not (a key column). for instance, it are often a client ID or order range or something similar.

    It is necessary to save lots of the rows order, thus we will not simply type the table by that column to move the blank rows to the lowest.

    Use Filter Button for this issue and click here for better understanding with screenshots.

    message edited by aren111

    • 0
  2. Another quick way is to
    Select your range of cells
    Click F5
    In the Go To dialog box,
    Click Special.
    Click the Blanks option
    Click OK.

    On the Home tab,
    Click the Delete drop down
    Choose Delete Cells.

    Excel should display the Delete dialog box,
    Select Shift Cells Up option

    Click OK

    • 0