Excelのこととか色々

マクロをどんな Excel ファイルにも実行できるように設定して、3秒かかる操作も1秒で完了。あといろいろ書いてみます・・・

Ribbon

【Excel/VBA 03】Adjust Row Height and Column Width by One Click

You can adjust the row height or the column width by one click if you create the macros and add them to the Ribbon. Write the macro on the Personal Macro Book thus you can use them on any Excel files.

【Excel/VBA 02...Insert Row/Column By One Click】

Adding a row or a columns is just one sentence of code. Set it to the ribbon and use them anytime.

【Excel/VBA 01...Personal Macro Workbook and Developer Tab】

Set your macros on the ribbon and you can use them anytime. That makes your work speeding up and reducing stress!