Office challenge: What's the easiest way to select a specific cell when you return to a specific sheet?

In this week's challenge, help a user preserve the cursor location in a sheet whenever he/she returns to it.

One of your users wants to return to the same cell when returning to a sheet, regardless of the cursor's location when they left that sheet. For example, when the user moves to Sheet1, she wants the cursor to always select cell C3. How would you satisfy this request? There's more than one way to accomplish this - let's opt for the easiest method, one you could show the user to implement herself, if possible.


Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks