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

I

Ivan Medvedev2020-03-04 08:06:16

How to make several page layout options depending on the value of a variable? 2Reply

P

pompus2015-07-12 17:27:18

How to copy text in excel by columns (more in the table of contents)? 2Reply

V

Vladimir Yegudin2019-11-21 13:29:57

What is the best way to generate large and complex Excel documents? 0Reply

E

eldar_web2017-06-23 03:58:41

But how to solve the problem if Ruby on Rails does not have a tool for generating excel that can set auto-height for a cell? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question