How to Plot a Time vs. Growth Graph in Excel 2007

1. Open Microsoft Excel 2007.
2. Place all the 'Time' values in one column, for example, column A. Place all the 'Growth' values in an adjacent column, column B. The 'Time' values become the x-axis values while the 'Growth' values are the y-axis values.
3. Click the first cell included then drag your mouse towards the last included cell to select the range of values to be included.
4. Click the 'Insert' tab from the menu bar. Go to the 'Charts' menu and click 'Scatter.'
5. Click 'Chart Area' to display the 'Chart Tools,' 'Design,' 'Layout' and 'Format' tabs.
6. Go to the 'Design' tab and select the style you want to use.
7. Type the main title for your chart under 'Chart Title.' For example, you can use 'Time vs. Growth' as the main title.
8. Click the 'Layout' tab and then click 'Axis Titles.' Select the 'Primary Horizontal Axis Title' and put 'Time' as the title for the x-axis. Click the 'Primary Vertical Axis Title' and put 'Growth' as the title for the y-axis.
9. Press 'Enter' to create the chart.

Read more ►

How to Put Bullets in an Excel Spreadsheet

1. Open the Excel 2010 spreadsheet in which you want to add bullets.
2. Click on the cell where you want to add bullets. If there is already text in the cell, you will need to click on the formula bar above the spreadsheet. Place your cursor where you want the first bullet to go.
3. Hold down the 'Alt' button and press '7' on the numeric keypad. This will not work with the numbers above the keypad, so if you have a laptop without a dedicated numeric keypad, you will need to hold down the 'Function' button as well and type the letter that has 7 as an alternate. The bullet point appears.
4. Add the bullet point to adjacent cells by clicking and holding the mouse button over the bottom right corner of the cell. Drag the mouse to the right or down, and when you release the mouse button, all of the cells between where you started and where you released the button will be identical to the original cell.
5. Create a second bullet point in the original cell by clicking on the cell and then placing the cursor at the end of the first line of text, or right after the first bullet if there is no text. Hold down the 'Alt' button and press 'Enter.' Your text and bullet point will look like they disappeared, but they just moved up a line as you created a new text line in that cell. Press 'Alt' and '7' again to add another bullet point, and continue until you have all of the bullets that you need. You can move up and down between lines in a cell by using the arrows at the right end of the formula bar. You can also press the drop-down arrow at the end of the bar to expand the bar so that you can see three lines at once.

Read more ►

How to Hide Column Letters Numbers in Excel

1. Open your document in Microsoft Excel.
2. Click the 'View' tab on the Office ribbon.
3. Uncheck the 'Headings' check box to hide the column and row headings.

Read more ►

How to Create a Time Chart

1. Double-click on the Excel 2010 icon to open up the program. The program will start with a new spreadsheet.
2. Click on cell A1 and enter the column header for the time column. This will generally be 'Year,' 'Month,' 'Day' or simply 'Time,' although you can make the header anything you want. Then click on cell B1 and enter the header for your data column.
3. Enter your time information into column A, starting at cell A2. Then enter the data you are tracking into column B, starting at cell B2.
4. Click on cell A1 and hold the mouse button as you drag the mouse to the last entery in column B. Release the mouse button and the entire data set will be selected.
5. Click on the 'Insert' tab at the top of the screen. Then click the 'Scatter' button in the 'Charts' area. Select any of the five scatter charts, although it is usually easier to view the data if you choose one of the two options that include both lines and markers. Excel 2010 will now create the chart for you.
6. Click on the 'Quick Layout' button on the ribbon at the top of the screen and choose 'Layout 1' to include your column headers on the graph.
7. Right-click on the time data located just below the chart and choose 'Format Axis' from the drop-down menu. Then change the 'Minimum' and 'Maximum' levels to remove empty space at the beginning and end of your chart. Select 'Close' when you are done.

Read more ►

How to Create a Macro in Excel 2010

1. Identify a complex series of commands you frequently give Microsoft Excel. For example, you could create a macro for formatting a group of cells with 8-point, blue Times New Roman font.
2. Choose the 'File' tab. Click 'Options' and 'Customize Ribbon.' Select the 'Developer' check box in the 'Main Tabs' list to easily access the macro creation tool.
3. Click 'Macro Security' on the 'Developer' tab. Enable macros under the 'Macro Settings' area.
4. Click 'Record Macro' to open a window and create a new macro in Excel.
5. Enter a unique name for your macro. Choose a name that begins with a letter, contains no spaces and accurately describes the macro's function.
6. Select an area to store the macro by changing the 'Store Macro In' field. Create a brief description of the macro so that you can remember its purpose later. Click OK to close the window and begin recording.
7. Perform the series of functions you want to record. Perform each mouse click, keystroke or other function in the proper order to ensure that the macro will work properly.
8. Click 'Stop Recording' when you have finished your series of commands. Microsoft Excel automatically saves the macro when you click this button.
9. Test the macro by selecting an area upon which you want the macro to operate. Select the macro and press 'Run.' Ensure that the macro performs its function correctly.

