Contextures

Use these macro to start your data validation troubleshooting. Get a list of all data validation on the active sheet -- the list can be created on

Read more ...

DV0062 - Data Validation Click Combobox - Add New Items -- Click a cell that contains a data validation list, and a combobox appears -- font size can be set, more

Read more ...

Logo of Owen-Illinois.

Today’s post was written by Rodney Masney, vice president of Technology Service Delivery at Owens-Illinois.

Image of Rodney Masney, vice president of Technology Service

Read more ...

Contextures

After adding fields to a pivot table, move them to a different position, or change their headings

Read more ...

Contextures

After adding fields to a pivot table, move them to a different position, or change their headings

Read more ...

Contextures

After you build a pivot table, and add fields, you can rearrange the items in one or more of the fields

Read more ...

Contextures

This macro creates a text file in the active folder, with a list of the active worksheet's conditional formatting, including the font and fill colours selected

Read more ...

Contextures

When you create a pivot table, a default PivotTable Style is automatically applied. You can change the default PivotTable Style in each workbook, if you prefer a

Read more ...

Contextures

Use conditional formatting to add data bars to cells with numbers. This makes it easy to visually compare numbers, as you would in a bar chart.

Read more ...

Mastering personal finances can often start with something as simple as holding a garage sale or opening an online shop. Keeping track of what it takes to manage sales helps you

Read more ...