Pages

Tuesday, October 4, 2011

Reverse direction when searching in a worksheet (Excel 97/2000/2001/2002)

When you're using the Find or Replace feature in Excel, it's easy to accidentally click the Find Next button one too many times. Fortunately, you don't have to cycle through all of the matches in the worksheet to get back to ones you missed the first time. Instead, just hold down the [Shift] key when you click the Find Next button. Excel searches in the opposite direction through the worksheet as it hunts for matches to your search string.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.