I have an Excel document that has more sheets and those sheets link to each other using textual hyperlinks (Insert Hyperlink > Place in This Document).
When I click such hyperlink, it takes me to another sheet (or, more specifically, to a certain cell in that sheet). Is there a way to quickly navigate back? I tried to add the "Back" command to the Quick Access Toolbar but it is grayed out after navigation.
51 Answer
- Go to
Quick Access Toolbareditor (selectMore Commandson the dropdown to the right of it). - In the subsequent dialog select the
All Commandsoption in the dropdown control. - Then look for the
BackandForwardoptions. Double click them to add them to theQuick Access Toolbar.
Note that the Undo button, which is on the Quick Access Toolbar bar by default, looks very similar to the Back button.