How to drop half empty rows down in excel?

D

D

Damian Lewis2020-06-24 22:38:12

excel

Damian Lewis, 2020-06-24 22:38:12

How to drop half empty rows down in excel?

Excel has a table with data. They are not completely filled. It is necessary that the rows in which there are empty cells move down, and completely filled ones remain at the top. How to do it?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

G

Grigory Boev, 2020-06-24
@DamianLewis

1) Add column F with formula
=ИЛИ(A1="";B1="";C1="";D1="";E1="";F1="")
2) Propagate down
3) Do sort A:E on column F

Similar questions

E

EVGENIJ NEFEDOV2018-03-03 23:39:34

How to replace x-english with x-russian in excel or other text editor? 1Reply

S

Sergey2015-11-01 13:44:28

How to attach an excel document to an email via phpmail? 2Reply

D

dmitriev_romka2020-05-06 19:06:32

How to fix an error when starting a vbs file with the Task Scheduler? 2Reply

P

photosho2021-07-09 13:26:52

Is it possible to convert cell indents to tabs? 1Reply

A

Alexander2020-05-10 15:23:02

New features in Excel. And a question about versions? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question