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。
@Florida
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
Ontario signs $100-million deal with Elon Musk’s SpaceX
Ontario signs $100M deal with Elon Musk's Starlink system
请问大家,Win11 笔记本电脑装了Adobe Acrobat reader 软件,但是点击PDF文件总是打不开,但是也有没有任何错误提示。就是什么问题?
中国是封锁Gmail了吗?我让我弟弟把身份证复印俩面,发个邮件传给我。10分钟了还没有收到。有同样经历的吗?是不是只有微信上可以传了
请问大家:我的win11台式机连接扫描仪,蓝牙鼠标以及无线网卡。每隔几天就出现鼠标和网络卡住几秒钟,然后扫描仪马达重新启动,USB C的外接硬盘打开到根目录。然后过几秒钟一切正常了。这个现象持续1-2年了,我把无线上网改成有线,问题还没有解决。谢谢
枫下论坛主坛
/
枫下家园
/
电脑电信