Excel: Cannot Undo the Goto Command

ID: Q71718


The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
  • Microsoft Excel for OS/2, versions 2.2, 2.21, and 3.0


SUMMARY

In Microsoft Excel, you cannot undo the Goto command.


MORE INFORMATION

Microsoft Excel 5.0

If you use the Goto command on the Edit menu and then choose the Undo command from the Edit menu, the command that was entered BEFORE the Goto command is the one that is undone. The active cell will be returned to the position it was in before you chose the Goto command.

If you choose the Goto command several times in a row, and then use the Undo command, all of the Goto commands are ignored, and the Undo command undoes the last command you used before you used the Goto command.

Microsoft Excel 2.x, 3.0, 4.0, 4.0a

If you use the Formula Goto command and then execute the Edit Undo command, the command that was entered BEFORE the Formula Goto command is the one that is undone. The active cell will be returned to the position it was in at the time the command before the Formula Goto command was executed.

If a series of several Formula Goto commands is executed, followed by an Edit Undo, all of the Formula Goto commands are ignored, and the Edit Undo undoes the last command run before the Formula Goto commands were run.


REFERENCES

"User's Guide 1" version 4.0, pages 107, 280
"Function Reference." version 3.0, pages 93, 241
"Reference Guide." version 2.10, pages 241-242, 249
"Microsoft Excel for OS/2 Reference." version 2.21, pages 238-239, 246.

Additional query words: 2.00 2.00 2.01 2.1 2.10 2.20 2.20 2.21 4.0

Keywords :
Version :
Platform :
Issue type :


Last Reviewed: March 21, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.