Read more ►

How to Create a Budget in Excel

1. Go online to the official download website for Microsoft Office.
2. Scroll down the page to the 'Browse Templates' section. Click 'Budgets.'
3. On the left column of the site, navigate to the 'Filter by Product' section. Select 'Excel' from the drop-down menu.
4. Browse the available budget templates. Choose a template with a layout and design that suits your budgeting needs.
5. Click the link for your selected budget template and click the 'Download' button. Once you accept the Microsoft Service Agreement, your template will begin downloading.
6. Open your downloaded template in Microsoft Excel. Customize the colors, fonts, margins and content to your budgeting and financial requirements.

Read more ►

How to Create a Spreadsheet on Microsoft Excel

Using Microsoft Excel 2003 or earlier
1. Open Microsoft Excel.
2. Click 'File' in the top menu bar and select 'New.'
3. Select the 'General' tab and double-click the 'Workbook' item to create a blank spreadsheet. Alternately, select the 'Spreadsheet Solutions' tab to view the program's default templates. Create a new spreadsheet based on a template by double-clicking its icon.
4. Click on a cell within the spreadsheet and begin typing to insert a data point. Press the 'Enter' or 'Tab' key after entering your data to confirm the value. Repeat the process until all data points have been entered.
5. Click 'File' and select 'Save.' Give the file a name, select a save location, and click 'Save' to complete the process.
Using Microsoft Excel 2007
6. Open Microsoft Excel.
7. Click the round 'Office' button at the top-left corner of the window and select 'New.'
8. Select the 'Blank and recent' tab and double-click the 'Blank Workbook' item to create a blank spreadsheet. Alternately, select any tab below the 'Microsoft Office Online' heading to view templates by category (e.g., 'Calendars,' 'Expense Reports,' 'Inventories'). Create a new spreadsheet based on a template by double-clicking its icon.
9. Click on a cell within the spreadsheet and begin typing to insert a data point. Press the 'Enter' or 'Tab' key after entering your data to confirm the value. Repeat the process until all data points have been entered.
10. Click the 'Office' button and select 'Save.' Give the file a name, select a save location and click 'Save' to complete the process.

Read more ►

How to Make a 3x5 Note Card on Excel

1. Click 'Start,' and then click 'Programs.' Click 'Microsoft Excel 2010.'
2. Click 'Page Layout,' and then click 'Page Setup.'
3. Click Size,' and then click 'Custom.'
4. Specify the width to be '3' inches and the height to be '5' inches. Click 'OK.'

Read more ►

How to Delete Multiple cells in Microsoft Excel 2003

1. Decide on the cells that you wish to delete. Make sure that you know what cells you want to delete and where they are located in the spreadsheet.
2. Highlight the multiple cells. To highlight the cells that you wish to delete, left-click and hold on the first cell and then drag the mouse cursor over the additional cells to highlight them.
3. Access the cell sub-menu. Once you have highlighted the multiple cells that you wish to delete, right-click to access the cell sub-menu.
4. Delete the highlighted cells. Scroll to “Delete” and left-click in the cell sub-menu, which will bring up a cell deletion properties box. You can select “Shift Cells Up”, which will shift the remaining cells up when you delete the existing cells, or “Shift Cells Left”, which will shift the remaining cells left when you delete the existing cells. Select the desired option and then click “Okay” to implement.

Read more ►

How to Password

1. Open Excel 2010 and click the 'File' tab. Click 'Open.' Browse the files and locate a workbook. Click the workbook and the 'Open' button. The workbook opens.
2. Select the worksheet where the password protection will be applied. Click the 'Review' tab and select 'Protect Sheet.' The Protect Sheet dialog box appears.
3. Type the password in the provided 'Password' field. Click 'Ok.' When prompted to confirm the password, retype the password. Click 'Ok.' Notice the ribbon has grayed out areas. These areas will not be accessible unless the user knows the password.

Read more ►

How to Check If a Cell Is Empty in Excel Program?

