If you've added comments to an Excel worksheet, you have a couple of built-in options for printing the comments.

Show the comments on the worksheet, and print them as displayed.
Print the list of comments at the end of the worksheet, on a separate printed page.

Printing the comments on the worksheet is okay if [...]

Last week, you saw a quick tip for filtering by selection in Excel 2007. That's helpful when you've found an item in a list, and want to filter for that item.
There's another new feature in the AutoFilter dropdown, in Excel 2010. When you click the drop down arrow in the AutoFilter heading cell, you'll see [...]

Last month you saw a quick way to filter for the selected item in a pivot table, and today you'll see a similar technique for a worksheet list in Excel 2007. (For the Excel 2003 quick filter instructions see AutoFilter By Selection in Excel)
In the screen shot below, there's a list on the worksheet, with [...]

An Excel data validation drop down list only shows 8 items at a time, and with a long list of items, it might take you a while to scroll through the list.

When cell B3 in this example is blank, a long list of names shows in cell C3. Instead of showing all the names, [...]

When you use an Excel AutoFilter to filter a list, usually the count of visible records appears in the Status Bar, at the bottom left of the Excel window. (Note: If the Status Bar shows Filter Mode, instead of the record count, you can use one of the workarounds shown here – Status Bar [...]

Congratulations to Alex Kerin, whose name I selected in the random draw for the Excelerator Quiz giveaway. Here’s his name at the top of the list, after I used the RAND function, and sorted the Rand column in ascending order.

Alex’s prize is a 23” monitor, plus a keyboard and mouse, courtesy of the PowerPivot team. [...]

It’s Price Book publishing week for one of my clients, and we’ve been making lists, and checking them twice. Or 3 or 4 times, or more!
When comparing the new prices to the previous prices, an Excel AutoFilter comes in handy. You can select the same product or model in each workbook, and easily compare item [...]

In Excel 2003 and earlier versions, you can use an Advanced Filter to remove duplicates. In Excel 2007, there’s a new command on the Ribbon to make it easier to remove duplicates from a list.
Be careful with the Excel 2007 Remove Duplicates feature though – it really removes the duplicates. If you use an Advanced [...]

I love advanced filters, but this week they caused me some serious grief.
Advanced filters in Excel are quick and powerful, and I use lots of them. They’re a great way to pull a list of unique items from a table, or send specific data from one sheet to another.
People sometimes have trouble with an advanced [...]

For a simple database, Excel can do a pretty good job of organizing and reporting your data. This example shows a movie collection database, but you could set up something similar to keep track of books, sales orders, or almost anything else.
In this database you can store movie data, then create a list of movies [...]