Which version of Excel?

Normally Excel after 97 version will keep track of 16 levels of undo.

Some actions can't be undone, such as clicking any command on the File menu. If
you can't undo an action, the Undo command changes to Can't Undo.
Macros can clear all items from the undo list.

To increase the number of undo's you can alter the Registry, but I don't think
that is your problem.

http://support.microsoft.com/default...;EN-US;q211922


Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 13:22:02 -0800, Carolyn
wrote:

Is there a way to set the number of undo's in Excel. Sometimes I can only
undo one or two changes and need to do more.