Annoying Lines in Word

Word uses auto-format to save you time on some formatting tasks.  However, sometimes there are unexpected results.  Suppose you type a paragraph, press Enter, type 3 hyphens and press Enter again.  Word converts the3 hyphens to a solid line.  If you change your mind and want to delete the line, the usual methods of deleting don't work.
No matter what you do to try to delete the line, it remains.

The reasons for this behavior is that the line isn't a separate object; it is part of the formatting of the paragraph.  It's a paragraph border.  To get rid of the line, position the cursor anywhere in the paragraph and choose No Border from the Borders tool on the Formatting menu.  The line immediately disappears!

    

On the Mac, select the Toolbox; Borders and Shading;  Type: No Border

Outlook - Sending an Email on Behalf of Someone Else

Have you ever sent an email on behalf of someone else and had to handle the replies (that should have gone) to someone else?  Here's a fix for that.  You can send an email and automatically have replies go to someone else.   Here's how:

In Outlook, open a new message for editing.
Select the Options tab in the ribbon.
In the More Options group, select Direct Replies To.
In the Delivery Options section, use the Select Names button to find the name of the person you want to receive the replies. 

Select their name and click Reply To ->;   Clear your own name from this box.  Click OK.

Click Close.
Address your email, complete the message and send it.  When a recipient clicks reply, the message will be mailed to the person you selected, not to you!

Repurposing a Power Point Presentation by Hiding Selected Slides

If you have a Power Point presentation that you want to use with several different audiences, you may want to omit certain slides for one of the groups (and not save multiple versions of the same show).  You can do this by hiding selected slides.

To do this open your presentation
In Normal view, click on the slides tab on the left.
Select one or more slides that you want to skip during the show.
Right click on the slide and select Hide Slide.
(For the Mac, use Control click to get to the Hide Slide option).

You can use the same steps to Unhide the slides at a later time.

Easy Data Entry in Excel

If you are using Excel for row after row of data entry in a spreadsheet such as the following one, you might find yourself at the end of each row having to move the cursor down and to the left to start the next row.  That's because the default is for Excel to move the cursor to the next cell when you press Enter.  After filling D4 and pressing Enter, the cursor would be in cell E4.  you want to type in cell A5 next, not E4.

You can make the cursor automatically move to the first cell in the next row when you press Enter if you first select the range you are going to fill.  Notice how the range A1:D10 is selected.  When you press enter after filling cell D4, the cursor will jump to the next cell in the range which is A5.  This can make data entry much easier.

(Works the same on the Mac and PC)

A few notes about using this tip:

When you highlight the rectangular area for data entry, start the highlighting in the cell where you will type first.  Immediately start typing after you do the drag to  highlight the area.

If the cursor moves in the wrong direction after you press Enter, you can change that.
Select the MS Office button;  select Options;
Select Advanced;
Check the option After pressing Enter, move selection.
Set the direction for the move from the drop-down list .
To enter data across a line, you'll want the direction set the direction to Right.