Notification of When a Copy is Complete

When you are copying huge amounts of information, Excel may seem to bog down and it is difficult to know when it is safe to proceed. In this tip you'll discover different ways you can get the information you need in order to know when copies are complete.

Read this tip »

(Thanks to Michael Avidan (MVP), Thomas Reeves, Ryszard Raciborski, James Woolley, and Andrija Vrcan for contributing to this tip.)

Freezing Both Rows and Columns

When you are working in a worksheet, you may want to freeze the rows at the top or left of the worksheet. Excel provides a tool that allows you to do this, but its use can be a bit confusing at times. This tip clears up any confusion that may exist.

Read this tip »

PivotTables Make You Feel Faint?

Do you get weak in the knees when asked to deal with huge amounts of data? Forget feeling faint ever again when you are asked to deal with PivotTables. Learn much more than the basics with PivotTables for the Faint of Heart, now available in three great versions.

Deleting Duplicate Text Values

Got a list of data from which you want to delete duplicates? There are a couple of techniques you can use to get rid of the unwanted data, as described in this tip.

Read this tip »

Enforcing Moving Cells Up

When you design your worksheets, you probably want users to interact with those worksheets in specific ways. What happens, though, if users don't do so? This tip looks at ways you can enforce how users delete data in a worksheet.

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.

Assuming Dates are in the Current Century

When I type 6/1/29 into a cell, Excel, as expected, assumes I mean June 1, 2029. However, when I type in 6/1/30, Excel assumes I mean June 1, 1930. Is there a way to get Excel to assume I want 6/1/30 to mean 6/1/2030 rather than 6/1/1930?
—Fred Callison (provide an answer for this Help Wanted question)