Home/ Questions/Q 7503
Next
In Process
Computing Staff
  • 0
Asked: 2021-11-24T09:45:23+00:00 In:

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