This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.
×
Loading...
Ad by
技多不压身,工到自然成:安省技工证书特训班,点击咨询报名!
Ad by
技多不压身,工到自然成:安省技工证书特训班,点击咨询报名!
@Sacramento
Close
Home
Share
你看下这篇文章里的做法:
xjcjq
(rufeng)
3 ways to dynamically highlight the row and/or column of a selected cell in Excel.
Full Story:
https://www.ablebits.com/office-addins-blog/highlight-active-row-column-excel/#:~:text=Highlight%20active%20row%20and%20column%20without%20VBA&text=On%20the%20Home%20tab%2C%20in,determine%20which%20cells%20to%20format.&text=All%20the%20formulas%20make%20use,number%20of%20the%20selected%20cell.
(#15260212@0)
Last Updated: 2023-3-10
This post has been archived. It cannot be replied.
Share
Report
Replies, comments and Discussions:
枫下家园
/
电脑电信
/
请教大拿们,Excel 里,有啥现成的功能,可以设置使得光标所在的行和列自动高亮,以便能容易的和其他行列区分?谢谢了。
-
starrystarrynight
(StarryNight);
2023-3-10
{157}
(#15260055@0)
ChatGPT 理解力上感觉比 Google 强,Google 上找不到能明白我问题的回答。ChatGPT倒是很快就明白了,不过,马上给出 VBA,但是不想编程啊,不然每个文件都得 VBA 一下。
google 没找到可能是你关键字写的不合适。 chatgpt理解语言的能力肯定比google强多了
-
haihai
(享受阳光🌞);
2023-3-10
(#15260078@0)
谢谢,但是想找不用 VBA 的方法。
-
starrystarrynight
(StarryNight);
2023-3-10
(#15260164@0)
最上面的链接里面有不是vba的方法,但需要花钱买个kutool的工具
-
haihai
(享受阳光🌞);
2023-3-10
(#15260236@0)
这个是你要的吧?
-
xjcjq
(rufeng);
2023-3-10
{485}
(#15260081@0)
+2
Full Story:
https://www.extendoffice.com/documents/excel/1494-excel-highlight-active-row-and-column.html#:~:text=1.,Code%20from%20the%20context%20menu.&text=3.,this%20cell%20has%20been%20highlighted.
谢谢!ChatGPT 给了VBA,有没有不是 VBA 的方法?
-
starrystarrynight
(StarryNight);
2023-3-10
(#15260157@0)
你看下这篇文章里的做法:
-
xjcjq
(rufeng);
2023-3-10
{924}
(#15260212@0)
3 ways to dynamically highlight the row and/or column of a selected cell in Excel.
Full Story:
https://www.ablebits.com/office-addins-blog/highlight-active-row-column-excel/#:~:text=Highlight%20active%20row%20and%20column%20without%20VBA&text=On%20the%20Home%20tab%2C%20in,determine%20which%20cells%20to%20format.&text=All%20the%20formulas%20make%20use,number%20of%20the%20selected%20cell.
谢谢楼上各位!
-
starrystarrynight
(StarryNight);
2023-3-11
(#15260900@0)
More Topics
平时用的还是2012年买的A1466这款电脑 虽然只有4G内存,但上网看视频cast video都非常够用了,12年来没毛病。就是每隔三四年换个电池。
remarkable pro 跟普通的触摸屏tablet 比怎么样?
刚刚发现,virgin plus的套餐涨价了,没有通知就悄悄涨了,有类似情况吗? 打了customer service,也说不出为什么不通知就涨价….
ZT: 俩款Android 手机相机APP藏木马病毒
你们在机场不联机场的Wifi 吗?只要不点击钓鱼链接就可以的吧?ZT: 机场免费Wi-Fi隐患有多大?原来黑客这么容易就能盗取你的所有信息
枫下论坛主坛
/
枫下家园
/
电脑电信