How to Extend the Trend Line in Excel

1. Open Microsoft Excel 2010.
2. Click the 'File' tab and select 'Open.' Select your file and click the 'Open' button.
3. Right-click the trend line in your spreadsheet file and select 'Format Trendline' from the menu.
4. Locate the 'Forecast' section under the 'Trendline Options.' Type a value in the 'Forward' field to extend the trend line forward, and type a value in the 'Backward' field to extend it backward.
5. Click the 'Close' button.
6. Click the 'Save' icon at the top of the window to save the changes to the file.

Read more ►

How to Repair an Excel 2003 File

1. Open Excel by clicking on the 'Start' button and then 'All Programs,' 'Microsoft Office' and 'Microsoft Excel 2003.' The program will launch on your screen.
2. Click on 'File,' 'Open' to display the 'Open' dialog box.
3. Browse to the location of the corrupted Excel file and then click on it once to select it.
4. Click on the down arrow next to the 'Open' button at the bottom of the window to view a list of additional options.
5. Click on 'Open and Repair.' A dialog box will display on your screen, prompting you to decide whether you want to attempt to repair the document or extract the data only.
6. Select 'Repair' to attempt to open and repair the document. The system will alert you if the repair fails. In this case, repeat the steps, choosing 'Extract Data' instead of 'Repair' when prompted. This process will extract the data and formulas from your Excel workbook without retaining any of the formatting.

Read more ►

How to Change Cursor Highlight Cell Colors in Windows Excel 2007

1. Open the MS Excel workbook that you want to edit.
2. Click on the 'downward-pointing arrow' next to 'Fill Color' under the 'Font' group. The 'Font' group is a group of font-editing buttons on the Office Ribbon (the main toolbar). When clicking on the 'downward-pointing arrow' button, a drop-down color menu is displayed.
3. Click any of the colors listed under 'Theme Colors' or click 'More Colors.' Click a color in the hexagonal color diagram and click 'OK.' The color that you select will be set as the new highlighting color when you click the 'Fill Color' button under the 'Font' group. Click any cell and then click the 'Fill Color' button to highlight the cell with the color you selected.
4. Click on a cell with a highlighting color you want to apply to other cells, double-click on 'Format Painter' under the 'Clipboard' group and then click any other cell to apply the same highlighting color to the cell. Continue clicking cells to paint them with the selected highlight color and press the 'Escape' key when you are finished highlighting.

Read more ►

How to Use Auto Complete in a Combo Box in Excel 2003

1. Launch the Microsoft Excel program on your PC computer and open the spreadsheet file in which you want to add a combo box.
2. Enter the values you want to use in the combo box anywhere on your spreadsheet. Use a separate cell for each value, but keep them together in a single column so that you can reference them later.
3. Go to the 'View' menu at the top of the window, expand the 'Toolbars' submenu and select 'Forms.' This will add several new elements to the main Excel toolbar, including the combo box.
4. Select the 'Combo Box' icon in the toolbar and then click on the area of your spreadsheet where you want to place the combo box item.
5. Hold down on the left mouse button and drag your pointer to the right to extend the size of the new combo box.
6. Right-click on the combo box you just created and choose the 'Format Control' option.
7. Fill in the 'Input Range' field with the location of the cells where you entered the desired autocomplete values in Step 2. Use a colon symbol to separate the first cell in the column from the last cell.
8. Press the 'OK' button to save the settings. As you begin to type in the combo box, Excel will autocomplete the text based on the values you have previously configured.

Read more ►

How to Create a Scatter Plot Graph

1. Enter column headers in row 1. Put the variable that you want on the X axis in cell A1, and the variable you want on the Y axis in cell B2. For example, if you are making a scatter plot of height and weight, enter 'Height' in A1 and 'Weight' in B1.
2. Enter data. In our example, enter the height and weight of each person in a row, with height in column A and weight in column B.
3. Click 'insert,' 'scatter,' and then the 'graph' on the upper left. This is a scatter plot, but you may wish to modify it.
4. For a more standard scatter plot layout, choose 'layout 1' in the design menu, then click on the X-axis title and type in 'Height.' Click on the Y-axis title and type in 'Weight.' Delete the little box on the right that says 'weight.' Then click on the title of the graph and enter something appropriate, such as 'Height and weight.'

