{"id":370,"date":"2017-06-01T13:38:32","date_gmt":"2017-06-01T05:38:32","guid":{"rendered":"http:\/\/owa.sodexo-cn.com\/blog\/?p=370"},"modified":"2017-06-01T13:43:13","modified_gmt":"2017-06-01T05:43:13","slug":"how-to-delete-empty-rows-quickly-in-excel","status":"publish","type":"post","link":"https:\/\/owa.sodexo-cn.com\/blog\/?p=370","title":{"rendered":"How to delete empty rows quickly in Excel"},"content":{"rendered":"

Let’s see this column of data, there are a lot of empty rows in this column, this is a problem we often encounter after we delete some data. How can I quickly delete these empty rows while preserving the original data? This way is to filter out empty rows, then delete the empty rows, and sort them in the original order of the table.
\n<\/span><\/p>\n

<\/a>Step\u00a0:
\n<\/span><\/h2>\n

We open an Excel table with a blank row.<\/span>
\n<\/span><\/span>\"\"
\n<\/span><\/p>\n

At the right of the datasheet, the E1 cell enters the word “sort” as the header
\n<\/span>\"\"3
\n<\/span><\/p>\n

In the E2 cell, enter the number 1 and fill a sequence.
\n<\/span>\"\"4
\n<\/span><\/p>\n

The sequence you get the following figure.
\n<\/span>\"\"5
\n<\/span><\/p>\n

We select a column that contains blank rows, and the following figure selects the ‘request’ column, and then clicks the sort A to Z on the toolbar.
\n<\/span>\"\"
\n<\/span><\/p>\n

Drag the datasheet to the bottom and we can see that the empty rows have been filtered out,and then delete them.
\n<\/span>\"\"\"\"
\n<\/span><\/p>\n

After the deletion, we select this column and then click the Sort on the toolbar to restore the data to its original order.
\n<\/span>\"\"
\n<\/span><\/p>\n

Finally, select the Sort column and delete it. This column just to record the order of data is now useless.
\n<\/span>\"\"
\n<\/span><\/p>\n

See you next week.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Let’s see this column of data, there are a lot of … \u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-370","post","type-post","status-publish","format-standard","hentry","category-tips"],"views":2192,"_links":{"self":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/370","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=370"}],"version-history":[{"count":3,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/370\/revisions"}],"predecessor-version":[{"id":374,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/370\/revisions\/374"}],"wp:attachment":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=370"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}