Excel: Cannot Undo the Goto Command

Last reviewed: November 3, 1994
Article 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.


KBCategory: kbusage
KBSubcategory:

Additional reference words: 2.00 2.00 2.01 2.1 2.10 2.20
2.20 2.21 3.00 4.0 4.00 5.00


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 3, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.