我的文件有3頁,當(dāng)看到第3頁時(shí),不想讓EXCEL因鼠標(biāo)滾動而下滑,怎樣辦?我想讓它滾到第3頁時(shí)就不能下滑了.

熱心網(wǎng)友

一個(gè)簡單的辦法就是你看這頁的時(shí)候按住shift鍵那么就不會滾動了

熱心網(wǎng)友

Hello, Hide the row from the one line below the last line in Page 3.For example. U have used up row 1 to row 100 for your 3 pages of report.Hide the row from 101 to 65536.This should prevent the user from scrolling to area that you don't want.Same trick for your to use on column.Good Luck,Chocobar

熱心網(wǎng)友

在EXCEL里有一個(gè)窗口,里邊有一個(gè)"鎖定窗口" ,把你想固定的位置選擇,然后鎖定就可以了.