ExcelTips (menu) for 20 July 2024

Creating a Log/Log Chart

If you need to create a chart that uses logarithmic values on both axes, it can be confusing how to get what you want. This tip explains which of the chart types in Excel is best suited for the type of chart you need.

Read this tip »

Printing Workbooks in a Folder

This tip presents two techniques you can use to print multiple workbooks all at the same time. Both techniques involve creating selection sets and then acting on those sets.

Read this tip »

Baffled by Array Formulas?

Have you heard about the special array formulas you can create in Excel? They make it a snap to perform calculations using large amounts of data and even generate results you can't get with regular formulas. Array formulas may be Excel's best-kept secret. Remove the confusion; discover how to use array formulas today.

Sorting with Graphics

If the graphics that you insert in your worksheet meet a couple of simple requirements, it is possible to have those graphics be sorted right along with the data in the worksheet. This tip explains those requirements and explains how you can do the sorting.

Read this tip »

Maintaining Formatting when Refreshing PivotTables

When you refresh the data in a PivotTable, Excel can play havoc with whatever formatting you applied. Here's how to protect your formatting efforts when updating the information.

Read this tip »