Delete Multiple Files - Spreadsheet Too Wide - Auto Fill-in Outlook Express - Using BCCs
Deleting Multiple Files
Paul Gonzales wrote that he had hundreds of emails backed up in his Inbox and asked how to delete them en masse rather than one at a time. Well, most email programs let you select multiple messages by clicking on the first in a list, pressing Shift, and then clicking the last one. The group can then be removed with your Delete key. To select non-contiguous items, hold down Ctrl as you point and click. These steps also work on most computer lists, such as files in a folder.
Spreadsheet Too Wide for the Paper
Nancy Hillard wrote that she had an Excel spreadsheet that, when printed, would not fit on a standard sheet of 8.5x11-inch paper even if she chose to print "Landscape" rather than "Portrait" (11-inch
Well, Nancy had used 10-point Arial for the whole sheet. When I changed the font to 8-point Arial Narrow, followed by clicking Format>Column Width>Auto Select, everything almost fit into a Landscape layout. However, the text in some of the first-row-Headers was lengthy and pushed the sheet beyond the 11-inch width. So I re-oriented the Header text to an angle by selecting the row and doing Format>Cells>Alignment>Text.
On really wide spreadsheets you can use legal-size paper and take advantage of the 14-inch width. You can also make your left and right margins narrower, depending on the limitations of your printer.
Excel — Pasting in a Formula Not Working Properly
Pete Peterson called to say when he tried to copy and paste a formula from one Excel spreadsheet cell into another, the total of the formula appeared instead of the formula itself. We fixed this by using Edit>Paste Special>Formula.
A similar situation can arise after copying a block of text and using Edit>Paste to put it into another document, whereupon it inserts itself as a "picture" of the copied text which cannot be edited. This can be circumvented by using Edit>Paste Special>Formatted Text (or Unfofmatted Text, if prefered).
Outlook Express — Automatic Name Fill-in
John Philip wrote to ask what the steps are to complete an e-mail address in Outlook Express after typing in just one or two of its characters. This is done by opening Outlook Express, clicking on Tools>Options>Send, and check-marking "Automatically complete e-mail addresses when composing." Then any name in the Address Book that matches the first few letters typed into the TO box (or into the CC or BCC boxes) will automatically fill in.
If you don't see a BCC (blind carbon copy) box, launch OE, click Create Message, and then click View>All Headers. Henceforth the BCC box will always appear under the CC box, and should be used whenever you send a message to multiple users.
BCCs - Blind Carbon Copies - Essential for Mass Mailings
A "blind carbon copy" allows a recipient to see only his or her email address. Using the CC box ensures that all recipients will see everyone else's addresses besides their own. This is how spammers often find addresses to add to their lists. No, your friends won't give those addresses away — but who knows where a print-out of a message might end up?
© Donald Ray Edrington - All Rights Reserved