Spring Cleaning?

Welcome to spring (officially). This past Tuesday was the first day of the season, and I (for one) am glad to see it arrive.

I don't think I mentioned it in ExcelTips in quite a while, but you may be interested in knowing that we publish a newsletter dedicated to tips about cleaning. You can see a copy of the most recent issue online:

https://cleaning.tips.net/ci.html

If the topic piques your interest (perhaps in keeping with the season you are going to engage in a bit of spring cleaning in the near future), you may want to sign up so you can receive your own copy each week. It's free; all you need to do is visit the Cleaning Tips site and use the "subscribe" form at the right side of any page:

https://cleaning.tips.net/

I hope you have a great week and enjoy whatever weather spring brings your way.

—Allen
     

ExcelTips (ribbon) for 25 March 2023

Worksheets
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.)

 
Editing
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.

 
Macros extend Excel
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 »

 
Powerful spreadsheets
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
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 »

 
Macros extend Excel
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 »

     

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.

 
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)

 
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  •  307-200-0450