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.
People who read this...
- Office solution: How to continue numbering from one table column to another
- What to do when Excel's Custom Views option is disabled
- Quickly highlight matching values in Excel with keyboard shortcut
- A quick tip for entering names into an expression
- How to delete duplicate values and duplicate records in Excel 2007 and 2010
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.
