让Excel起飞的小技巧学生来看答:先在单元格中输入成绩,然后按option+回车在单元格中换行,紧接着在第二行中输入姓名,在姓名的前面敲几个空格,然后点击这个单元格按command+1调出格式窗口,然后选择边框,我们选择斜边框即可 十二,制作对比数据条 先选中右边的数据,找到条件格式,选择数据条,为它设置一条数据条,然后我们选择左边,同样为他添加一个数据...
Excel对应的列某一个单元格中不为空值,怎么提取这列某一行的文字?答:Excel版本低呢,就用我这个土一点的公式,N2单元格公式=TRIM(MID(IF(B2="","",","&B$1)&IF(C2="","",","&C$1)&IF(D2="","",","&D$1)&IF(E2="","",","&E$1)&IF(F2="","",","&F$1)&IF(G2="","",","&G$1)&IF(H2="","",","&H$1)&IF(I2=""...