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.
- Follow this blog:
- RSS
- Email Alert
Microsoft Office
Office challenge: What's the easiest way to select a specific cell when you return to a specific sheet?
Takeaway: In this week’s challenge, help a user preserve the cursor location in a sheet whenever he/she returns to it.
Get IT Tips, news, and reviews delivered directly to your inbox by subscribing to TechRepublic’s free newsletters.
About Susan Harkins
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.
No messages found
Log in to display your contacts' posts.
Once logged in, adding contacts is simple. Just mouse over any member's photo or click any member's name then click the "Follow" button. You can easily manage your contacts within your account contacts page.
