EXCEL 頁尾顯示存檔路徑

To put a path and filename into a header or footer in Excel:
1. Select the worksheet whose header or footer you want to change.
2. Choose the Page Setup option in Print Preview. Excel displays the Page Setup dialog box.
3. Click on either the Custom Header or Custom Footer buttons, as desired. Excel displays either the Header or Footer dialog box.
4.Position the insertion point in the Left Section, Center Section, or Right Section boxes, as desired.
5. Click on the File button. (It looks like a file folder with a piece of paper sticking out.) Excel inserts the following code at the insertion point:
&[Path]&[File]
6. Click on OK two times to close both dialog boxes.

When you print the worksheet, Excel replaces the codes in step 5 with the path name and the file name of the workbook, respectively.

To insert the path and file name into the footer or header of document:
1. Open Microsoft Word.
2. Click the "Insert" tab.
3. In the "Header & Footer" group, click "Header" or "Footer."
4. Select a Header or Footer from the list.
5. Return to the "Insert" tab.
6. In the "Text" group, click [Quick Parts].
7. Click "Field."
8. Under "Field Names," select "FileName."
9. In the "Field properties" area, select a format.
10. In the "Field options" area, check "Add path to filename."

The path and filename will now appear in the header or footer.

word
拉下 "檢視" ,
見頁首 / 頁尾,
進入
見圖案和插入自動圖文集.逐個試試


excel
與上述大致相同, 但只能自動打出檔案名.
其餘要自己輸入

係footer 自己打入。。。。。