How to pull the contents of the cells to top?

V

V

vladislavik952021-12-29 13:05:31

Google Sheets

vladislavik95, 2021-12-29 13:05:31

How to pull the contents of the cells to top?

How can I pull the contents of the cells up, that is, remove all empty cells?

Yes, it can be done with a filter, but I have 3400 columns and it will be long. And secondly, somewhere there will be empty cells in the column because the fitr filters the entire table/column.

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

2 answer(s)

A

Alexander, 2021-12-29
@ForestAndGarden

Select a column, then sort. To automate, record a macro.

Similar questions

S

Serg77772021-11-11 16:00:06

Is there a way to pass to a google sheets document the path to a shortcut on the computer that opens google sheets? 1Reply

K

kos-da-bos2016-04-09 13:03:32

How to customize cell formatting in Google Sheets? 1Reply

A

Avaran2021-11-23 14:48:11

How to automate Google sheets automatic update of incoming data for a contract from the Google survey forms registration table? 1Reply

A

aparuev2018-09-17 07:42:46

Why is the date calculated incorrectly? 1Reply

D

delongeroman2020-08-19 00:05:24

How to work with date format in google sheets? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question