Excel remove blank rows in one action

Question

Excel remove blank rows in one action

Jonathan Brotto 1,076

Is there a way remove rows that have blanks in one short with bunch of tables in the middle. Each table is separated by space.

Ceasar Chen_MSFT 4,481 Reputation points

2022-03-31T06:50:34.6+00:00

Hi, @Jonathan Brotto
I'm working on it and will reply when there is progress.
Jonathan Brotto 1,076 Reputation points

2022-03-31T13:21:12.353+00:00

I see the solution and did try the go to statement but when I try to delete with ctrl + space bar and then ctrl - it does not work.
Ceasar Chen_MSFT 4,481 Reputation points

2022-04-01T08:56:03.543+00:00

Hi, @Jonathan Brotto
To help you better, please provide a sample screenshot of where the cell to be deleted is located. The following method is for your reference:
Use Ctrl+Delete to delete the contents of the cell, and the selected cell cannot be deleted. It is recommended to right-click the selected cell and select Table Rows in delete.
Jonathan Brotto 1,076 Reputation points

2022-04-01T14:51:21.503+00:00

Will this work in a non table setup?
Ceasar Chen_MSFT 4,481 Reputation points

2022-04-06T07:05:17.55+00:00

Hi, @Jonathan Brotto
Can you illustrate the problem with a simple case? As shown in the picture, do you want to delete red cells (non-table cells), or yellow cells (table cells)?

2 answers

Your answer

Ceasar Chen_MSFT 4,481 Reputation points

2022-03-31T06:50:34.6+00:00

Hi, @Jonathan Brotto
I'm working on it and will reply when there is progress.
Jonathan Brotto 1,076 Reputation points

2022-03-31T13:21:12.353+00:00

I see the solution and did try the go to statement but when I try to delete with ctrl + space bar and then ctrl - it does not work.
Ceasar Chen_MSFT 4,481 Reputation points

2022-04-01T08:56:03.543+00:00

Hi, @Jonathan Brotto
To help you better, please provide a sample screenshot of where the cell to be deleted is located. The following method is for your reference:
Use Ctrl+Delete to delete the contents of the cell, and the selected cell cannot be deleted. It is recommended to right-click the selected cell and select Table Rows in delete.
Jonathan Brotto 1,076 Reputation points

2022-04-01T14:51:21.503+00:00

Will this work in a non table setup?
Ceasar Chen_MSFT 4,481 Reputation points

2022-04-06T07:05:17.55+00:00

Hi, @Jonathan Brotto
Can you illustrate the problem with a simple case? As shown in the picture, do you want to delete red cells (non-table cells), or yellow cells (table cells)?

Answer 1

Hi, @Jonathan Brotto
I want to help you but I don't know the specific problem you describe, please provide a simple case and attach a screenshot, so that I can help you better.
Here is a possible case for your reference, delete the blank rows between the above two tables.

If you want to batch delete blank rows between multiple tables, you can use the positioning method:

First click any blank cell, press the shortcut key Ctrl+G to call up the positioning window, click Location Condition in the pop-up window, select Empty value, and then click OK.
Then go back to the Excel table, the blank cells are marked, right-click to select Delete, and click Entire Row - OK.

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Herbert Seidenberg 1,191

Excel 365 Pro Plus with Power Query.
Append space separated Tables.
With Table sources.
PivotTable ready.
https://www.mediafire.com/file/qdb8cluaesoiaow/03_31_22.xlsx/file
https://www.mediafire.com/file/fsogygk60o17o67/03_31_22.pdf/file

Jonathan Brotto 1,076 Reputation points

2022-04-01T14:48:34.263+00:00

Links are broken?
Herbert Seidenberg 1,191 Reputation points

2022-04-01T16:15:54.303+00:00

Worked for 3 others so far.
Jonathan Brotto 1,076 Reputation points

2022-04-01T16:18:19.117+00:00

Screen shot from my work PC.
Herbert Seidenberg 1,191 Reputation points

2022-04-01T17:37:51.187+00:00

.....from my "work" PC...
To be expected. Firewall.
Try at home.

Share via

Excel remove blank rows in one action

2 answers

Your answer