Tuesday, May 31, 2016

Rename an email subject line (in MS Outlook)

Do you get emails with a subject line that don’t make sense or don’t have anything to do with the actual message?
You can rename those email subject lines.
1. Double-click on the email to open and select the text in the subject line.
2. Type the new subject line. Click on the X to close out of the message window.
3. You will get a message dialog box asking if you want to save changes. Click Yes.

Friday, May 20, 2016

MS Outlook - Create reusable text blocks for e-mail messages

Create reusable text blocks for e-mail messages

Do you find yourself repeating certain text in your emails? Maybe you include directions to your office, a standard set of questions for potential clients, disclaimers, contract clauses, or your logo. Quick Parts enables you to save selected text or graphics for quick insertion into your Outlook e-mail message without having to retype the selection or cut and paste. Use Quick Parts to save text that you use time and again.

Don’t retype or copy and paste – use Quick Parts. Here’s how:

1.  From a new mail message, click in the text area of the message and type the text you would like to store as a reusable building block. Apply any formatting to your text.
2.  Select the text.

3.  On the Insert tab, in the Text group, click Quick Parts.

4.  Click Save Selection to Gallery Name Gallery.

5.  Fill out the information in the Create New Building Block dialog box. Click OK.

6.  Now the next time you need to insert certain text, go to Quick Parts and click on the text to insert.   

Tuesday, May 10, 2016

Excel - Indent Text in a Cell

What happens when you hit the Tab key on your keyboard in a Word document?
It will indent 5 spaces. 
What happens when you hit Tab in Excel? 
It moves to the next cell. 
So how do you indent text in a cell in Excel? 
By increasing or decreasing indent.

Pressing [Tab] in Excel doesn't indent text in a cell; it simply moves the cell pointer to the next cell. 

To indent text in a spreadsheet cell: On the Home tab, in the Alignment group, use the Increase Indent button.

Enter your text without any lead spaces, select the cells whose entries you want to indent, and click the Increase Indent button. Each time you click that button, Excel nudges the selected text to the right. If you go too far, you can click the Decrease Indent button to nudge the text back toward the left.