Page setup for dozens of worksheets in a click in Excel 新手必學, Excel 超實用秘技, 公式, 巨集, 樞紐分析表 Stop doing it manually! Do the same page setup for dozens of Excel worksheets in just one click with this little macro. Save your time...and your hands!
How to get file names from a folder by a macro? in Excel 新手必學, Excel 超實用秘技, 公式, 巨集 A easy Excel macro to help return a list of file names from a folder in just a few seconds for file renaming and sorting purposes.
A macro to move specific files from a folder in Excel 新手必學, Excel 超實用秘技, 公式, 巨集 To save my hands from being handicapped, I used this simple macro to find and move specific files from a folder to another in just few clicks.
17 shortcut keys to manipulate workbooks in Excel 新手必學, 快速鍵, 樞紐分析表 Select and right click, no more! Take 3 minutes to learn these 17 shortcut keys to manipulate Excel workbooks just at your finger tips.
Transpose data in excel in 10 simple steps in Excel 超實用秘技, 樞紐分析表 10 simple steps to make you table in a Excel spreadsheet lookup-friendly: Transpose data from multiple columns to rows in less than five minutes.