如何在同一時間看2個excel ?

2007-11-01 9:18 pm
如何在同一時間 , 同一畫面看2個excel ?

回答 (2)

2007-11-02 9:51 am
✔ 最佳答案
In Excel toolbar,

click WINDOWS

If you want to look into 2 different worksheets, you can click ARRANGE and you can see 2 worksheets at the same time.

If you want to see different part of the same worksheet at the same time, you can take advantage of the function FREEZE PANES and SPLIT SCREEN.
For example you want to see Row 1 and Row 100 at the same time, you can use that function.

I hope that helps.
2007-11-01 9:34 pm
如果你用的是 excel2003 的話,在 window menu 下有一個 compare side by side (中文版唔知叫乜) 的功能,便能做到你的要求。

如果用較舊的版本,同樣在 window menu 下,有 arrange 的功能,同樣可以控制視窗的排列。


收錄日期: 2021-05-03 12:03:27
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20071101000051KK01129

檢視 Wayback Machine 備份