Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

使用複製 命令 來複製欄。 如果您想要對欄進行重大變更,建議複製或複製原始欄,並變更新欄,這樣您不會不小心造成重新檢查錯誤。 詳細資訊,請參閱 處理資料來源錯誤

  1. 若要開啟查詢,請找出先前從 Power Query 編輯器載入的查詢,選取資料中的儲存格,然後選取查詢>編輯。 詳細資訊請參閱在 Excel 中建立、 載入或編輯查詢

  2. 選取要複製的欄。   

  3. 選取新增欄>

    您可能想要重新命名新欄。 詳細資訊,請參閱 重新命名欄


Power Query for Excel 説明

Need more help?

Want more options?



Was this information helpful?

How satisfied are you with the translation quality?
What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!