Read more ►

How to Add Collapsing Plus Signs in Excel Columns

1. Open the Microsoft Excel 2010 worksheet that holds your data.
2. Click on the column letter above the first column that you want to include in your outline. This will select the entire column. Hold the Shift key, then click on the column letter above the last column you want included in your outline.
3. Select the 'Data' tab at the top of the Excel window. Locate the 'Outline' area of the Ribbon and click the 'Group' button. You will see a line appear above your columns with a minus sign on the end of it.
4. Click on a column letter within your grouped cells, then hold Shift and select another column letter to create a second level of the outline. Click the 'Group' button again and a new line and minus sign will appear under the first one. Continue creating levels until you have created your entire outline, or until you reach eight levels, which is the maximum that Excel will allow.
5. Click the minus signs to hide the levels of columns and all that will remain above the columns headers is a set of plus signs.

Read more ►

How to Open Excel 2007 in Excel 2003

1. Click the Windows 'Start' button, select 'All Programs' and then select 'Windows Update' if you use Windows Vista or Windows 7. If you use Windows XP, open a Web browser, navigate to the Microsoft Update website (see Resources) and click 'Express.'
2. Click 'Install' or 'Install Updates' to install all High-Priority or Required updates. Skip this step if your system is already up to date.
3. Open a Web browser window and navigate to the Microsoft Office Compatibility Pack download page on the Microsoft website (see Resources).
4. Click the 'Download' button, and save the installer program to your desktop when prompted by your browser.
5. Close all open programs.
6. Double-click the icon of the installer program you just downloaded. If you use Windows XP, click 'Run.' If you use Windows Vista or Windows 7, confirm your identity, or provide your administrator user name and password and click 'OK,' when prompted to confirm your choice.
7. Check the box labeled 'Click here to accept the Microsoft Software License Terms,' and then click 'Continue.'
8. Click 'OK' to install the Compatibility Pack. If you use Windows Vista or Windows 7, confirm your identity, or provide your administrator user name and password and click 'OK,' when prompted to confirm your choice.
9. Click 'OK' after installation completes to close the installer program.
10. Open Microsoft Excel 2003.
11. Click 'File' in the top menu bar, and select 'Open.' Locate your XLSX file in the resulting window, and then open it by double-clicking its icon.

Read more ►

How to Use a Drop Down Box in Excel 2003

1. Open Excel 2003 and highlight a group of cells. Select 'Data' on the menu bar and select 'Validation.' In the validation criteria tab, change the 'Allow drop down list' to 'List.' In the 'Source' list, type 'Apples, Bananas,Grapes.' Click 'OK.'
2. Click on one of the highlighted cells. Notice the drop down list.
3. Click the drop down list. Select one of the choices in the list.

Read more ►

How to Delete Print Lines in Excel 2007

1. Select the worksheet or worksheets you want to print without the lines. To select one sheet, click on the tab at the bottom of the workbook. Select two or more sheets that are next to each other by clicking the first sheet, holding down the 'Shift' key and then clicking the last sheet. Select two or more sheets that are not next to each other by clicking the first sheet, holding down the 'Control' key and then clicking the tabs of the other worksheets.
2. Click the 'Page Layout Tab' on the ribbon at the top of the window. In the 'Sheet Option' group, click the box in front of the 'Print' option to remove the checkmark. The lines do not print when this is selected. If the option appears dimmed, you might have a spreadsheet or graphic in one of the worksheets selected. You will need to deselect it before you can change this option.
3. Print the gridlines by clicking in the box again if you change your mind about printing the lines. This will cause the lines to print on the spreadsheet.

Read more ►

How to Delete Macros in Excel 2003

1. Open the Microsoft Excel 2003 application on your computer and the click on the workbook that contains the macro that you want to delete.
2. Click on the 'Tools' option from the top toolbar menu and then scroll over the 'Macro' option. Click on the 'Macros' option.
3. Locate the 'Macros in' list and then click on the 'This Workbook' option. A small dialog box will then appear and show the macro you have in the workbook.
4. Click on the name of the macro you want to delete in the 'Macro name' box. Hold down the 'CTRL' key on your keyboard to select more than one macro.
5. Click on the 'Delete' and your macro will be deleted from your workbook. Close out of the dialog box to return to your workbook.

