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
最优利率和cashback可以申请特批,好信用好收入offer更好。请点链接扫码加微信咨询,Scotiabank -- Nick Zhang 6478812600。
Ad by
最优利率和cashback可以申请特批,好信用好收入offer更好。请点链接扫码加微信咨询,Scotiabank -- Nick Zhang 6478812600。
@Baltimore
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
想在Android的手机里装上这些正规的字体,比方说,Times New Roman,Courier New。怎么装法? Google Playstore里面的Font App尽是那些乌烟瘴气,花哩唿哨的comic字体,一味迎合年轻人和teenager口味,很讨厌。
发现了ESIM Pay as you go plan: 充值即用,说是不会过期,不收手续费。有兴趣的可以看看,总结一下经验让大家一起分享。
Qualcomm wants to buy Intel
乍一看还以为苹果出折叠手机了。
今天刚注意到,也给各位用obihai设备的网友提个醒:Oct31后obiTalk的service 要永久关闭了,HP估计嫌弃不挣钱给放弃这个了。建议自己做好local 备份吧,以后只能用Local configuration 去改了。通过这个连的google voice或本地电话希望正常工作吧。
枫下论坛主坛
/
枫下家园
/
电脑电信