跳到主要內容

如何在Excel中將單元格內容轉換為註釋?

也許您有一個包含一些信息的單元格區域,現在您想將這些單元格內容轉換為工作表中的註釋。 您可以在Excel中完成此任務嗎? 以下是解決此問題的一些快速技巧。

將單元格內容轉換為註釋 VBA代碼

快速將單元格內容轉換為註釋 Excel的Kutools


箭頭藍色右氣泡 使用VBA代碼將單元格內容轉換為註釋

以下簡短的VBA代碼可以幫助您將單元格內容轉換為註釋,並且可以通過以下步驟應用代碼:

1。 選擇要轉換為註釋的單元格值的範圍。

2。 點擊 開發者 > Visual Basic中,一個新的 適用於應用程序的Microsoft Visual Basic 將顯示一個窗口,單擊 插入 > 模塊,然後將以下代碼輸入到模塊中:

Sub CellToComment()
'Updateby20140509
Dim Rng As Range
Dim WorkRng As Range
On Error Resume Next
xTitleId = "KutoolsforExcel"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
For Each Rng In WorkRng
    Rng.NoteText Text:=Rng.Value
Next
End Sub

3然後點擊 文檔劃分-5 按鈕執行代碼。 然後會彈出一個對話框,供您選擇要轉換的範圍,然後單擊 OK,那麼所有選定的單元格內容都已轉換為註釋。 查看屏幕截圖:


文檔單元到評論1 -2 文檔單元到評論2

箭頭藍色右氣泡使用Kutools for Excel快速將單元格內容轉換為註釋

作為Excel初學者,VBA代碼對您來說有點困難。 因此,我將向您介紹一種簡單的處理方法。

Excel的Kutools : 帶有300多個便捷的Excel加載項,可以在30天內免費試用。 立即獲取

如果您已安裝Kutools for Excel,則 轉換評論和單元格 of 庫工具 可以幫助您快速方便地將單元格內容轉換為註釋。 請執行以下操作:

1。 突出顯示您要將其轉換為註釋的範圍。

2。 點擊 庫工具 > 更多 > 轉換評論和單元格,請參見屏幕截圖:

3。 在 轉換評論和單元格 對話框中選擇 將單元格內容轉換為註釋 選項。 看截圖:

4。 點擊 OK。 並且所有選定的單元格內容都已轉換為單元格註釋。 看截圖:

這款獨特的敏感免洗唇膜採用 Moisture WrapTM 技術和 Berry Mix ComplexTM 成分, 轉換評論和單元格 功能,您還可以將註釋轉換為單元格內容。 有關更多詳細信息 轉換評論和單元格, 請拜訪 轉換註釋和單元格功能描述.


相關文章:

最佳辦公生產力工具

熱門特色: 尋找、突出顯示或識別重複項   |  刪除空白行   |  合併列或儲存格而不遺失數據   |   沒有公式的回合 ...
超級查詢: 多條件VLookup    多值VLookup  |   跨多個工作表的 VLookup   |   模糊查詢 ....
高級下拉列表: 快速建立下拉列表   |  依賴下拉列表   |  多選下拉列表 ....
欄目經理: 新增特定數量的列  |  移動列  |  切換隱藏列的可見性狀態  |  比較範圍和列 ...
特色功能: 網格焦點   |  設計圖   |   大方程式酒吧    工作簿和工作表管理器   |  資源庫 (自動文字)   |  日期選擇器   |  合併工作表   |  加密/解密單元格    按清單發送電子郵件   |  超級濾鏡   |   特殊過濾器 (過濾粗體/斜體/刪除線...)...
前 15 個工具集12 文本 工具 (添加文本, 刪除字符,...)   |   50+ 圖表 類型 (甘特圖,...)   |   40+ 實用 公式 (根據生日計算年齡,...)   |   19 插入 工具 (插入二維碼, 從路徑插入圖片,...)   |   12 轉化 工具 (數字到單詞, 貨幣兌換,...)   |   7 合併與拆分 工具 (高級合併行, 分裂細胞,...)   |   ... 和更多

使用 Kutools for Excel 增強您的 Excel 技能,體驗前所未有的效率。 Kutools for Excel 提供了 300 多種進階功能來提高生產力並節省時間。  點擊此處獲取您最需要的功能...

kte選項卡201905


Office選項卡為Office帶來了選項卡式界面,使您的工作更加輕鬆

  • 在Word,Excel,PowerPoint中啟用選項卡式編輯和閱讀,發布者,Access,Visio和Project。
  • 在同一窗口的新選項卡中而不是在新窗口中打開並創建多個文檔。
  • 將您的工作效率提高 50%,每天為您減少數百次鼠標點擊!
Comments (7)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Is there any plan to convert to Comments instead of notes for the functionality of the new Excel versions?
This would be very helpful

Here is a VBA that works but a Kutools shortcut would be nice as it would work in any file extension instead of only Macro compatible

Convert Cell Content to Comment
Sub ConvertToComment()
Dim C As Range
For Each C In Selection
C.ClearComments
If Len(C.Value) > 0 Then
C.AddComment
C.Comment.Text C.Value & ""
End If
'Optional: Delete cell content after converting
C.ClearContents
Next C
End Sub
This comment was minimized by the moderator on the site
hi! hi about new Excel comments option, not notes?
This comment was minimized by the moderator on the site
Hi, I use this macro to check old values in a range of cell. How can add comments to existing comments with a text. eg - first value is 1000. then I run the macro is must come as "was 1000" in comments. now I have changed value to 900. Next time I run the macro on same cell or cells it must show as "was900 was1000" now changed value to 800. so when I check cell comments I can see value actually dropped from 1000 to 900 and currently it is 800.
This comment was minimized by the moderator on the site
I need help to enter new row. However there are few condition . 1.> I need each row for Col A1(for ID# i.e. A1, A2..A25) as progressive addition when every time new row is entered. If , I'm entering new row after A20 then next row should have ID# as A21. It should always insert the row below last used row. 2.> Similarily, I need to add in progressive hyperlink cell value in the column "H1" onward. Is this possible, If yes, please advise.
This comment was minimized by the moderator on the site
I'm using Excel 2010 and facing same issue i.e. when char length is more than it skip to convert in comment. Please could you please advise as what change needs to be made in code to not limit the char length.
This comment was minimized by the moderator on the site
what is the string length limit for the conversion? It appears cells with Cell content longer than 255 are skipped. It would at least be better to get the first 255 characters converted
This comment was minimized by the moderator on the site
[quote]what is the string length limit for the conversion? It appears cells with Cell content longer than 255 are skipped. It would at least be better to get the first 255 characters convertedBy Darrel Stickler[/quote] Hello, please tell me the version information of your Excel. There is no such issue with Kutools for Excel 7.00. :) please contact me at jaychivo#extendoffice.com
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations