It's Time to Filter

This past Wednesday I announced the release of my new ExcelTips: Filters and filtering e-book. If you routinely work with large amounts of data and you want a better handle on how to work with that data, you'll love this e-book. It explains, in detail, how to use regular filtering, advanced filtering, filtering in tables, and the FILTER function. Not only that, but you'll find lots of great ideas and examples of how to use filtering with YOUR data.

To celebrate the release of ExcelTips: Filters and Filtering, you can get your own copy for 30% off the regular price. Here's where you can find more information, including a full table of contents:

     https://store.tips.net/T010136

I hope you have a great weekend and enjoy the tips in the newsletter.

—Allen
     

ExcelTips (ribbon) for 19 October 2024
Worksheet functions
Understanding the POWER Function

The POWER function is used to raise one value to another value. However, Excel also provides an exponentiation operator for this purpose. Which one should you use?

Read this tip »

(Thanks to Steve Aprahamian, Ken Siskind, Alan Cannon, Bob Beechey, Mike Haley, Ronald Doeleman, Fred van der Meulen, and Yvan Loranger for contributing to this tip.)

 
Tools
Counting with Subtotals

There are a variety of ways you can count information in different groupings. One convenient way is to use the subtotaling capabilities provided in Excel.

Read this tip »

 
ExcelTips at Your Fingertips

Support ExcelTips and obtain a valuable resource—your own copies of the ExcelTips archives. Each archive contains all the tips for a calendar year; often over 400 pages of detailed info on how to better use Excel. Learn more about Excel today!

 
Sorting
Too Many Formats when Sorting

Sorting is one of the basic operations done in a worksheet. If your sorting won't work and you instead get an error message, it could be because of the number of custom formats in your workbook. This tip provides information to help get rid of this problem.

Read this tip »

 
Worksheets
Unhiding Multiple Worksheets

You can hide a bunch of worksheets at the same time, but Excel makes it much more difficult (depending on your version of Excel) to unhide a bunch at once. This tip provides ways you can unhide multiple worksheets regardless of the version of Excel you are using.

Read this tip »

     

Help Wanted

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

 
Leaving Leading Zeroes in Place

We regularly send out a mailer to our subscribers, so I keep track of their addresses in an Excel worksheet. Many of those subscribers have ZIP Codes that begin with a zero. When I enter them into a cell, Excel strips the leading zeroes. How do I stop them from being stripped?
—Gary Wilson (provide an answer for this Help Wanted question)

 
ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939