Creating drop down lists with comma-separated values Select a cell or range for your drop-down list. ... Use Excel Data Validation to create a drop-down list. ... Enter the list items and choose the options. ... Type the entries for your drop-down list. ... Create a named range. ... Select the location for your drop-down list.

In a chart, click the value axis that you want to change, or do the following to select the axis from a list of chart elements: ... On the Format tab, in the Current Selection group, click Format Selection. In the Format Axis dialog box, click Axis Options, and then do one or more of the following:

To hide unused rows in Excel 2003, select the row beneath the sheet's last used row. ( Select the row header to select the entire row.) Next, press Ctrl + Shift + Down Arrow to select every row between the selected row and the bottom of the sheet. Then, choose Row from the Format menu and select Hide.

Reference cells from other spreadsheets by adding the sheet name, followed by an exclamation point, before the cell reference. Use commas to separate up to 255 cell references in the Sum function. For example, "= SUM( Sheet2! A1, Sheet3! B2: B6)" adds the values in cell A1 of Sheet2 to the values in B3 through B6 of Sheet3.

Type =, then click the cell that contains the first text you want to combine, such as a person's first name. Type &” “& (a space enclosed in quotation marks). Click the next cell with the text that you want to combine, such as the person's last name, then press Enter.

See screenshot: Tip: If you want to count the duplicates in the whole Column, use this formula = COUNTIF( A: A, A2) (the Column A indicates column of data, and A2 stands the cell you want to count the frequency, you can change them as you need).

If you are looking to take control of your habits and choices, here are the eight most powerful things you can do to master self-discipline. Know your weaknesses. ... Remove temptations. ... Set clear goals and have an execution plan. ... Build your self-discipline. ... Create new habits by keeping it simple. ... Eat often and healthy.

Show your parents the card the way it is to prevent getting in more trouble. They will be more angry if you lie or hide it from them. Don't type a card that says you got all ' A's when they were nearly all ' F's. Tell your parents your plan of action that will fix the grades for next semester.