Excel中所有空格如何自动填入上一行相同数字或内容

Posted in 实用分享 on 6/29/2008 by 00 – 1,767 views.

1、假设B2:B21区域是要操作的“字段内容”，选定B2:B21单元格
2、按“Ctrl+G”－“定位条件……”－“空值”
3、在编辑栏内输入“=B2”(即空格最近的有内容的上一行)，Ctrl+Enter
4、选定B2:B21单元格，Ctrl+C,“选择性粘贴……”－“数值”(可省)

Excel中所有空格如何自动填入上一行相同数字或内容
.

Tags: ,

This entry was posted on 星期日, 六月 29th, 2008 at 10:37 and is filed under 实用分享. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply