Instead, you can use the VBA editor to create a CalculateTax function that calculates tax based on cell value. It acts just ...

You can also run VBA procedures from the Quick Access Toolbar and a custom group on the ribbon. To learn more about these methods, read How to add Office macros to the QAT toolbar for quick access .

Inserting a lot of columns or rows in Microsoft Excel is awkward and prone to mistakes. When you need to enter dozens or more columns, use this VBA procedure for ease and accuracy.