For example, you can separate a column of full names into separate first and last name columns. In Word, use this feature to convert the selected text into a table, splitting the text into columns at each comma, period, or other character you specify. You can specify which columns should be checked for duplicate information. Data connections are links to data outside of this workbook which can be updated if the source data changes. Once filtering is turned on, click the arrow in the column header to choose a filter for the column. For example, you could reject invalid dates or numbers greater than 1000. You can also force input to be chosen from a dropdown list of values you specify. New or modified data in the column won't be filtered or sorted until you click Reapply. Alt, H, A, L Applies align left. Alt, H, A, M Middle Align - Align text so that it is centered between the top and bottom of the cell. For instance, choose Euros instead of Dollars. Alt, H, A, T Top Align - Align text to the top of the cell. You can also replace the information with new text or formatting. You can fill cells in any direction and into any range of adjacent cells. Double-click this button to apply the same formatting to multiple places in the document. This is often used for labeling narrow columns. Click the currently selected text orientation again to reset the text back to normal orientation. Alt, H, I Insert - Click here to insert cells, rows, or columns into the sheet or table, or to add a sheet to the workbook. This will change the format of the cell to Accounting without a currency symbol. You can sort the selected data in ascending or descending order, or you can temporarily filter out specific values. It will automatically update as you change the workbook. This is only necessary if automatic calculation has been turned off. Many people choose to use the text in the top row or the leftmost column of a selection. This is only necessary if automatic calculation has been turned off. Names can be used in formulas as substitutes for cell references. You specify at which level in the TOC the selected text should appear. The values are displayed in a separate window that remains visible, regardless of what area of the workbook is shown. Area charts emphasize differences between several sets of data over a period of time. Bar charts are the best chart type for comparing multiple values. Column charts are used to compare values across categories. This type of chart compares pairs of values. Use it when the values being charted are not in X-axis order or when they represent separate measurements. Inserting a digital signature requires that you obtain a digital ID, such as one from a certified Microsoft partner. The information in the Header or Foot
