View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
wildetudor wildetudor is offline
external usenet poster
 
Posts: 20
Default separate Undo for each sheet in a workbook

How about at least an independent Undo between workbooks? I noticed after
posting my question that even if several different workbooks are open, the
Undo is still common for all of them, even though they're different files!
This is ridiculous, in Word if you ave several documents open, each has its
own Undo list, independent from other documents'.

"Dave Peterson" wrote:

There's nothing (like a setting) built into excel that would allow this.

wildetudor wrote:

Many times I find myself wanting to Undo commands done within a certain
worksheet, without undoing other commands that might have been performed in
other sheets in the meantime. However, if I have a couple of commands done in
one sheet, then some other commands in another sheet, the Undo command will
undo them all as if they were in the same list, without keeping track of the
sheet where those commands were performed.

Does anyone know a way to have separate Undo lists - one for each sheet of a
workbook? Thanks!


--

Dave Peterson