 Converting Text
|
Summary: I import a file from my accounting program on a regular basis and the Product Names in my inventory are in Upper Case and I want them in lowercase, with the first letter in each word capitalized. Here is how to do this:
Assume that the Upper Case names are in column A, starting in A2.
- In B2 enter the following formula: =PROPER(A2).
- Press Enter.
- Copy this formula down column B, so it applies to all of the cells in Column A that have Product Names.
- Cut all the cells in column B that contain the formula.
- Do an Edit Paste Special, Past Values to all the cells in column A that contain the Product Names. Column A will now display the product names in lower case with the first letter of each word capitalized.
|
How do you Delete Duplicate Rows from a Data Set?
|
Summary: Many data sets contain duplicate rows. Here is how to eliminate these duplicates.
- Highlight the data set (You may include/exclude the heading row).
- Select the Data tab.
- Select Remove Duplicates under the Data Tools group.
- Select OK.
- Select one or more columns that contain duplicates (you must select at least one column).
- Select OK.
- Select OK again.
The duplicate data rows will be deleted from the worksheet. Note there is no UNDO with this command, so save your workbook before you do data elimination.
|
Back to top
Summary: Here's a fast way to remove borders from a group of cells.
Adding Borders around a range of cells is a useful formatting tools. There are times however, when you need to remove these borders. Here is a fast way to accomplish this task.
- Select the cells that contain the borders you want to remove.
- Press Ctrl+_.
- The third character is the underscore key and you must hold down the shift key to insert it.
This process will remove the borders but leave the rest of the formatting.
Back to top |
|
Create and Use Columns
Summary: You can format your documents in a single column or in two or more columns, like the text in a magazine. Here is how you do this:
- Place the insertion point at the place where you want the columns to start.
- Click on the Page Layout tab.
- Click on Breaks in the Page Setup Group.
- Click Continuous.
- Select the number of columns you want.
Or if you do not see what you want, click on More Columns. - Set the number of columns you want and any other feature.
- Click OK.
Now your document will be formatted to the number of columns you have defined.
Back to top |
|
Summary: There are several different ways to quickly add a contact from e-mail. Here are three ways to do this:
Creating a Contact by Copying
- Open an e-mail message.
- Right click on the name in the message window.
- Click Add to Outlook Contacts.
- Fill in any additional information.
- Click Save & Close.
The name and e-mail address will be added to your contacts.
Creating a Contact by Dragging - Open an e-mail message
- Click on the message and drag it onto the Contacts view bar in Outlook View.
The name and e-mail address go into their respective fields, and the message information displays in the Contact window. The New Contact window opens in back of the Mail window, and when it is saved, it closes automatically.
Create a Contact from an Electronic Business Card
Electronic business cards contain contact information in a small, easy-to-share package. If another Outlook user sends you an electronic business card attached to an e-mail message, you can automatically create a new contact when you save the message.
- Open the e-mail message.
- Double-click on the electronic business card attachment.
- The Add A Contact dialog box appears. (You can modify the information)
- Click Add Contact.
The information is now in your contacts.
|
Putting a Standard Footer on all Your Slides
Summary: A standard footer includes the date, some text, and/or the page number. Here is how to put a standard footer on all the slides in your presentation:
- Click on the Insert tab.
- Click on the Header & Footer button.
- Choose some or all of the options to enter a footer.
- Date and Time: Select this check box to make the date appear on all your slides. Then tell PowerPoint whether you want the current date or a fixed date.
- Slide Number: Select this check box if you want the slide number on every slide.
- Footer: Select this check box, and in the text box, enter the words that you want to appear on all the slides.
- Click on the Apply to All button to place footers on all you slides.
Back to top |
