I'm not sure what the number of undo's is - I think it's 256. But there are
some commands that Excel won't undo. For example, when you use "Data,
Filter", it won't undo the command using the Undo function in Edit. Instead,
if you look closely, you will see "Can't Undo" greyed-out.

I don't have a list of the commands it won't undo, but perhaps someone else
does. Anyway that's why you're only able to undo a few commands sometimes.

HTH

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