新足迹

 找回密码
 注册

精华好帖回顾

· 东东爹教你在家做西餐---更新: wagyu beef tataki (2012-5-14) mickeymickey · 新年伊始,自己翻新投资房,争取用少资金短时间实现大效益(全文完,谢谢关注) (2012-1-9) ayeeda
· 发布一个预测:澳元在今后几年(两年)大概率维持在4-5之间兑换人民币 (2014-9-11) 大桥西 · 2019 面朝大海, 春暖花开 一 夏威夷之檀香山Honolulu+茂宜岛 Maui(全篇完) (2019-4-14) Pippa
Advertisement
Advertisement
查看: 1023|回复: 2

[IT] Excel watermark [复制链接]

发表于 2006-10-13 11:44 |显示全部楼层
此文章由 sayaaz 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 sayaaz 所有!转贴必须注明作者、出处和本声明,并保持内容完整
在Excel 里能像在word 里一样,自己设计watermark 吗?

我只找到在printer的设置里可以有 watermark, 但只有 draft, confidentilal, sample 这3个选择, 不够用。

高手请赐教。
Advertisement
Advertisement

发表于 2006-10-13 11:54 |显示全部楼层
此文章由 goldenapple 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 goldenapple 所有!转贴必须注明作者、出处和本声明,并保持内容完整
Mimic a watermark in Excel   
Watermark functionality is not available in Excel. If you want to display a graphic on every printed page (for example, to indicate that the information is confidential), you can insert the graphic in a header or footer. This way, the graphic appears behind the text, starting at the top or bottom of every page. You can also resize or scale it to fill the page.

On the View menu, click Header and Footer.
In the Page Setup dialog box, click Custom Header or Custom Footer.
Click in the Left section, Center section, or Right section box.
In the row of buttons in the Header or Footer dialog box, click Insert Picture  and then find the graphic you want to insert.
Double-click the graphic to insert it in the header or footer section box.
To resize or scale the graphic, click Format Picture  in the row of buttons in the Header or Footer dialog box and then, in the Format Picture dialog box, select the options you want on the Size tab.

Notes

Changes to the graphic or graphic format take place immediately and can't be undone.

If you want to add blank space above or below a graphic, click before or after &[Picture], and then press ENTER to start a new line.

To replace a graphic, select &[Picture], click Insert Picture , and then click Replace.
Before printing, make sure the header or footer margin allows enough space for the custom header or footer.

To delete a graphic, select &[Picture] and then press DELETE.
我,梦到未来,牵着你的手,幼小的肩膀大大的头。
我,不要你去管,太多的愁,只想你去照顾善良的虫。

发表于 2006-10-13 14:50 |显示全部楼层
此文章由 sayaaz 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 sayaaz 所有!转贴必须注明作者、出处和本声明,并保持内容完整
Thanks.

Currently I use  ' word art'  & format the fill color in grey & adjust the transparency.

looks like there is no easy way.

发表回复

您需要登录后才可以回帖 登录 | 注册

本版积分规则

Advertisement
Advertisement
返回顶部