Power Spreadsheets

Excel VBA Column Width: Step-by-Step Guide and 8 Code Examples to Set or AutoFit the Column Width with Macros

In this VBA Tutorial, you learn how to use Excel VBA to set or autofit the width of columns in a variety of circumstances. This VBA Tutorial is accompanied by Excel workbooks containing the data and macros I use in the examples below. You can get immediate free access to these example workbooks by subscribing to the Power Spreadsheets Newsletter. Use the following Table of … [Read more...]

Excel VBA Delete Row: Step-by-Step Guide and 12 Code Examples to Delete Rows with Macros

In this VBA Tutorial, you learn how to use Excel VBA to delete rows based on a variety of criteria. This VBA Tutorial is accompanied by Excel workbooks containing the data and macros I use in the examples below. You can get immediate free access to these example workbooks by subscribing to the Power Spreadsheets Newsletter. Use the following Table of Contents to … [Read more...]

Excel VBA Insert Row: Step-by-Step Guide and 9 Code Examples to Insert Rows with Macros

In certain cases, you may need to automate the process of inserting a row (or several rows) in a worksheet. This is useful, for example, when you're (i) manipulating or adding data entries, or (ii) formatting a worksheet that uses blank rows for organization purposes. The information and examples in this VBA Tutorial should allow you to insert rows in a variety of … [Read more...]

Create Excel UserForms For Data Entry In 6 Easy Steps: Tutorial And Practical Example

When working in Excel, you have a few ways to get information from a user and allow them to enter data. These include the following: Message boxes. Input boxes. The GetOpenFilename method. The GetSaveAsFilename method. The FileDialog method. Excel worksheets. UserForms. Out of the features I describe above, UserForms are one of the most powerful and efficient … [Read more...]

Excel Pivot Table Group: Step-By-Step Tutorial To Easily Group And Ungroup Data

Pivot Tables allow you to easily summarize, analyze and present large amounts of data. However, to appropriately do this, you must be able to organize the data into adequately-sized and organized subsets. The grouping and ungrouping features of Pivot Tables allow you to easily do this. You see... Knowing how to quickly group data within a PivotTable report can help you … [Read more...]