How to quickly jump back to previous cell in Excel?
Author: SunLast Modified: 2020-08-19
In some cases, when you go to next cell to enter a value, you may want to jump back to previous cell to confirm the value again, except to scroll back to find the previous cell, are there any tricks to quickly jump back to the previous cell in Excel?
Actually, there is a shortcut working at quickly jump back to previous cell.
1. Before using the shortcut to jump back to previous cell, you need to select the current cell first, go to the Name box, and press Enter key to activate the shortcut. See screenshot:
2. Then when you go to another cell, you can press F5 + Enter keys simultaneously to go back the previous cell. See screenshot:
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
This comment was minimized by the moderator on the site
Can the [press F5 + Enter keys simultaneously to go back the previous cell] be automated as a macro? If so, how, as I've tried to record it and that does not work. Also, I have tried creating a macro with [SendKeys "%{F5}" + "{ENTER}"] (as per other posts) but this only operates the last command, ie. "enter".