ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I return to prior cell? (https://www.excelbanter.com/excel-discussion-misc-queries/250752-how-do-i-return-prior-cell.html)

NYC18

How do I return to prior cell?
 
After I have traced a formula using Ctrl+[, what is the keyboard shortcut to
return to the same cell where I traced the formula?

Thank you!

Ms-Exl-Learner

How do I return to prior cell?
 
Press Ctrl+]

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"NYC18" wrote:

After I have traced a formula using Ctrl+[, what is the keyboard shortcut to
return to the same cell where I traced the formula?

Thank you!


NYC18

How do I return to prior cell?
 
Thank you, but I can only get Ctrl+] to work if all the referenced cells are
within one worksheet. If I am writing formulas using cells in 1 or more
worksheets and I try Ctrl+], I receive the error "No cells were found".

I used to know a shortcut to do this. I thought it was Tab+Tab+F2+Enter,
but that is not working.

I really appreciate help. This keyboard shortcut used to save me so much
time and I need it again.

"Ms-Exl-Learner" wrote:

Press Ctrl+]

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"NYC18" wrote:

After I have traced a formula using Ctrl+[, what is the keyboard shortcut to
return to the same cell where I traced the formula?

Thank you!



All times are GMT +1. The time now is 09:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com