跳到主要內容

如何基於Excel中的單元格值自動刪除線?

在Excel中,我們可以應用刪除線來手動刪除不需要的單元格內容,但是,在本文中,我將討論如何基於單元格值自動刪除線。 例如,我想基於列E中的單元格值對行數據應用刪除線,如果單元格值為“ N”,則自動對相關行應用刪除線,如下面的屏幕截圖所示。

doc自動刪除線1

基於條件格式的單元格值自動刪除線


箭頭藍色右氣泡 基於條件格式的單元格值自動刪除線

事實上, 條件格式 Excel中的功能可以幫助您盡快完成此任務,請執行以下操作:

1。 選擇您要應用刪除線的數據范圍,然後單擊 首頁 > 條件格式 > 新規則,請參見屏幕截圖:

doc自動刪除線2

2。 在 新格式規則 對話框,請單擊 使用公式來確定要格式化的單元格 在選項 選擇規則類型 列錶框,然後輸入以下公式: = $ E2 =“ N” 格式化此公式為真的值 文本框,請參見屏幕截圖:

注意: 在上面的公式中: E2 和“N”是您要應用刪除線依據的單元格和文本值,請根據需要更改它們。

doc自動刪除線3

3。 然後點擊 格式 按鈕去 單元格格式 對話框,在 字體 選項卡,檢查 刪除線 來自 影響 列錶框,請參見屏幕截圖:

doc自動刪除線4

4。 然後點擊 OK > OK 關閉對話框,現在,當您輸入的值是特定的文本“ N”時,整個行數據將自動應用刪除線,請參見屏幕截圖:

doc自動刪除線5

最佳辦公生產力工具

熱門特色: 尋找、突出顯示或識別重複項   |  刪除空白行   |  合併列或儲存格而不遺失數據   |   沒有公式的回合 ...
超級查詢: 多條件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 (8)
Rated 5 out of 5 · 1 ratings
This comment was minimized by the moderator on the site
Hi,
How can I do if I want the row struckthrough if say EITHER B2= Yes OR I2 = 0?
If I just put it as OR($B2="Yes",$I2="0"), it wont strikethrough if both values are met.
Rated 5 out of 5
This comment was minimized by the moderator on the site
Is it possible to use this formula with a numeric value of zero? I cannot for the life of me get it to work that way but it will work with letters.
This comment was minimized by the moderator on the site
Hello friend,

Glad to help. Yes, you can use this formula =$E1= 0 with a numeric value of zero. Please see the screenshot, you can input formula =$E1= 0 into the Format values where this formula is true text box. Please note the first row of the data is header.
https://www.extendoffice.com/images/stories/comments/comment-zmt/strikethrough-value.png

Sincerely,
Mandy
This comment was minimized by the moderator on the site
Merci beaucoup :) <3 
This comment was minimized by the moderator on the site
I regularly wind up utilizing the strikethrough highlight in both Word and Excel to stamp things as finished. This component is genuinely clear in Word, as a strikethrough symbol shows up conspicuously on the Home tab in Word 2007 and later. Then again, in Excel this component doesn't have its own particular symbol, yet it has a console alternate route, Ctrl-5. However there's no worked in essay writing route for strikethrough in Word.
This comment was minimized by the moderator on the site
Hello everyone, I just have to say that this site is just amazing!
Much creative and extremely curricular website I have ever found while searching essay writing service on the Internet.
I am very satisfied with their work and inventory, everything looked very well and kept. I appreciate your work, keep up a great job.
This comment was minimized by the moderator on the site
This was a great help to me
This comment was minimized by the moderator on the site
Using the instructions from this page (Auto strikethrough based on cell value with Conditional Formatting) I am trying to add the proper formula to a spreadsheet with the cell value being a check mark (instead of N like the example). Ultimately, what I am trying to do is this: When I double click column A1, it will automatically add a check mark in that cell. In addition to the check mark, it will perform auto-strikethrough on cells B1 and C1. Is it possible to accomplish this? I had no problem entering a rule to add a check mark to a cell by double clicking it. And I had no problem adding the conditional formatting in order to auto strikethrough text. What I cannot seem to figure out is how to combine the 2 efforts. I do not like the idea of Check boxes and have tried that route already.
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations