Insert your own summary rows

Insert your own summary rows
· Insert your own summary rows with formulas immediately below or above each group of detail rows.
5. Specify whether the location of the summary row is below or above the detail rows.
How to specify the summary row location.
1. On the Data tab, in the Outline group, click the outline Dialog Box Launcher.
2. To specify a summary row above the details row, clear the Summary rows below detail check box.
To specify a summary row below the details row, select the Summary rows below detail check box.
Outline the data. Do one of the following:
Outline the data automatically.
If necessary, select a cell in the range.
1. On the Data tab, in the Outline group, click the arrow next to Group, and then click Auto Outline.

Important If you ungroup an outline while the detail data is hidden, the detail rows may remain hidden. To display the data, drag across the visible row numbers adjacent to the hidden rows. On the Home tab, in the cells group, click Format, point to Hide & Unhide, and then click Unhide Rows.
Prevent invalid data entry in a worksheet
In many worksheets that you create, users will enter data to get the desired calculations and results. Ensuring valid data entry is an important task. You may want to restrict data entry to a certain range of dates, limit choices by using a list, or make sure that only positive whole numbers are entered. Providing immediate help to instruct users and clear messages when invalid data is entered is also essential to make the data entry experience go smoothly. Once you decide what validation you want to use on a worksheet, you can set up the validation by doing the following:
1. Select one or more cells to validate.
2. On the Data tab, in the Date Tools group, click Data Validation.










Tab Data Validation dialog box is displayed.
3. Click the Settings tab.
4. To specify the type of validation that you want to, do one of following:
1. In the Allow box, select List.
2. Click the Source box and then type the list values separated by the Microsoft Windows list separator character (commas by default).
For example,
· To limit entry to a question, such as "Do you have children?" to two choices, type Yes, No.
· To limit a vendor's quality regulation to three rating, type Low, Average, High.
You can also create a list of values from a range of cells, For more information, see Create a drop-down list from a range of cells.
NOTE: The width of the drop-down list is determined by the width of the cell that has the data validation. you may need to adjust the width of that cell to prevent truncating the width of valid entries that are wider than the width of the drop-down list.
3. Make sure that the In-call dropdown check box is selected.
Allow a whole number within limits.
4. In the Allow box, select Whole Number.
5. In the Data box, select the type of restriction that you want. For example, to set upper and lower limits, select between.
6. Enter the minimum, maximum, or specific value to allow. You can also enter a formula that returns a number value.
For example, to set a minimum limit of deductions to two times the number of children in cell F1, select greater than or equal to in the Data box and enter the formula, =2*F1, in the Minimum box.
7. In the Allow box, select Dec