中国教程网论坛 » MS Excel » excel基础应用--如何划漂亮的装饰线

zhangditony 发表于 2007-8-10 16:09

excel基础应用--如何划漂亮的装饰线

Add a fancy line for Presentation
Put this formula in A1: =REPT("X",90) and on pressing enter,a line of X's will run along row 1.
Alter the character between the " ", and alter the 90 to shorten or extend the line.
With the cursor still in A1, experiment using cell format, changing the font, etc, and see the effect. Ideal for presentation.

在A2单元格中输入:[b]=REPT("X",90) [/b],然后按回车.会看到90个X组成的直线，改变A2的字体，将X变为其他字母并改变REPT函数的第二个参数，会得到不同长短，各式各样的装饰线。

[[i] 本帖最后由 zhangditony 于 2007-8-11 08:25 编辑 [/i]]

fashion 发表于 2007-8-10 16:20

哈哈，学了一招，谢谢

tiger88 发表于 2007-8-15 21:51

也学了一手,谢谢

查看完整版本: excel基础应用--如何划漂亮的装饰线