|
Summary: There are times when you want to replace a column with formulas to just the underlying value. Here is a quick way to do this:
- Select the range of formulas in the column.
- Locate your cursor on the right edge of the black border of the selected cells.
- Your cursor will change from the white plus sign to four black arrows.
- Hold down your right mouse button and drag the range to the adjacent column and then back to the original column.
- Release your right mouse button.
- From the menu that now appears, select Copy Here as Values Only.
The formulas in the selected column will now be converted to values.
|
Summary: There will be times when you want to make a group of columns the same width. Here is a quick way to do this:
- Select the column with the correct width.
- Locate your cursor on the right edge of the black border of the selected cells.
- Your cursor will change from the white plus sign to four black arrows.
- Hold down your right mouse button and drag the range to the adjacent column and then back to the original column.
- Release your white mouse button.
- From the menu that now appears, select Copy Here as Values Only.
The formulas in the selected column will now be converted to values.
Summary: If you have PivotTable data displaying the data by days and you want to display the data by weeks, there is an easy way to do this in an Excel PivotTable.
- Select a cell in the PivotTable with a date value.
- Right mouse click.
- Select Group.
- Excel will display the date range for your data.
- Select Days.
- Deselect Month (if necessary).
- Make the number of days 7.
- Click OK.
Your data will now be grouped into weeks, showing the first and last day of each week. Note: If you receive an error message "Cannot Group That Selection" you need to convert your dates from a text date to real dates."
Back to top
|
 Creating Section Breaks in a Word Document Summary: There are times when you want to vary the layout of a document in different sections for the document. This is done using section breaks. Here is how to apply a section break to a document: A section break indicates the end of a section in a document. Using a Section Break enables you to vary the layout of a document within a page or between pages. For example, you might format the introduction in a report in a single column and then a section of the report in two columns. This requires you to format each section separately and putting a section break between the two sections allows you to do this.
Section breaks allow you to change the page numbering, page borders, page margins, number of columns, page headers and footers, and other formatting characteristics in a section. The section break retains the formatting above it but not after it. Here is how to create a section break:
- Open the document.
- Click where you want to insert a section break.
- Click on the Page layout tab.
- Select Breaks in the Page Setup group.
- The Breaks menu window will appear.
- Select the type of break you want to use. Your choices are as follows:
- Click Next Page to begin a new section on the next page.
- Click Continuous to begin a new section on the same page.
- Click Even Page to start the new section on the next even-numbered page.
- Click Odd Page to start the new section on the next off-numbered page.
When you click on the option you want, the section break is inserted. If the Show/Hide Formatting feature is turned on (in the Home | Paragraph Group, you will be able to see the section breaks in the text. Creating a Drop Cap Summary: A drop cap is an enlarged capital letter at the beginning of a paragraph that extends down over two or more lines at the beginning of a paragraph. Here is how to create a drop cap:
To create a drop cap:
- Select the character that you want to format as a drop cap.
- Click on the Insert tab and click on Drop Cap in the text group.
- Click on the Page layout tab.
- A context menu will open and you have three options:
- The Breaks menu window will appear.
- None, the default keeps a standard letter.
- Click Dropped to have the first letter dropped within the paragraph text.
- Click In Margin to set the capital letter off in the margin.
- Click Drop Cap Options to see addition options. You can change the font, define how many lines will be dropped (3 is the default), and specify how far the text the dropped cap will be place.
6. Click OK and your drop cap will be created. Back to top |
Out of Office Replies
Summary: if you are running Outlook Exchange, you can use the Automatic Replies feature in Outlook to let people who send you e-mail know about your availability. Here is how to do this:
The out-of-office feature is provided by Exchange Server. The objective of the Automatic Replies is to provide a response to people who send you e-mails. If you're not available, the automatic reply can let people know when they can expect a reply to your message. In addition to having Outlook send automatic replies, you can use it to process messages that arrive while you are out of the office by using rules that are in effect only when the Automatic Reply feature is on.
The Automatic Reply feature is off until you explicitly turn it on.
With Exchange 2010 or Exchange 2007, Automatic Replies provides the following features:
- You can create two auto-reply messages. One that Outlook only sends to people in your organization, or another sent to people in your primary address book.
- You can specify the font, size, and color of your automatic reply message text and apply bold, italic and underline formatting.
- You can format paragraphs as bulleted or numbered lists.
- You can specify the start and end dates so that you don't have to remember to turn off your automatic reply. Here are the steps to setup your automatic reply:
- Open Outlook.
- Click on the File tab.
- In the Backstage View, click the Automatic Reply button.
- Click Send Automatic Replies.
- Click on the radial button I am currently out of the office.
- In the window enter your message.
- Click on OK.
Your out of office message will now be sent to each person who sends you an e-mail until your turn it off.
Back to top |