Read more ►

How to Create Progress Bar in VBA

1. Open Microsoft Office Excel, then press 'Alt' and 'F11' to open the Visual Basic Editor. Right-click 'VBAProject,' then click 'UserForm' to insert a new Form. From the 'Toolbox' menu, click 'Label.' While holding your mouse button, drag on the Form to create a new label control.
2. Right-click the label and select 'Properties,' then change 'Height' to 42 and 'Width' to 12. Change the 'Top' to 12. Create nine more labels using the same process.
3. Click 'CommandButton' on the 'Toolbox' pane and add a new button to your Form. Right-click 'CommandButton' and click 'View Code' to create a new procedure.
4. Type the following to create a new variable and define its value:Dim cnt As Integercnt = 0
5. Type the following to hide all the labels when the Form starts:Me.Label1.Visible = FalseMe.Label2.Visible = FalseMe.Label3.Visible = FalseMe.Label4.Visible = FalseMe.Label5.Visible = FalseMe.Label6.Visible = FalseMe.Label7.Visible = FalseMe.Label8.Visible = FalseMe.Label9.Visible = FalseMe.Label10.Visible = False
6. Type the following to create a while loop and iterate 10 times while pausing the code for 5 seconds:Do While cnt
10Select Case cntCase Is = 1Me.Label1.Visible = TrueMe.Label1.BackColor = vbBlueCase Is = 2Me.Label2.Visible = TrueMe.Label2.BackColor = vbBlueCase Is = 3Me.Label3.Visible = TrueMe.Label3.BackColor = vbBlueCase Is = 4Me.Label4.Visible = TrueMe.Label4.BackColor = vbBlueCase Is = 5Me.Label5.Visible = TrueMe.Label5.BackColor = vbBlueCase Is = 6Me.Label6.Visible = TrueMe.Label6.BackColor = vbBlueCase Is = 7Me.Label7.Visible = TrueMe.Label7.BackColor = vbBlueCase Is = 8Me.Label8.Visible = TrueMe.Label8.BackColor = vbBlueCase Is = 9Me.Label9.Visible = TrueMe.Label9.BackColor = vbBlueCase Is = 10Me.Label10.Visible = TrueMe.Label10.BackColor = vbBlueEnd SelectMe.RepaintApplication.Wait Now TimeValue('00:00:05')cnt = cnt 1Loop
7. Click the 'Insert' menu then click 'Module' to add a new module. Copy and paste the code below to start your 'UserForm1.':Sub showProgressBar()UserForm1.ShowEnd SubPress 'F5' to run your program.

Read more ►

How to Make a Linear Log Graph in Excel

1. Open Excel 2010 and open your spreadsheet containing the logarithmic data set.
2. Locate an empty space in your spreadsheet to work on your chart. Click somewhere in this area. Click on the 'Insert' tab in the top menu. Click on 'Scatter' in the 'Charts' section and select 'Scatter with Straight Lines and Markers.' Putting your mouse over each icon will give you the title.
3. Right click in the blank chart area that appears in your spreadsheet and click 'Select Data.'
4. Click on the icon at the far right of the 'Chart data range' text box use your mouse to click-drag select the rows and columns containing your data for this chart. Click on the icon again at the far right of 'Chart data range' so that the 'OK' button is displayed. Click 'OK.'
5. Double click on whatever axis (x or y) is your logarithmic data range. For instance if it is the x axis, Double click on the numbers on the x-axis scale. Click on the 'Logarithmic scale' check box which is in the 'Axis Options' section. Click the 'Close' button. You will now see your selected axis changed in scale, for instance increments in base 10 are 1, 10, 100, 1000, etc.
6. Click the 'File' tab in the top menu and select 'Save As' to save this file to keep your work.

Read more ►

How to Find the Print Area on Excel in Vista

