Undeleting a Worksheet

Have you ever deleted a worksheet by mistake? Once you get over the sick feeling in your stomach, you will start casting about for ways to undelete the worksheet. Excel (and Windows) provide different ways you can get back the information you need.

Read this tip »

(Thanks to Steve Aprahamian, Ryszard Raciborski, Ray Fernandez, Brian Dorey, James Woolley, Nigel Watts, Marty Wilson, Richard Borgelt, and Tomek Dluzniewski for contributing to this tip.)

Not Enough Resources to Delete Rows and Columns

Few things are as frustrating as trying to delete rows or columns and having Excel tell you that you can't perform the operation. If you get an "not enough resources" error when you try to perform this basic editing task, then the ideas in this tip may prove helpful to you.

Read this tip »

Are You Foundering at Filtering?

We have all experienced the frustration inherent with using Excel filters. Stop foundering when filtering your data by getting your copy of ExcelTips: Filters and Filtering today. More info available online.

Macro for Month Name

Need to know how to generate a full month name based on a date? It's easy to do, as discussed in this tip.

Read this tip »

Selecting Multiple Cells by Mistake

Click on a cell and you expect the single cell to be selected. If you instead get a group of cells, it can be frustrating to figure out why.

Read this tip »

Sorting ZIP Codes

Sorting ZIP Codes can be painless, provided all the codes are formatted the same. Here's how to do the sorting if you have different types of ZIP Codes all in the same list.

Read this tip »

Converting Strings to Numbers

When working with data in a macro, there are two broad categories you can manipulate: numbers and text. Sometimes you need to convert information from one category (data type) to another. Here is how you convert text to numbers.

Read this tip »

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.

Animated Recalculation in Excel

When I enter numbers into Excel, they appear to roll into place and updated totals also roll into place as opposed to just appearing. It's like the numbers are on a roller which spins slightly to arrive at the number I entered or the updated total. I don't know what causes this, but I need to stop it.
—Jesse Fink (provide an answer for this Help Wanted question)