敬惠飞 發表於 2020-2-24 00:00:00

如何删除空白单元格?

<p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">使用</span>WPS Office打开表格,选中需要操作的区域。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">依次点击</span>“开始”---&gt;“查找”---&gt;“定位”</span><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">。</span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">或者快捷键</span>“Ctrl+G”打开定位功能,</span><span style="font-family: 微软雅黑; font-size: 16px;">选择“空值”后点击“定位”</span><span style="font-family: 微软雅黑; font-size: 16px;">。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">鼠标右键其中任意一个定位后的空值,选择</span>“删除”</span><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">即可。</span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px">&nbsp;</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><img src="https://res1.wpsacdm.cache.wpscdn.cn/images/0b761e546f751d3c6d055db7c8767eb0.gif" title="如何删除空白单元格?.gif" alt="如何删除空白单元格?.gif"></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><br></span></p><p><br></p>
頁: [1]
查看完整版本: 如何删除空白单元格?