May 28 - June 3, 2007
Find all occurrences of a word at once (Excel 2002/2003)
In Excel 2002 and later, you can quickly locate and navigate to all instances of a particular character string. To do so, choose Edit | Find from the menu bar or press [Ctrl]F to launch the Find And Replace dialog box. Then, enter the text you want to find in the Find What text box. Finally, click the Find All button. The dialog box expands to show a list of all the found matches. Clicking on the items in the list selects the relevant cell, which is especially handy when working with large worksheets. Another plus is that you aren't just limited to finding occurrences in the current worksheet--you can search an entire workbook. To do so, click the Options button on the Find And Replace dialog box. Then, choose Workbook from the Within dropdown list and click Find All.
Edit the subject line of received messages (Outlook 2000)
Have you noticed that the subject lines of messages sent to you don't always express what's in the message? Maybe the text isn't descriptive enough or you want to add something to jog your memory later. Even though the subject line seems untouchable in the gray area above the message, don't be intimidated--you can edit it. Open the message and place your insertion point in the subject text, then add or change the text as needed. Now, close the message and click Yes to save the changes.
Drag and drop selections in place (Photoshop 6/7/CS)
To move something from one Photoshop document to another, you can copy and paste the selection. However, this copies the selection to the clipboard, which uses up a lot of RAM. Alternatively, you can drag an image, selection, or layer from one window to another using the Move tool. To center an image, selection, or layer, press the [shift] key as you drag it into the new document.
|