这篇文章将教你如何用三种方法删除谷歌电子表格中的空白行。你可以使用筛选功能一行一行地删除它们,也可以使用插件删除所有空白行和单元格。
步骤
方法 1 的 3:
逐行删除空白行
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/e\/e2\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/e\/e2\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
1
在网络浏览器中前往 https://sheets.google.com 页面。如果登陆了谷歌账户,会直接打开账户相关的谷歌电子表格列表。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/3\/39\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/3\/39\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
2
点击谷歌电子表格文档。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/f\/ff\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/f\/ff\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
3
右键点击行编码。行的编码位于最左侧、灰色栏中。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/3\/30\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/3\/30\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
4
点击删除行。
方法 2 的 3:
使用筛选功能
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/f\/fc\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/f\/fc\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
1
在网络浏览器中前往 https://sheets.google.com 页面。如果登陆了谷歌账户,会直接打开账户相关的谷歌电子表格列表。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/a\/a6\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/a\/a6\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
2
点击谷歌电子表格文档。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/b\/b5\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/b\/b5\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
3
点击并选中全部数据。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/1\/1a\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-8.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-8.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/1\/1a\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-8.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
4
点击数据选项卡。它位于顶部菜单栏中。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/7\/70\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-9.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-9.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/7\/70\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-9.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
5
点击筛选。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/5\/52\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-10.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-10.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/5\/52\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-10.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
6
点击由三条直线组成的绿色三角形图标,它位于左上角的单元格中。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/0\/01\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-11.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-11.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/0\/01\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-11.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-11.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
7
点击A → Z排序。这会将所有空白单元格移动到底部。
方法 3 的 3:
使用插件
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/8\/82\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-12.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-12.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/8\/82\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-12.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-12.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
1
在网络浏览器中前往 https://sheets.google.com 页面。如果登陆了谷歌账户,会直接打开账户相关的谷歌电子表格列表。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/c\/c8\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-13.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-13.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/c\/c8\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-13.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-13.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
2
点击谷歌电子表格文档。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/f\/fa\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-14.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-14.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/f\/fa\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-14.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-14.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
3
点击插件选项卡。它位于顶部菜单栏中。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/8\/8d\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-15.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-15.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/8\/8d\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-15.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-15.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
4
点击获取插件。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/d\/d8\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-16.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-16.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/d\/d8\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-16.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-16.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
5
在搜索栏里输入移除空白行,按下回车键。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/b\/bd\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-17.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-17.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/b\/bd\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-17.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-17.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
6
点击+ 免费。它位于“删除空白行(及更多)”插件的旁边,图标是一个橡皮擦图案。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/d\/de\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-18.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-18.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/d\/de\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-18.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-18.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
7
点击谷歌账户。如果你有多个账户,它会询问你将插件应用到哪个账户。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/4\/4c\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-19.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-19.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/4\/4c\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-19.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-19.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
8
点击允许。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/4\/4f\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-20.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-20.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/4\/4f\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-20.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-20.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
9
再次点击插件选项卡,它位于顶部菜单栏。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/7\/75\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-21.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-21.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/7\/75\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-21.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-21.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
10
选择移除空白行(及更多)。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/5\/5c\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-22.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-22.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/5\/5c\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-22.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-22.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
11
点击删除空白行/列。这会在右侧栏内打开插件选项。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/6\/61\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-23.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-23.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/6\/61\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-23.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-23.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
12
点击电子表格左上角的灰色空白单元格,选中整个电子表格。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/c\/cc\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-24.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-24.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/c\/cc\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-24.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-24.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
13
点击删除。它位于“移除空白行(及更多)”插件选项中。