下載示範文檔, (注意要用Excel 365版本) https://1drv.ms/x/s!AmTiTp3HvInWhJBN6yXB-Q8l_amUTA?e=rR1SCy

#exceltricks

Contents
00:00 Introduction
01:08 1)Check Box
04:10 2) Auto Border
07:01 3) Magic Vlookup
10:41 4) Fast Range Selection
13:27 5) Edit Multiple Worksheets
15:48 6) Connect Web Data
19:30 7) Copy Multiple Rows
21:34 8) Hide/Unhide Ribbon