 Displaying Values that are in Millions as Thousands
|
Summary: Many times, it is often useful, for display purposes, to show the numbers in a report, as if each number was divided by thousands Here is how to do this:
- Select the desired cell/cells.
- Right-click on the selected cell/cells.
- Select Format Cells.
- Select the Number tab.
- Under Category select Custom.
- In the Type Box enter 0,.
- Select OK.
All of the numbers will now display and print as if they were divided by thousands.
|
How do you Select Visible Cells Only to Copy and Paste?
|
Summary: There are times when you only want to copy cells that are visible on your screen and not any hidden cells. Here is how to do this:
- Select the desired range of cells.
- From the Home tab, in the Editing Group, Select Find and Select.
- Select Go to Special.
- Under Select, select Visible Cells only.
- Select OK.
- On the Home tab select Copy.
- Activate the worksheet or workbook that you want to copy the data to.
- On the Home tab, in the Clipboard group, select Paste.
Just the visible cells will be pasted into the new location.
|
Back to top
How do you Highlight Visible Cells in a Worksheet?
Summary: There are times when you want to check for duplicate values in a range in a worksheet. Here is how to do this:
- Select the desired cell or range.
- From the Home tab, in the Styles group, select the drop-down arrow under Conditional Formatting.
- Select Highlight Cell Rules.
- Select Duplicate Values.
- Select the Format that you want to see in cells with duplicate values.
- Select OK.
Any cells that are duplicate values will display the format you selected in step 5 above.
Back to top |
| Adjusting Paragraph Line Spacing
Summary: Adjusting the line spacing can often improve the readability of your text. Here is how you do this:
- Click in a paragraph, or select all the paragraphs whose line spacing you want step.
- On the Home tab, click on the Line Spacing button.
- If you do not see the spacing you want, click Line Spacing Options.
- Select Exactly to create a specific space between lines, regardless of the font sized being used.
- Select At Least to create a minimum space between lines, which can increase if large font sizes are used.
- Select Multiple to specify how many lines of space you want between the lines of text.
- Use the arrow or type a value. For Exactly and At Least settings,this is a distance measurement, usually in Points. For Multiple, this is the number of lines of space.
- Click OK.
Back to top
Creating a Bulleted or Numbered List
Summary: Using a bulleted or numbered list is a good way to clearly present information. Here is how to do this:
- Start typing the first line of your list. Make sure you are using the paragraph style you want for the list.
- On the Home tab, click on the Number button for a numbered list, or the Bullet button for a bulleted list.
- After you have finished typing the first line, press Enter to start the second list item.
- When you have finished the list, press Enter twice to create an empty line and turn off the list formatting.
Not only does Word add numbers or bullets to your list, with consistent spacing between the number of bullet and the text, it also keeps track of your list, so that if you move an item within the numbered list, Word will renumber the item to keep it in the correct order. You can also have the numbering skip paragraphs.
Back to top
|
Responding to Messages
Summary: There are a number of different ways that you can respond to an incoming e-mail. Here is a summary of your options:
- Reply Creates an e-mail message addressed to only the original message sender.
- Reply All Creates an e-mail message, addressed to the message sender and all recipients list in the To or CC boxes.
- Reply with Meeting Creates a meeting invitation addressed to all the message recipients. The message text is included in the meeting window content pane. Outlooks suggest the current date and an upcoming half-hour time slot for the meeting.
- Forward Creates a new message that contains the text of the original message and retains any attachments from the original message.
- Forward as Attachment Creates a blank message that contains no text but includes the original message as an attachment. The original message and any attachment are available to the new recipient when they open the attached message.
- Forward as a Text Message Creates a text message to be sent by an SMS text messaging account to a mobile device, such as a mobile phone or tablet.
Back to top
|
