|How to Quick Sort a PivotTable
Summary: The quick sort buttons in Excel offer one-click access to sorting cell values. There are four entry points to the quick sort buttons. Here is how to do this:
- On the Home tab, select Editing, Sort and Filter, Sort A to Z or Sort Z to A. or
- On the Data tab, select Sort & Filter, select either the AZ or ZA quick sort buttons to sort the active field. or
- Rick-click in a cell in the PivotTable, select Sort and choose from Sort A to Z or Z to A.
- From a PivotTable filter drop down, select Sort A - Z or Sort Z - A.
Unlike sorting outside a PivotTable, it doesn't matter if you have more that one selected during the sort. Excel will automatically sort the entire PivotTable. If multiple columns are selected Excel will only sort the left most column in the selection.
Excel Header and Footer Codes
Back to top
Summary: Excel has a number of header and footer codes that provide short cuts to entering data in a header and/or footer. This makes entering such data much easier. Here is a table that contains the most important codes:
The codes are entered directly into a header or footer by typing an ampersand character (&) followed by the command. The table below contains a list of the most important controls.
&F Workbook Name
&A Worksheet Name
&P Current Page Number
&& Ampersand character
&D Current Date
&T Current Time
Deleting Duplicates from a Data Set
Back to top
Summary: It is very easy to delete duplicate values from a data set. Here is how to do this.
- Select a cell in the data set.
- Go to the Data Tab.
- Click on the Remove Duplicates in the Data Tools group.
- Excel will highlight the data set. If there are columns missing in the selection, go back and make sure there are no blank columns in the selection.
- Make sure that My Data has Headers is selected if your data set has headers.
- By default, all the columns are selected. A selected column means that the tool will use all the columns to check for duplicates. Duplicates in an unselected column will be ignored. Select the columns that you want to match for duplicates.
- Click OK. The data set will update, deleting any duplicate rows. A message will appear to tell you how many rows were deleted and how many rows remain in the data set.
Note there is no undo for this process. Save your work before you run this process.
Summary: Word has a hyphenation feature that automatically hyphenates words at the end of lines. This provides a better fit and eliminates uneven margins. Here is how to do this:
- Click on the Page Layout tab.
- Click Hyphenation in the Page Setup Group.
- Click Hyphenation Options to open the Hyphenation dialog box.
- Select the option you want. The options are as follows:
- Automatically Hyphenate Document enables automatic hyphenation as you type.
- Hyphenate Words in CAPS hyphenates words typed in all upper case letters.
- Hyphenate Zone sets the distance from the right margin within which you want to hyphenate the document. (The lower the value, the more words are hyphenated.)
- Limit Consecutive Hyphens sets the maximum number of hyphens that can appear in consecutive lines.
- Click on OK.
Summary: An electronic business card packs a lot of information into a small package. If you receive an electronic card in an e-mail you can automatically create a new contact when you save the message. Here is how to do this::
- Open Outlook.
- Open the e-mail message.
- Double click on the electronic business card attachment. This will open the contact window.
- Click Save and Close.
- If you already have a contact with the same name, Outlook will display the Duplicate Contact dialog box.
- Click Add New Contact if you want a duplicate contact.
- Click Update Information of Selected Contact, and then double click on the contact you want to update. The contact window will open. Make the necessary changes, and save the contact information.
- Click to select any desired conditions that limit which messages the rule applies to, and then click the link in the description panel, which may display a dialogue box to specify the exact criteria.
- Click Update.
You will now be returned to the Rules and Alerts dialogue box, which will now show your next rule.
Drawing a Line on a Slide
Summary: There are times when you will want to add a line of an arrow on a slide. Here is how to do this:
- Click on the Home Tab or the Insert Tab.
- Click on the Shape Button in the Drawing Group.
- Select a Line shape from the available list.
- Click and drag the mouse pointer to add the line to your slide.
- You can make the line as long as you want.
- Release the mouse button to draw the line.
- Next you will probably want to change the style of the line.
- Click on the line.
- Click on the Home tab.
- Click on the Quick Styles button in the Drawing Group.
- Highlight the style that you want to use.
- Click on it to use it.
Be careful if you use the Replace All button that you are certain that only the text you have selected will change. You do not want to change part of a word because it closely matches your criteria.