ISBLANK Function
1. Open the Excel worksheet with the data you want to check.
2. Enter an appropriate header in the first empty column.
3. Input '=isblank(B2)' on the row corresponding to the first data you want to check and press 'Enter.' This formula says, 'Cell B2 is empty.' If that statement is true, it returns a value of 'TRUE.' Otherwise, it returns a value of 'FALSE.'
4. Copy the cell containing the formula. Select all the cells corresponding to the data you want to check. Paste the formula.
5. Select the 'Data' tab on the menu and select the 'Filter' button.
6. Click the filter arrow at the top of the column containing the formula. Select 'TRUE' to see the rows or columns with empty cells.
LEN Function
7. Open the Excel worksheet you want to check.
8. Enter an appropriate header in the first empty column.
9. Input---on the row corresponding to the first data you want to check---the following:=if(LEN(B2)
10. Copy the cell containing the formula. Select all the cells corresponding to the data you want to check. Paste the formula.
11. Select the 'Data' tab on the menu and select the 'Filter' button.
12. Click the filter arrow at the top of the column containing the formula. Select 'TRUE' to see the rows or columns with empty cells.
IF Function
13. Open the Excel worksheet you want to check.
14. Enter an appropriate header in the first empty column.
15. Input---on the row corresponding to the first data you want to check---the following:=if(B2='', 'EMPTY', 'NOT EMPTY')Press 'Enter.'
16. Copy the cell containing the formula. Select all the cells corresponding to the data you want to check. Paste the formula.
17. Select the 'Data' tab on the menu and select the 'Filter' button.
18. Click the filter arrow at the top of the column containing the formula. Select 'TRUE' to see the rows or columns with empty cells.

Read more ►

How to Protect Cells in Excel 2003

1. Open Excel on your computer and select the spreadsheet that you want to protect.
2. Click the 'Select All' icon in the upper-left corner of the spreadsheet. The icon is a gray rectangle located adjacent to the A1 cell.
3. Select 'Cells' from the format menu and choose the 'Protection' tab. Uncheck the box next to 'Locked.'
4. Choose the cells that you want to protect. To select multiple cells, hold down the 'Control' key while you click on each cell. To select a large block of cells, hold down the 'Shift' key while you click on the first and last cells in the block to be protected.
5. Go to the Tool menu and select 'Protection.' Click on 'Protect Sheet' and then 'OK.' If you choose to password-protect the spreadsheet, select a password in the 'Protect Sheet' dialogue box before clicking 'OK.'

Read more ►

Excel 2003 Macros Won't Run

1. Click on 'Tools,' then click on 'Macros,' then click on 'Security.' Check to see if the 'High' radio button is selected. If it is, this is likely preventing your macros from running. Click on the 'Medium' button for the security level and then click on 'OK.'
2. Save your worksheet if Step 1 didn't work, then close Excel completely. Restart Excel and reopen the worksheet.
3. Repeat Step 1 and Step 2. This should resolve the quirk preventing the macros from running.

Read more ►

How to Graph Complex Functions With Excel

1. Open a blank workbook in Microsoft Excel.
2. Enter 'x' in cell A1. Press 'Tab' to go to the next column over. Enter 'y' in cell B1.
3. Select cell A2. Enter the first value of x you want to use for the horizontal axis. For instance, to span the negative and positive axes, enter '-5,' and in each cell below, enter the next value in the series, up to 5. Enter '-4' in cell A3 and onward...-3, -2, -1, 0, 1, 2, 3, 4, 5.
4. Select all the x values in column A by highlighting A2 and dragging your cursor down to the last cell. You need to define the name of the values, so Excel knows that each value in column A equals a value of x. This will be used when you create a formula in the y column. Click the 'Formulas' tab. In the 'Defined Names' group, click 'Define Name.' Enter 'x' in the 'Name' box. Click 'OK.'
5. Select cell B2. Enter a complex function that you want to graph. If you are graphing a linear equation with the format y=mx b, enter '=m*x B' in cell B2. Tab over, and Excel will calculate the formula with the corresponding value of x.
6. Copy the formula from cell B2 to the other cells. Select cell B2. Click the 'Home' tab. Click 'Copy' in the 'Clipboard' group. Click and drag over the cells below B2 to select them. Click the arrow underneath the 'Paste' icon in the 'Clipboard'group. Choose 'Formulas.' The formula is added to each cell in the B column and contains each y-value in terms of x.
7. Highlight all the cells. Click the 'Insert' tab to create a graph for the function.
8. Click 'Scatter' in the 'Charts' group. Choose a subtype for the scatter chart. The chart immediately is displayed on your worksheet.
9. Click the chart to select it. The 'Chart Tools' appear on the Ribbon, which include the 'Design, Layout and Format' tabs. Browse through these tabs to make changes to the chart style, chart layout and the layout of individual chart elements, such as chart title, axes, legend and data labels.
10. Click a chart element directly on the worksheet to edit any titles you want to change.
11. Click the 'Microsoft Office Button,' and select 'Save as' to save the graph and data.

Read more ►

How to Edit a UDF File

1. Right-click on the UDF file.
2. Click on 'Open with.'
3. Select the 'Choose Default Program' option.
4. Select Microsoft Excel.
5. Click on 'Browse' only if Microsoft Excel is not on the list. Then, search for it and click on 'Open.'
6. Click on 'OK.' Your UDF file will open.
7. Click on 'File.'
8. Click on 'Save as.'
9. Select the file extension you wish to convert the UDF file to.
10. Click on 'Save.' Your UDF has been edited.

Read more ►