冰色雪豹 发表于 2021-11-12 12:14:00

数据比较多的EXCEL里，数字比较小，看不清，如何实现，鼠标点到即有放大效果 ...

数据比较多的EXCEL里，数字比较小，看不清，如何实现，鼠标点到即有放大效果

金世方缘 发表于 2021-11-16 11:29:17

VBA 事件编程可实现

英雄汇 发表于 2021-11-21 04:25:47

这个需要VBA实现了，如果简单一点按着ctrl滚动鼠标中间就可以实现

白画心 发表于 2021-11-23 09:50:23

我百度了一下，哪位大神教一下我，怎么用

朱思貓 发表于 2021-11-25 09:44:37

<!DOCTYPE html>
2.<html lang="en">
3.<head>
4.<title>Table V01</title>
5.<meta charset="UTF-8">
6.<meta name="viewport" content="width=device-width, initial-scale=1">
7.
8.<style type="text/css">
9.
10.* {
11.margin: 0px;
12.padding: 0px;
13.box-sizing: border-box;
14.}
15.
16.body, html {
17.height: 100%;
18.font-family: sans-serif;
19.padding-top:30px;
20.}
21.
22.* {font-family: Helvetica Neue, Arial, sans-serif; }
23.
24.body { background-image: linear-gradient(#aaa 25%, #000); }
25.
26.h1, table { text-align: center; }
27.
28.table {border-collapse: collapse;width: 70%; margin: 0 auto 5rem;}
29.
30.th, td { padding: 1.5rem; font-size: 1.3rem; }
31.
32.tr {background: hsl(50, 50%, 80%); }
33.
34.tr, td { transition: .4s ease-in; }
35.
36.tr:first-child {background: hsla(12, 100%, 40%, 0.5); }
37.
38.tr:nth-child(even) { background: hsla(50, 50%, 80%, 0.7); }
39.
40.td:empty {background: hsla(50, 25%, 60%, 0.7); }
41.
42.tr:hover:not(#firstrow), tr:hover td:empty {background: #ff0; pointer-events: visible;}
43.tr:hover:not(#firstrow) { transform: scale(1.2); font-weight: 700; box-shadow: 0px 3px 7px rgba(0, 0, 0, 0.5);}
44.
45.
46.</style>
47.</head>
48.<body>
49.
50.<h1>Race Times</h1>
51.
52.<table id="racetimes">
53.<tr id="firstrow"><th>Race</th><th>Location</th><th>Distance (in kilometres)</th><th>Time</th></tr>
54.<tr><td>SAIT Open</td><td>Calgary</td><td>5</td><td></td></tr>
55.<tr><td>CALTAF Classic</td><td>Calgary</td><td>1.5</td><td>5.00</td></tr>
56.<tr><td>Calgary Marathon</td><td>Calgary</td><td>21.1</td><td>2:00.00</td></tr>
57.<tr><td>Zombie Survivor</td><td>Cochrane</td><td>5</td><td>25.00</td></tr>
58.<tr><td>Run for Women</td><td>Calgary</td><td>5</td><td>20.00</td></tr>
59.</table>
60.
61.</body>
62.</html>

一天到晚游泳 发表于 2021-11-26 14:43:19

<!DOCTYPE html>
2.<html lang="en">
3.<head>
4.<title>Table V01</title>
5.<meta charset="UTF-8">
6.<meta name="viewport" content="width=device-width, initial-scale=1">
7.
8.<style type="text/css">
9.
10.* {
11.margin: 0px;
12.padding: 0px;
13.box-sizing: border-box;
14.}
15.
16.body, html {
17.height: 100%;
18.font-family: sans-serif;
19.padding-top:30px;
20.}
21.
22.* {font-family: Helvetica Neue, Arial, sans-serif; }
23.
24.body { background-image: linear-gradient(#aaa 25%, #000); }
25.
26.h1, table { text-align: center; }
27.
28.table {border-collapse: collapse;width: 70%; margin: 0 auto 5rem;}
29.
30.th, td { padding: 1.5rem; font-size: 1.3rem; }
31.
32.tr {background: hsl(50, 50%, 80%); }
33.
34.tr, td { transition: .4s ease-in; }
35.
36.tr:first-child {background: hsla(12, 100%, 40%, 0.5); }
37.
38.tr:nth-child(even) { background: hsla(50, 50%, 80%, 0.7); }
39.
40.td:empty {background: hsla(50, 25%, 60%, 0.7); }
41.
42.tr:hover:not(#firstrow), tr:hover td:empty {background: #ff0; pointer-events: visible;}
43.tr:hover:not(#firstrow) { transform: scale(1.2); font-weight: 700; box-shadow: 0px 3px 7px rgba(0, 0, 0, 0.5);}
44.
45.
46.</style>
47.</head>
48.<body>
49.
50.<h1>Race Times</h1>
51.
52.<table id="racetimes">
53.<tr id="firstrow"><th>Race</th><th>Location</th><th>Distance (in kilometres)</th><th>Time</th></tr>
54.<tr><td>SAIT Open</td><td>Calgary</td><td>5</td><td></td></tr>
55.<tr><td>CALTAF Classic</td><td>Calgary</td><td>1.5</td><td>5.00</td></tr>
56.<tr><td>Calgary Marathon</td><td>Calgary</td><td>21.1</td><td>2:00.00</td></tr>
57.<tr><td>Zombie Survivor</td><td>Cochrane</td><td>5</td><td>25.00</td></tr>
58.<tr><td>Run for Women</td><td>Calgary</td><td>5</td><td>20.00</td></tr>
59.</table>
60.
61.</body>
62.</html>

孙宏伟 发表于 2021-11-27 06:54:52

网上百度了一个编码，没成功

美图水转印热转印 发表于 2021-12-1 19:34:17

<!DOCTYPE html>
2.<html lang="en">
3.<head>
4.<title>Table V01</title>
5.<meta charset="UTF-8">
6.<meta name="viewport" content="width=device-width, initial-scale=1">
7.
8.<style type="text/css">
9.
10.* {
11.margin: 0px;
12.padding: 0px;
13.box-sizing: border-box;
14.}
15.
16.body, html {
17.height: 100%;
18.font-family: sans-serif;
19.padding-top:30px;
20.}
21.
22.* {font-family: Helvetica Neue, Arial, sans-serif; }
23.
24.body { background-image: linear-gradient(#aaa 25%, #000); }
25.
26.h1, table { text-align: center; }
27.
28.table {border-collapse: collapse;width: 70%; margin: 0 auto 5rem;}
29.
30.th, td { padding: 1.5rem; font-size: 1.3rem; }
31.
32.tr {background: hsl(50, 50%, 80%); }
33.
34.tr, td { transition: .4s ease-in; }
35.
36.tr:first-child {background: hsla(12, 100%, 40%, 0.5); }
37.
38.tr:nth-child(even) { background: hsla(50, 50%, 80%, 0.7); }
39.
40.td:empty {background: hsla(50, 25%, 60%, 0.7); }
41.
42.tr:hover:not(#firstrow), tr:hover td:empty {background: #ff0; pointer-events: visible;}
43.tr:hover:not(#firstrow) { transform: scale(1.2); font-weight: 700; box-shadow: 0px 3px 7px rgba(0, 0, 0, 0.5);}
44.
45.
46.</style>
47.</head>
48.<body>
49.
50.<h1>Race Times</h1>
51.
52.<table id="racetimes">
53.<tr id="firstrow"><th>Race</th><th>Location</th><th>Distance (in kilometres)</th><th>Time</th></tr>
54.<tr><td>SAIT Open</td><td>Calgary</td><td>5</td><td></td></tr>
55.<tr><td>CALTAF Classic</td><td>Calgary</td><td>1.5</td><td>5.00</td></tr>
56.<tr><td>Calgary Marathon</td><td>Calgary</td><td>21.1</td><td>2:00.00</td></tr>
57.<tr><td>Zombie Survivor</td><td>Cochrane</td><td>5</td><td>25.00</td></tr>
58.<tr><td>Run for Women</td><td>Calgary</td><td>5</td><td>20.00</td></tr>
59.</table>
60.
61.</body>
62.</html>

哇哇哇呀 发表于 2021-12-5 06:25:28

为什么代码发不上来呀

小朱侃球 发表于 2021-12-5 10:26:25

你没有上传附件，代码针对性很强的，直接引用容易出问题
如下是一个带聚光灯和放大字体效果的事件，里面的字号，颜色什么的可以随便调
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
Cells.Font.Bold = False
Cells.Font.Size = 11
Target.EntireColumn.Interior.Color = RGB(255, 230, 153)
Target.EntireRow.Interior.Color = RGB(255, 230, 153)
Target.Font.Bold = True
Target.Font.Size = 20
End Sub
页: [1] 2 3 4
查看完整版本: 数据比较多的EXCEL里，数字比较小，看不清，如何实现，鼠标点到即有放大效果 ...