Contextures Blog Excel Tips and Tutorials

how to plan a pivot table 4

How to Plan a Pivot Table in Excel

Setting up a pivot table is a bit like news reporting – you can give a quick summary of the Who, What, When, Where and How (Much) of your data. After you’ve been using...

lotus 123 release 4 3

Good Old Days of Spreadsheets

A couple of things happened this week that reminded me of the good old days of spreadsheets. There are some good memories, but I really don’t want to go back to those days. How...

Excel Pivot Table Show Details 1

Pivot Table Show Details Sheets

When you double-click on a pivot table value cell, Excel creates a new sheet, with a list of all the records that make up that total value. The double-click runs Excel’s Pivot Table Show...

unpivot excel data 4

Quick Ways to Unpivot Excel Data

Before you can build a flexible pivot table, you might need to rearrange the data. For example, if the data has a separate column for each month’s sales, that won’t work well in a...

Fix disappearing Excel add-ins 8

Excel Problems, Fixes and Webinars

Did you get hit by the disappearing Excel add-in affliction recently? After a long couple of weeks, that frustrating Excel problem is finally solved. After spending countless hours on that issue (details below), I...

hide sheets based on tab color 1

Hide Sheets Based on Tab Color

Last month, I showed you my code that hides worksheets, based on the text in their names. Someone asked we could hide sheets based on tab color instead, so that’s how today’s example works....

Show Specific Sheets in Excel With Drop Down List 4

Show Specific Sheets in Excel

In a workbook with lots of worksheets, you can have a hard time finding the sheets that you need, to do a specific task. Instead of scrolling through all the sheet tabs, or using...