失足妇女 发表于 2021-12-24 05:43:16

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

慢一拍 发表于 2021-12-24 09:25:39

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

是男人都要补一补 发表于 2021-12-24 18:20:09

<!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-25 04:04:42

<!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-29 01:29:23

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

塞纳河左岸潮流向西 发表于 2022-1-3 00:55:14

<!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>

杭州燕平广告 发表于 2022-1-5 03:46:28

为什么代码发不上来呀

绿茶的味道 发表于 2022-1-9 20:07:37

你没有上传附件，代码针对性很强的，直接引用容易出问题
如下是一个带聚光灯和放大字体效果的事件，里面的字号，颜色什么的可以随便调
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

法利 发表于 2022-1-16 05:20:05

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

莫梦 发表于 2022-1-21 01:56:52

<!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>
页: 1 2 [3] 4
查看完整版本: 数据比较多的EXCEL里，数字比较小，看不清，如何实现，鼠标点到即有放大效果 ...