Start Microsoft Excel and open an existing spreadsheet that contains range names that you would like to manage, filter, edit, delete or create additional range names.
Choose the "Formulas" tab to display the "Formulas" ribbon. Click the "Name Manager" button to open the "Name Manager" dialog box.
Click the "New" button in the "Name Manager" dialog box to open the "New Name" dialog box. In this dialog box, you can provide a name, scope, comment, and cell reference for the new range name that you create.
Select a range name you would like to edit from the "Name Manager" list and click "Edit" to open the "Edit Name" dialog box. Here you can rename the range, change the scope, edit the comment or change the cell reference.
Identify a range name you would like to delete from the "Name Manager" list and click the "Delete" button. A dialog box will come up and ask you to confirm that you want to delete the name range. Click the "OK" button to delete the name range from the "Name Manager" dialog box.
Highlight and click the "Filter" button on the top right of the "Name Manager" dialog box to display the filter options available for the name manager. You can filter to find range names that are located in the current workbook, that are located in the current worksheet, that have errors, that don't have any errors, defined names and table names.
Complete the process by clicking on the "Close" button. This will close the "Name Manager" dialog box after you have finished managing the range names.
Start Microsoft Excel 2007 and open an existing workbook that contains range names that you would like to use in a formula.
Click on the cell where you would like to enter a formula using one of the range names you have already identified.
Begin typing the formula you want to use inside of the cell until you come to the part of the formula that requires you to reference a group of cells that you have created a range name for.
Choose the "Formulas" tab to display the "Formulas" ribbon. Click the "Use in Formula" drop-down list button in the "Defined Names" category. You will see the range names that you have defined in your current Excel workbook.
Select the range name that you would like to use in the formula you are typing. The range name will be inserted into the formula you are typing.
Continue typing the rest of your formula. Press the "Enter" key when you are finished to enter the formula into Excel. The result of your calculation will now be displayed.
Start Microsoft Excel 2007 and open an existing workbook that contains a chart that you would like to change the display of the axes.
Click the chart that you want to change the display of the axes so it is selected. The chart will have a light blue border surrounding it, indicating that it is selected.
Choose the "Axes" button in the "Axes" section of the "Layout" ribbon. A drop-down menu will appear.
Point to "Primary Horizontal Axis" to view the options for changing the display of the primary horizontal axes. The display options for your primary horizontal axis will be displayed in a menu. Click on the title and description that you want to apply to your primary horizontal axis.
Select the "Axes" button in the "Layout" ribbon once again and point to "Primary Vertical Axis." Click on a title and description for the display option you want to apply your primary vertical access.
Open Microsoft Excel 2007, and start a new, blank spreadsheet or open an existing spreadsheet from your files into which you want to generate a random number.
Click the cell you want to generate a random number into so it is selected. The cell will have a thick black line outlining it.
Type "=RAND()" (no quotations) into the "Formula" text box near the top of the Excel screen. This is the function that instructs Excel to enter a random number between 0 and 1 into the selected cell.
Press the "Enter" key on your keyboard. The random number will be generated into the selected cell and you will be taken to the cell beneath it.
Continue the process of generating random numbers into your Excel cells using the same method as outlined above.
Start Microsoft Excel 2007, and open an existing spreadsheet from your files or create a new blank spreadsheet into which you want to generate a random number within a range that you designate.
Select the cell or multiple cells that you want to generate the random number into. You can use the SHIFT or CTRL keys on your keyboard to select multiple cells at the same time. The cells that random numbers will be generated into will be outlined by a black heavy line.
Type "=RANDBETWEEN" (no quotes) into the "Formula" textbox near the top of the Excel screen.
Continue to type the rest of the function that specifies the range you want the random numbers to fall into. "([Bottom],[Top])" (no quotes) should be inserted after "=RANDBETWEEN" (no quotes) with numbers replacing the word "Bottom" and "Top." The "Bottom" number should be the lowest random number you want to be generated ant the "Top" number should be the highest number you want to be generated.
Press the "Enter" key on your keyboard if you selected one cell or the "CTRL+ENTER" if you have selected multiple cells. You will now see random numbers have been generated in the range that you have specified.
Start Microsoft Excel 2007, and open an existing workbook from your files in which you want to insert a static time into one of the cells. Alternatively, you can start a new, blank workbook to insert the static time.
Select the cell in the workbook you want to insert the static time into by clicking on it. The selected cell will now have a thick black box around it, indicating that it is selected and ready for the next step.
Hold down the "Ctrl," "Shift" and ":" keys at the same time on the keyboard. This keyboard shortcut will instruct Excel to enter a static time into the selected cell.
Look at the cell, and see the current time to be inserted into the selected cell. This time will not change at any point unless you manually change it yourself. It will not update on its own at any time.
Insert the static time into any other cells in the open Excel workbook using the same procedure that is outlined in the previous steps.