Spreadsheet: 140000d1328582559-how-to-make-dashboard-scroll-table-dashboard-table-scroll
Sheet: Data

 |  | Data |  |  |  |  |  |  |  |  |  | THIS IS LOCK CELL
 |  | No. | Products | KPI 1 | KPI 2 | KPI 3 | [NAME] | KPI 5
 |  | 1 | Product Name 1 | 284 | 267 | 0.28 | -11 | 348.83
 |  | 2 | Product Name 2 | 170 | 218 | 0.86 | -11 | 734.27
 |  | 3 | Product Name 3 | 760 | 9 | 0.95 | -30 | 503.34
 |  | 4 | Product Name 4 | 366 | 388 | 0.35 | 47 | 367.9
 |  | 5 | Product Name 5 | 1345 | 130 | 0.58 | 74 | 477.47
 |  | 6 | Product Name 6 | 790 | 181 | 0.97 | -10 | 678.05
 |  | 7 | Product Name 7 | 1269 | 319 | 0.78 | 24 | 373.29
 |  | 8 | Product Name 8 | 107 | 16 | 0.59 | 61 | 532.21
 |  | 9 | Product Name 9 | 501 | 486 | 0.56 | 67 | 265
 |  | 10 | Product Name 10 | 953 | 259 | 0.05 | 74 | 855.81
 |  | 11 | Product Name 11 | 783 | 299 | 0.18 | -71 | 649.79
 |  | 12 | Product Name 12 | 669 | 124 | 0.22 | -61 | 983.54
 |  | 13 | Product Name 13 | 447 | 489 | 0.13 | -52 | 141.18
 |  | 14 | Product Name 14 | 682 | 417 | 0.41 | 94 | 404.07
 |  | 15 | Product Name 15 | 807 | 77 | 0.91 | 59 | 180.39
 |  | 16 | Product Name 16 | 1180 | 267 | 0.43 | 100 | 887.77
 |  | 17 | Product Name 17 | 725 | 172 | 0.57 | 60 | 10.18
 |  | 18 | Product Name 18 | 522 | 227 | 0.22 | -84 | 775.1
 |  | 19 | Product Name 19 | 1350 | 398 | 0.68 | -74 | 411.09
 |  | 20 | Product Name 20 | 1163 | 168 | 0.08 | -93 | 807.26
 |  | 21 | Product Name 21 | 830 | 264 | 0.1 | -68 | 85.84
 |  | 22 | Product Name 22 | 1195 | 199 | 0.92 | -60 | 209.94
 |  | 23 | Product Name 23 | 482 | 116 | 0.71 | -27 | 337.36
 |  | 24 | Product Name 24 | 1024 | 176 | 0.35 | 40 | 242.52
 |  | 25 | Product Name 25 | 1339 | 379 | 0.98 | -71 | 336.15
 |  | 26 | Product Name 26 | 958 | 206 | 0.1 | 74 | 717.43
 |  | 27 | Product Name 27 | 1153 | 250 | 0.57 | 44 | 7.33
 |  | 28 | Product Name 28 | 136 | 57 | 0.07 | 14 | 985.32
 |  | 29 | Product Name 29 | 923 | 116 | 0.61 | -69 | 386.26
 |  | 30 | Product Name 30 | 252 | 439 | 0.07 | -46 | 0.33
 |  | 31 | Product Name 31 | 1270 | 64 | 0.53 | 87 | 259.52
 |  | 32 | Product Name 32 | 880 | 12 | 0.9 | 41 | 915.26
 |  | 33 | Product Name 33 | 1330 | 385 | 0.25 | 78 | 117.46
 |  | 34 | Product Name 34 | 255 | 128 | 0.87 | 50 | 191.33
 |  | 35 | Product Name 35 | 253 | 266 | 0.19 | 22 | 982.91
 |  | 36 | Product Name 36 | 1407 | 302 | 0.02 | -50 | 178.96
 |  | 37 | Product Name 37 | 359 | 269 | 0.7 | -21 | 93.66
 |  | 38 | Product Name 38 | 1084 | 267 | 0.13 | 66 | 67.7
 |  | 39 | Product Name 39 | 1403 | 347 | 0.61 | -35 | 206.15
 |  | 40 | Product Name 40 | 297 | 65 | 0.44 | 53 | 53.51
 |  | 41 | Product Name 41 | 767 | 380 | 0.86 | -37 | 517.96
 |  | 42 | Product Name 42 | 1338 | 261 | 0.86 | 66 | 218.2
 |  | 43 | Product Name 43 | 180 | 478 | 0.67 | -48 | 514.29
 |  | 44 | Product Name 44 | 419 | 398 | 0.51 | 64 | 153.76
 |  | 45 | Product Name 45 | 905 | 84 | 0.22 | -88 | 101.97
 |  | 46 | Product Name 46 | 673 | 352 | 0.11 | 72 | 568.95
 |  | 47 | Product Name 47 | 1204 | 227 | 0.16 | 94 | 973.82
 |  | 48 | Product Name 48 | 678 | 129 | 0.86 | -24 | 793.37
 |  | 49 | Product Name 49 | 389 | 257 | 0.24 | 97 | 948.59
 |  | 50 | Product Name 50 | 394 | 405 | 0.1 | -27 | 516.88
 |  | 51 | Product Name 51 | 120 | 64 | 0.46 | -46 | 880.23
 |  | 52 | Product Name 52 | 305 | 277 | 0.22 | 59 | 136.75
 |  | 53 | Product Name 53 | 1108 | 5 | 0.37 | 83 | 992.41
 |  | 54 | Product Name 54 | 295 | 338 | 0.91 | 86 | 960.61
 |  | 55 | Product Name 55 | 143 | 90 | 0.42 | -63 | 34.5
 |  | 56 | Product Name 56 | 891 | 339 | 0.92 | -90 | 514.92
 |  | 57 | Product Name 57 | 445 | 396 | 0.56 | 34 | 369.97
 |  | 58 | Product Name 58 | 284 | 286 | 0.62 | -99 | 574.32
 |  | 59 | Product Name 59 | 154 | 121 | 0.83 | -48 | 79.95
 |  | 60 | Product Name 60 | 175 | 293 | 0.67 | 90 | 147.34
 |  | 61 | Product Name 61 | 671 | 488 | 0.64 | -67 | 622.22
 |  | 62 | Product Name 62 | 266 | 18 | 0.54 | 96 | 973.22
 |  | 63 | Product Name 63 | 611 | 429 | 0.35 | 28 | 166.92
 |  | 64 | Product Name 64 | 259 | 42 | 0.28 | -60 | 728.32
 |  | 65 | Product Name 65 | 1368 | 188 | 0.28 | -18 | 876.31
 |  | 66 | Product Name 66 | 592 | 253 | 0.74 | 77 | 621.81
 |  | 67 | Product Name 67 | 870 | 73 | 0.08 | 22 | 541.55
 |  | 68 | Product Name 68 | 1236 | 154 | 0.42 | -11 | 729.28
 |  | 69 | Product Name 69 | 187 | 392 | 0.98 | 85 | 609.45
 |  | 70 | Product Name 70 | 357 | 345 | 0.72 | 85 | 449
 |  | 71 | Product Name 71 | 431 | 234 | 0.59 | -83 | 3.23
 |  | 72 | Product Name 72 | 793 | 301 | 0.81 | -78 | 441.91
 |  | 73 | Product Name 73 | 350 | 53 | 0.17 | 71 | 646.45
 |  | 74 | Product Name 74 | 781 | 319 | 0.82 | -74 | 585.01
 |  | 75 | Product Name 75 | 488 | 476 | 0.02 | -25 | 958.79
 |  | 76 | Product Name 76 | 496 | 242 | 0.83 | 95 | 577.15
 |  | 77 | Product Name 77 | 576 | 372 | 0.37 | 64 | 239.9
 |  | 78 | Product Name 78 | 1053 | 16 | 0.02 | 38 | 571.91
 |  | 79 | Product Name 79 | 428 | 124 | 0.47 | 58 | 639.48
 |  | 80 | Product Name 80 | 447 | 299 | 0.72 | 6 | 759.99
 |  | 81 | Product Name 81 | 1059 | 9 | 0.68 | 81 | 100.84
 |  | 82 | Product Name 82 | 389 | 19 | 0.37 | 2 | 620.14
 |  | 83 | Product Name 83 | 913 | 115 | 0.12 | 51 | 558.06
 |  | 84 | Product Name 84 | 1136 | 347 | 0.6 | -4 | 999.49
 |  | 85 | Product Name 85 | 1135 | 318 | 0.81 | -59 | 715.53
 |  | 86 | Product Name 86 | 232 | 430 | 0.71 | 67 | 275.58
 |  | 87 | Product Name 87 | 1319 | 100 | 0.79 | -46 | 365.38
 |  | 88 | Product Name 88 | 465 | 471 | 0.85 | -56 | 970.51
 |  | 89 | Product Name 89 | 1100 | 380 | 0.75 | -82 | 228.92
 |  | 90 | Product Name 90 | 386 | 379 | 0.21 | 16 | 22.38
 |  | 91 | Product Name 91 | 1337 | 473 | 0.24 | -86 | 711.8
 |  | 92 | Product Name 92 | 130 | 244 | 0.08 | 44 | 384.97
 |  | 93 | Product Name 93 | 680 | 49 | 0.03 | -81 | 614.98
 |  | 94 | Product Name 94 | 1355 | 423 | 0.63 | 23 | 482.87
 |  | 95 | Product Name 95 | 889 | 15 | 0.11 | 85 | 80.79
 |  | 96 | Product Name 96 | 1102 | 69 | 0.16 | 16 | 453.03
 |  | 97 | Product Name 97 | 638 | 393 | 0.65 | -24 | 944.86
 |  | 98 | Product Name 98 | 885 | 343 | 0.35 | 58 | 676.41
 |  | 99 | Product Name 99 | 1188 | 289 | 0.39 | -53 | 996.63
 |  | 100 | Product Name 100 | 1338 | 183 | 0.28 | -74 | 343.29