如何列印excel文件, 由sheet 1開始以後的都要用橫向,而且每頁邊界固定不變?

2007-02-04 1:45 pm
現在要每頁由sheet 1到30都要重新設定列印邊界, 是非常麻煩呢!共有14個活頁簿, 真煩!

回答 (1)

2007-02-04 8:19 pm
✔ 最佳答案
首先你要選all the sheets (or the sheets that you want to have same margin and print in landscape). To select all the worksheet, press and click all the sheets or the sheets that you want to have same margin and print in landscape.

After selecting the sheet, 設定列印邊界和橫向, 便會apply to all worksheets ga la.


收錄日期: 2021-04-26 12:58:26
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070204000051KK00519

檢視 Wayback Machine 備份