Microsoft Excel - Recent Questions, Troubleshooting & Support - Page 7

How to remove Excel password? · Open the excel 2007 file that has been encrypted, password protected and locked. It will ask you for the password. Enter the password and click OK · Click on the office Orb on the top left · Select Prepare >> Encrypt document · An Encrypt document dialog box pops up with the password set (in asterisk) · Clear the password and click Ok · Save and close the excel 2007 file

Excel - Drop Down List Ever wish that you didn't have to type out the same thing over and over again? Well you can save time by using Excel's drop down list! Drop Down Preparation Imagine that we are creating an Excel spreadsheet to document our purchases from the grocery store. For each purchase we want to mark down the name of the food and the type of the food. The way a drop down list works in Excel is that it takes values from some place on your spreadsheet and uses them to populate the options in the list. Lucky for us, the type of food is a perfect opportunity to use a drop down list! In cells A1 through A7 enter the type of food that will be used for the drop down list. Creating a Drop Down List Now that we have a source for our drop down list, we can create a begin to create our drop down. 1. Select cells D2 though D20 (We will be creating a drown down list for each cell in this range) 2. Click the Data menu and select Validation 3. Choose List from the Allow drop down menu 4. Click the Source button that appears to the right of the textfield 5. Select our source cells A1 though A7 6. Press Enter and Click OK Testing Your Drop Down All of your cells in the Type column should now have a drop down list. To test to see if your drop down works, click on cell D2 and then click on the downward facing arrow and see if all the types of food are available.

In the cell that you want the result to appear in, enter the appropriate formula from the following examples. How to Count the Occurrences of a Number Use this formula =SUM(IF(range=number,1,0)) where range is the range that you want to search, and number is the number that you want to count. NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER. How to Count the Occurrences of a Text String Method 1 Use this formula =SUM(IF(range="text",1,0)) where range is the range that you want to search, and text is the text that you want to find (the text must be enclosed in quotation marks). NOTE: The above formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER. Method 2 Use the COUNTIF() function to count the occurrences of a text string. For example, use the formula =COUNTIF(range,"text") where range is the range of cells that you are evaluating, and text is the text string that you want to count instances of (note that text must be enclosed in quotation marks). NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER. Wildcard characters can be used within the COUNTIF function. The asterisk character (*) represents more than one character. For example, to count all the cells in the range a1:a10 that contain an "x," you can use the following formula: =COUNTIF(a1:a10,"*x*") The question mark character (?) can also be used to represent one wildcard character -- for example, to count all cells in the range whose second character is the letter, such as "ax" or "bx." =COUNTIF(a1:a10,"?x*")