1. Log in to your user account in Windows Vista and launch Microsoft Excel.
2. Press 'Ctrl-O' to browse your computer and open an Excel file.
3. Click the 'Office' button that is located in the top left corner of the Excel window.
4. Select the menu 'Print' and 'Print Preview' to display the printable area on the first page. Use the 'Next page' button to show the rest of the document pages.
5. Click 'Close Print Preview' to quit the preview mode.
6. Select the Excel menu 'Page Layout' to change the print area.
7. Select the desired worksheet cells your left mouse button. Click the menu 'Print Area' and then 'Set Print Area.'

Read more ►

How to Link an Outlook Calendar to Excel

Exporting Outlook Calendar to Excel
1. Open Microsoft Outlook and wait for its main screen to fully load. Click on 'File' from the menu at the top of your page and select 'Import and Export.' Click on 'Export to a file' on the following page before selecting the 'Next' tab at the window's bottom.
2. Select 'Microsoft Excel' from the programs list and click on 'Next.' Click on the 'Calendar' folder from your options list on the following page before clicking on 'Next' at the bottom of your screen.
3. Type your chosen name for the calendar file into the text box. This will be the filename for your calendar in Excel. Click on 'Finish' at the bottom of the screen to start linking your calendar with Excel.
Importing Excel Files to Outlook Calendar
4. Customize Excel by examining your calendar section in Outlook. Customize the fields in Excel to match with all the information on Microsoft Outlook. For instance, when importing appointments, Outlook provides information on the name of the appointment, location, subject and time. Title the columns of your Excel spreadsheet to match the Outlook information.
5. Save the data after you complete your spreadsheet. Choose the rows and columns that contain the exact information you wish to import and include column headings. Type the name referring to your selection at the left side of your address bar, and press 'Enter.' Go to the process of saving the data. Exit Excel after saving.
6. Open Microsoft Outlook by double-clicking on its desktop icon. Import the information by going to the 'File' menu and selecting 'Import and Export.' Click on 'Import from Another Program or File' and select 'Next' before clicking on 'Microsoft Excel 97-2003.' Click 'Next' to start locating your file.
7. Click the 'Browse' button and locate the Excel worksheet that you saved in step 2. Select the spreadsheet and click 'Next.' This will show the available folders that you can import into Outlook.
8. Highlight your Calendar option and choose 'Next.' You will find a summary of what you selected reading 'Import [filename] into folder: calendar.' The [filename] represents the name of the spreadsheet that you made, such as 'meetings' or 'addresses.'

Read more ►

How to Make an Age

1. Type or paste in a spreadsheet the list of ages for males, with one row per age. For example, you might type '10,' '15,' '50' and '24' for the ages of four different people. In practice, however, your list should include at least 30 ages.
2. Write on paper a list of between five and 20 age ranges. For example, write '0 to 5' for the first age range that includes ages zero to five years old.
3. Type in the first cell to the right of the topmost age from Step 1, the maximum age of the first age range on your paper. For the example in the previous step, this age is '5.'
4. Use the previous step's instructions to enter the maximum age of the remaining ranges, below the previous step's cell.
5. Click and drag on the cell immediately to the right of those of the previous step. This action selects those cells.
6. Click the 'fx' symbol to the left of the large text box above the spreadsheet grid, then double-click the 'Frequency' item from the dialog box that appears.
7. Click the small square button for selecting cell ranges, located to the right of the upper text box on the following screen. Drag on the list of raw ages from Step 1.
8. Click the square button to the right of the lower text box, then use the previous step's instructions to select the Step 3 and 4 cells holding the age ranges.
9. Click 'OK' to insert the 'Frequency' function, then click in the formula bar above the spreadsheet grid. Press 'Control,' 'Shift' and 'Enter' simultaneously to fill the cells next to the age range cells with the 'Frequency' function. This action tells you how many males are in each age range.
10. Use Steps 1 through 9 to compute the frequency distribution for females. Enter the raw female data anywhere on the same spreadsheet as the raw male data. However, make sure that the column containing the frequency distribution for females is directly to the right of the male frequency distribution.
11. Drag across both male and female frequency distributions to select them, then click the 'Insert' menu heading. Click the 'Column' button in the 'Chart' panel, then click the top left chart type from the bar chart gallery that appears. Excel now creates the histogram based on your frequency distributions for males and females.

Read more ►