# Macro To Group Columns In Excel Worksheet

Previously we wrote a macro to group multiple columns in multiple worksheets in an excel workbook. Below macro is to group columns in the active worksheet.

# Macro To Collapse Grouped Columns In Multiple Worksheets

If you have grouped multiple columns in more than one worksheet, you can use below macro to collapse all the grouped column in all the worksheets in one go.

# Macro To Expand All Grouped Columns In Multiple Worksheets

If you have grouped multiple columns in more than one worksheet, you can use below macro to expand all the grouped column in all the worksheets in one go.

# Macro To Group Columns In Multiple Worksheets

Below is a small but powerful macro to group multiple columns in multiple worksheets in one go provided all the worksheets have same format. If worksheets have different format, you can easily modify this macro to run on a single Continue reading

# Max & Min Functions In Excel – MS Excel Functions Tutorial Part 9

We learnt Mathematical Functions, Text Functions, Cleanup and Case Functions, Logical Functions, Lookup Functions and Date & Time Functions in Excel and how to use these functions. In this post, we will learn about Max and Min Functions in excel. Continue reading

# Date & Time Functions In Excel – MS Excel Functions Tutorial Part 8

We learnt Mathematical Functions, Text Functions, Cleanup and Case Functions, Logical Functions and Lookup Functions in Excel and how to use these functions. In this post, we will learn about Date and Time Functions in excel. Introduction To Excel Formulas Continue reading

# Lookup Functions In Excel – MS Excel Functions Tutorial Part 7

We learnt Mathematical Functions, Text Functions, Cleanup and Case Functions and Logical Functions in Excel and how to use these functions. In this post, we will learn about Lookup functions in excel. Introduction To Excel Formulas & Functions Inserting Formula, Continue reading

# Logical Functions In Excel – MS Excel Functions Tutorial Part 6

We learnt Mathematical Functions, Text Functions, Cleanup and Case Functions in Excel and how to use these functions. In this post, we will learn about Logical functions in excel. Introduction To Excel Formulas & Functions Inserting Formula, Function & Named Continue reading

# Cleanup & Case Functions In Excel – MS Excel Functions Tutorial Part 5

So far we have learnt Mathematical Functions and Text Functions in Excel and how to use these functions. In this post, we will learn about clean up and case functions in excel. Introduction To Excel Formulas & Functions Inserting Formula, Continue reading

# Text Functions In Excel – MS Excel Functions Tutorial Part 4

In previous post we learnt mathematical functions in excel. In this post, we will learn Text Functions in Excel. Introduction To Excel Formulas & Functions Inserting Formula, Function & Named Range In Excel Mathematical Functions In Excel Text Functions In Continue reading