如何刪除Excel的大量空列

理論上用刪除列是可以刪掉多餘的列，為何你說不可行?? 不過，這樣一來，好多公式都有機會出現#REF!。如果你的檔案不涉及私隱或機密，不妨電郵給我，讓我試試看。

圖片參考：http://i1087.photobucket.com/albums/j470/hsyc88/general/MailMe.gif


2011-02-01 08:15:55 補充：
這個會不會是你想要的結果：去到你有data的最下方一列，隨便點一個儲存格，然後按一下鍵盤的『end』鍵，save後關閉檔案，再打開檔案，應該看不到太多空列了吧。

2011-02-01 11:36:29 補充：
你另存新檔，highlight有公式的地方並填滿顏色然後del所有資料，再在最後一列隨便一空格上打個數字，儲存後電郵給我。這樣可以嗎?
(另：有office 2007，windows 7，沒有windows 2007)

有無試過
DELETE 完那些空列後，
回儲存格A1再儲存？

每次輸入data, 都load得很慢, 是公式問題, 公式運算中
工作表有大量的計算量很大的公式, 如陣列公式/sumproduct/vlookup
公式內的計算範圍很大, 如A1:A20000更是要命, 如定義名稱/格式條件/下拉清單內設定了大量公式, 更加慢上加慢
Excel 的計算能力及速度是有限的

Key point : You can remove only contents in cells by deleting them but you actually can't reduce the total number of rows (1048576 in Excel 2007). However, you CAN hide them. Try this:

(a) For example, you only need 1000 rows. Now Click cell A1 (or any cell of your coice) as your starting point. Press F5 key for Go To window. In Reference box, type A1001 then click OK. Now hold Ctrl + Shift keys then press the down arrow once and release all keys. Cursor should be at 1048576 row. Right click any highlighted row header at left then click Hide in menu. Your sheet will now have only 1000 rows. As I am not quite sure if this is what you want but I think it's close. It will cut down your running time for sure.

N.B. You can jump to A1 or any cell by entering its reference in Go To window (F5 key) as above.

(b) Now what if you need some of those hidden rows back? You can add multiple rows by block highlighting some existing rows with the Shift key, now right click any one of these row headers in the block at left then click Insert. Remember this is a 1 for 1 situation. That means you have to reserve some extra rows for expansion when needed. If your worksheet needs only 1000 rows now, I'd hide all rows after 1050. This will give you a block of 50 rows as reserve later on. However, ignore this part if no expansion is necessary.

Good Luck.

2011-02-01 18:40:28 補充：
Since you only need 40 rows, I'd limit row numbers to 50. You'll have 10 rows on reserve if needed. This will speed up your running time tremendously. Be sure to let me know if this is what you want.

this cannot delete!!!