Excel教學--介紹Excel的撤銷與重做功能(Excel入門操作)

Excel教學

Share to
By Michael Li
--
Article Cover Image (TechJobAsia)

撤銷

撤銷功能可讓您撤銷操作。

如果您對某項操作感到後悔並想恢復到先前的狀態,則「撤銷」會很有幫助。

使用範例

  • 撤銷刪除公式
  • 撤銷新增列
  • 撤銷刪除行

**注意:**您無法撤銷在「檔案」功能表中執行的操作,例如刪除工作表、儲存電子表格或變更選項。經驗法則是您可以撤銷在工作表中執行的操作。

有兩種方法可以存取撤消命令。

  1. 按下功能區中的撤銷按鈕:

article imagearticle image

  1. 使用鍵盤快速鍵 CTRL + Z / Command + Z

讓我們來看一個例子:

article imagearticle imagearticle imagearticle image

注意:建議練習使用鍵盤快速鍵。它可以節省您的時間!

重做

Redo 功能與 Undo 具有相反的效果,它反轉 Undo 操作。

如果您後悔使用“撤消”,“重做”會很有幫助。

**注意:**只有使用「撤銷」後,「重做」指令才可用。

有兩種方法可以存取重做命令。

  1. 按下功能區中的重做按鈕:

article imagearticle image

  1. 使用鍵盤快速鍵 CTRL + Y / Command + Y

**提示:**自己練習熟悉撤銷和重做。

Share to
By Michael Li
--
Related jobs
Introv-company-logo
ERP Full-stack Consultant
Introv
Kwun Tong, Hong Kong
Recruit Squad Limited-company-logo
Team Lead / Senior Mobile App Developer (Generous Package!)
Recruit Squad Limited
Central and Western, Hong Kong
Recruit Squad Limited-company-logo
Senior System Analyst/ System Analyst
Recruit Squad Limited
Central and Western, Hong Kong
Recruit Squad Limited-company-logo
IT Project Manager / Business Analyst
Recruit Squad Limited
Central and Western, Hong Kong
Recruit Squad Limited-company-logo
Senior/Junior Mobile Developer (Welcome Fresh Graduates!)
Recruit Squad Limited
Central and Western, Hong Kong
JustOneGalaxy Recruitment-company-logo
SAP Developer (MNC, Perm role & work-life balanced)
JustOneGalaxy Recruitment
Kwun Tong, Hong Kong
JustOneGalaxy Recruitment-company-logo
System Support/ IT Support/ Helpdesk/ Data Center Operator (Multiple Headcounts)
JustOneGalaxy Recruitment
Central and Western, Hong Kong
JustOneGalaxy Recruitment-company-logo
Embedded Software Engineer/ Firmware Engineer (2-3 years exp, MNC)
JustOneGalaxy Recruitment
Kwun Tong, Hong Kong
The Hong Kong Jockey Club-company-logo
Data Engineer (Trading and Player Risk)
The Hong Kong Jockey Club
Central and Western, Hong Kong