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
Ficus Discovery (Subsidiary of 8107.HK)-company-logo
Project Manager (eCommerce Platform)
Ficus Discovery (Subsidiary of 8107.HK)
Sha Tin, Hong Kong
Ficus Discovery (Subsidiary of 8107.HK)-company-logo
Technical Lead (eCommerce Platform)
Ficus Discovery (Subsidiary of 8107.HK)
Sha Tin, Hong Kong
Ficus Discovery (Subsidiary of 8107.HK)-company-logo
UX/UI Designer (eCommerce Platform)
Ficus Discovery (Subsidiary of 8107.HK)
Sha Tin, Hong Kong
FundPark Limited-company-logo
IT Manager
FundPark Limited
Kwun Tong, Hong Kong
Wristcheck-company-logo
Lead UI/UX Designer
Wristcheck
Central and Western, Hong Kong
Ficus Discovery (Subsidiary of 8107.HK)-company-logo
Software Architect (eCommerce Platform)
Ficus Discovery (Subsidiary of 8107.HK)
Sha Tin, Hong Kong
PeopleLink-company-logo
Golang System Analyst | Up to 60K | Commercial - Perm
PeopleLink
Central and Western, Hong Kong
PeopleLink-company-logo
Data Centre Operator - Banking
PeopleLink
Kwun Tong, Hong Kong