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.

Here's how. Image: PixelMe/Shutterstock The article, How to use VBA to update fields in a Word document shows you three ways to update fields: printing the article and two VBA procedures.

These days, you can still use macros in Excel, but you need to enable the macro feature to do so. Here's how to enable (and disable) macros.

If you are new to macros, check out my dedicated guide below, where I go over the benefits and step-by-step instructions for creating macros in Excel.

What is Macro? Macro is a handy tool for frequent Excel users that helps to save time and automatically configure some commands. Macro works with VBA (Visual Basic for Application) program codes, but ...

Before using the form, it is advisable to put your data into an Excel table. Tables in Excel offer many advantages, such as automatic formatting and the ability to easily add or remove rows.

It is very simple. I illustrate, in the accompanying video, how to record a macro in Excel using the situation described in the question. However, you can record macros to perform a wide variety of ...

Macros are powerful tools available in programs you likely use every day, but make sure your security settings are up to snuff.