从Excel电子表格中仅删除特定颜色的文本，并使用不同颜色的文本 [英] Delete text only of a specific color from an Excel spreadsheet with text in different colors

问题描述

我有一个电子表格，里面有两种颜色的文本，通常在同一单元格中.我想运行一个宏，该宏只从出现的每个单元格中删除黑色文本.

I have a spreadsheet with text in two colors, often in the same cells. I would like to run a macro which deletes only the black text from each cell in which it appears.

推荐答案

如果您不想使用宏，为什么不使用查找并选择"工具.转到替换".选择选项".选择格式"，然后选择字体颜色或单元格颜色选项.选择要消除的颜色，将替换为"框保留为空白，然后单击全部替换"

If you don't want to use a macro, why not use the "find and select" tool. Go to "replace". select "options". Select "format" and select the font colour or cell colour option. choose the colour you want to get rid of, leave the "replace with" box blank and click "replace all"

这篇关于从Excel电子表格中仅删除特定颜色的文本，并使用不同颜色的文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！