Summary of Ways to Delete Blank Lines in Excel 2007, 2010

This article provides a clear overview of Summary of Ways to Delete Blank Lines in Excel 2007, 2010, with the main facts, useful context, and practical details organized for easy reading.

In this case, if the data is small, it can be done manually to delete, but for large data, this method will not be possible because it takes too much time. So is there a way to quickly remove blank lines? Today, Vietnamese Software Channel will introduce to everyone two simple methods to quickly delete blank data lines and below are the ways to do this.

1. Use the available functions

a.Method 1:

- B1: Select all data to be deleted (If of data many Excel will not allow to select all, then it is mandatory to select each part)

- B2: Press Ctrl + G, a dialog box appears

Summary of Ways to Delete Blank Lines in Excel 2007, 2010 example screenshot 2

- B3: Click the Special button

- B4: Click to select Blanks

Summary of Ways to Delete Blank Lines in Excel 2007, 2010 example screenshot 3

- B5: Select the Home Tab, click the Delete icon on the Toolbar

Summary of Ways to Delete Blank Lines in Excel 2007, 2010 example screenshot 4

- B6: Click Delete Sheet Rows

After performing the above steps, all the blank lines that have been selected will be deleted.

b.Method 2:

- B1: Select all data

- B2: Go to DataFilter Tab

Summary of Ways to Delete Blank Lines in Excel 2007, 2010 example screenshot 5

- B3: Uncheck Select All

- B4: Drag the slider to the bottom

Summary of Ways to Delete Blank Lines in Excel 2007, 2010 example screenshot 6

- B5: Check (Blanks) and click OK, all blank lines will be filtered

Summary of Ways to Delete Blank Lines in Excel 2007, 2010 example screenshot 7

- B6: Select Home Tab, click the Delete icon on the Toolbar

Summary of Ways to Delete Blank Lines in Excel 2007, 2010 example screenshot 8

2. Use VBA

- B1: Press ALT + F11 to start the Visual Basic Editor.

- B2: Go to the InserModule menu

Summary of Ways to Delete Blank Lines in Excel 2007, 2010 example screenshot 9

- B3: Enter the whole of the following code into the Code edit screen

Sub DeleteBlankRows ()

Dim i As Long

If WorksheetFunction. CountA (Selection) = 0 Then

MsgBox "If you can choose any", vbInformation, "kenhphanmemviet. blogspot. com"

Exit Sub

End If

With Application

. Calculation = xlCalculationManual

. ScreenUpdating = False

For i = Selection. Rows. Count To 1 Step -1

If WorksheetFunction. CountA (Selection. Rows (i)) = 0 Then

Selection. Rows (i). EntireRow. Delete

End If

Next i

. Calculation = xlCalculationAutomatic

. ScreenUpdating = True

End With

End Sub

- B4: Return to Excel working screen with Alt + Q combination

- B5: Select all data to delete blank lines

- B6: Select Tab ViewMacrosView Macros

Summary of Ways to Delete Blank Lines in Excel 2007, 2010 example screenshot 10

- B7: Select Macro DeleteBlankRows and click Run button

After executing this Macro, all blank lines in the selected data area are automatically deleted.

The above are ways to delete blank data lines, depending on the habits of each person and choose the appropriate way to do it.

social shareand social share

FAQ

What is the main focus of Summary of Ways to Delete Blank Lines in Excel 2007, 2010?

The article explains the most important facts, context, and practical details related to Summary of Ways to Delete Blank Lines in Excel 2007, 2010.

Who may find this information useful?

It is useful for readers who want a clear overview, practical context, and a better understanding of the subject.

What should readers verify before taking action?

Check current product versions, official requirements, regional availability, and any details that may have changed since the original publication.

FAQ

What is the main focus of Summary of Ways to Delete Blank Lines in Excel 2007, 2010?

Who may find this information useful?

What should readers verify before taking action?

Reader Comments 0

Related Articles