How to Create an Application in Word or Excel

Create an Application in Word
1.
Start Microsoft Word. In Word 2003, go to the 'File' menu and click 'New.' In Word 2007, click the 'Office Button' and click 'New.'
2.
Type 'Employment Application' in the 'Templates on Office Online' box and click the 'Search' button. Select 'Employment Application 2-pp Online Form' in the 'Search Results' list. Click the 'Download' button, and an application will open as a new Word document.
3.
Enter your company logo by selecting 'Your Logo Here.' Go to the 'Insert' menu in Word 2003, point to 'Picture' and click 'From File.' In Word 2007, go to the 'Insert' tab and click on 'Picture.' Find the logo on your computer and insert it. Type the name of your business over 'Company Name.'
4.
Change any of the template example fields by selecting them and typing over the text. To alter the properties of a form field, double-click the gray field area, and the 'Form Field Options' dialog box will open. Select an option from a drop-down menu, or click the 'Add Help Text' button for more options.
5.
Save the application when finished. Before allowing an applicant to fill in an application in Word, open the document and save it with a new name, such as the applicant's name or the date, so that the original will not be changed.
Create an Application in Excel
6.
Start Microsoft Excel. Open a new, blank workbook. Insert a company logo by going to the 'Insert' menu in Excel 2003. Point to 'Picture' and click 'From File.' In Excel 2007, go to the 'Insert' tab and click on 'Picture.' Find the logo on your computer and insert it on the left side of the page. Enter a text box on the right side and type the name of your business inside it.
7.
Type the desired questions into cells on the spreadsheet. Leave empty the adjoining cells for the applicants to type into.
8.
Create 'Yes' or 'No' drop-down lists from which applicants can select an answer. Go to the 'Data' tab in Excel 2007 or the 'Data' menu in Excel 2003 and select 'Data Validation.' Go to the 'Settings' tab of the Data Validation dialog box.
9.
Select 'List' in the 'Allow' drop-down list. In the 'Source' field, type 'Yes,No' (without quotes). Click 'OK' to apply the drop-down list.
10.
Enter other data into the 'Source' field of the Data Validation box to create custom lists. Type a comma between each list item. When applicants click in the cell, they will be presented with a list of options from which to choose. Save the application when complete.

Read more ►

How to Change Macro Security Settings on Windows Vista

Changing Macro Security in Word or Excel 2007
1. Click the circular Office logo in the upper-left corner of the Word or Excel window, then click the 'Word Options' or 'Excel Options' button at the bottom of the menu.
2. Click the 'Trust Center' link on the left side of the screen, then click the 'Trust Center Settings' button.
3. Click the 'Macro Settings' link on the left side of the window to access the macro settings for the Office 2007 program you are using. The menus for Word 2007 and Excel 2007 are the same. The default selection is 'Disable all macros with notification.' To run your own macros, select 'Enable all macros.'
4. Click 'OK' to save your changes.

Read more ►

How to Keep Track of Changes in an Excel Document

Tracking Changes
1. Start Microsoft Excel and open the file you want to change.
2. Open the Tools menu and select Track Changes, then Highlight Changes.
3. In the Highlight Changes dialog box, select 'Track changes while editing.'
4. Select 'Highlight changes on screen.'
5. Open the When menu and select All.
6. Open the Who menu and select Everyone.
7. Click OK.
8. Click OK. This will save your changes and your file/workbook.
9. Enter your new changes.
Accepting or Rejecting Changes
10. Open the Tools menu and Track Changes menu and select Accept and Reject Changes option.
11. In the Select Changes to Accept or Reject dialog box, select 'Not yet reviewed' to see all changes or 'Since date' to see changes after a certain day.
12. Click OK.
13. In the Accept or Reject Changes dialog box, review the edits to the spreadsheet.
14. Select the Reject or Accept button for each edit.

Read more ►

How to Unfreeze a Window Pane in Excel 2007

1. Select the 'View' tab from the top menu in Microsoft Excel 2007.
2. Go to the 'Window' menu ribbon. Select 'Freeze Panes.'
3. Choose 'Unfreeze Panes' from the pop-up menu to unfreeze your Excel spreadsheet.

Read more ►

How to Install Office 2000 on Excel 2007

Installing Office 2000 without Excel 2000
1. Insert your Office 2000 installation CD. A dialog box should open.
2. Provide details about your name and organization as well as the 25-digit CD key to continue the installation process, then select the 'Next' button. You will be redirected to another dialog box containing the Office 2000 End-User License Agreement; read it. If you agree, select the 'I accept' option, then click 'Next' to continue with the installation process.
3. Select 'Customize' as your installation type, then select all Office 2000 component programs except Excel 2000.
4. Click on the 'Install now' button to finalize the installation process.
Installing Excel 2007 without Office 2007 component programs
5. Insert your Office 2007 CD. A dialog box will open, asking you to enter your Office 2007 key.
6. Enter your Office 2007 key, then select 'Continue.' You will be redirected to another dialog box, where you will accept the Microsoft Software Terms; accept the terms to continue.You will see another dialog box asking you to choose your installation type.
7. Install only Excel 2007 by selecting the 'Customize' option. Click the 'Installation options' tab, then choose the 'Not available' option for all of the component programs except Excel 2007. Click the 'Install now' button.

Read more ►

How to Make a Cell Required in Excel 2007

Making Cells Required to Print Spreadsheet
1. Open Excel 2007. Check for the 'Developer' tab in the ribbon across the top of the screen. If you do not have the 'Developer' tab activated, click the round blue 'Microsoft Office' button in the top left corner. Click 'Excel Options' followed by 'Popular.' Check the box for 'Show Developer Tab in the Ribbon,' and then click 'OK.'
2. Click the 'Developer' tab, and then click the 'View Code' button under the 'Developer' menu. This will open Microsoft Visual Basic.
3. Copy and paste the following code into the blank window:[vba]Private Sub Workbook_BeforePrint(Cancel As Boolean)If Sheet1.Range('A1:B2').Value = '' ThenMsgBox 'Cannot print until required cells have been completed!'Cancel = TrueEnd IfEnd Sub[/vba]
4. Replace the 'Sheet1' and 'A1:B2' values within the code with the range of values you would like to require in your spreadsheet. For example, if you want to require the first 10 cells in column A of Sheet 2 of your spreadsheet, you would change the second line of the code to:If Sheet2.Range('A1:A10').Value = '' Then
5. Close Microsoft Visual Basic. Save your Excel file to make the code a permanent part of the file.
Making Cells Required to Save Spreadsheet
6. Open Excel 2007 and check to see if the 'Developer' tab is present in the ribbon across the top of the screen. If you don't see the 'Developer' tab, click the round blue 'Microsoft Office' button in the top left corner. Click 'Excel Options' followed by 'Popular.' Check the box for 'Show Developer Tab in the Ribbon,' and then click 'OK.'
7. Click the 'Developer' tab, and then click the 'View Code' button under the 'Developer' menu to launch Microsoft Visual Basic. Visual Basic allows you to view and organize any code you've added to a spreadsheet, as well as write or add new code.
8. Copy and paste the following code into the empty window within Microsoft Visual Basic:[vba]Private Sub Workbook_BeforeSave(Cancel As Boolean)If Sheet1.Range('A1:B2').Value = '' ThenMsgBox 'Cannot save until required cells have been completed!'Cancel = TrueEnd IfEnd Sub[/vba]
9. Customize the code by replacing the 'Sheet1' and 'A1:B2' values with the range of values you would like to require in your spreadsheet. For example, if you want to require the first 10 cells in column A of Sheet 2 of your spreadsheet, you would change the second line of the code to:If Sheet2.Range('A1:A10').Value = '' Then
10. Attempt to save the Excel sheet without filling in all of the required cells. If a message box pops up reading 'Cannot save until required cells have been completed!', your code is working correctly.

Read more ►

How to Build Pivot Tables in Excel 2007

1. Open Excel and open a spreadsheet on your computer that has data in at least 5 columns and 10 rows. Make sure this data has column headers.
2. Press 'Control' and 'A' to select all of the data in your spreadsheet. Click on the 'Insert' tab on the ribbon and select 'PivotTable.' Select 'PivotTable' again. Excel will open the Create PivotTable dialog box. In the section titled 'Choose the data that you want to analyze,' choose 'Select a Table or Range.' In the section titled 'Choose were you want the PivotTable report to be placed,' choose 'New Worksheet.' Click 'OK.' A new worksheet opens displaying an empty PivotTable.
3. Design your PivotTable by selecting a column header from the 'PivotTable Field List.' The column data will populate the PivotTable. Notice the field is dropped into the 'Row Labels' area of your PivotTable. You can move it around using the section titled 'Drag fields between areas below.' Add another field to the PivotTable by selecting it from the 'Pivot Table Field List.' Drag both fields to either the 'Column Labels' or 'Row Labels' and see how your PivotTable is impacted.
4. Add a field that includes a numerical value for these two column headers. Move this field to the 'Sum Values' field of your PivotTable. You should see data that is being summarized in a compact manner. You can display the summarized data as a count or sum value. If you want to change the type of value being displayed, click on the drop-down arrow next to the field in the 'Sum Values' field and select 'Value Field Settings.' Change the value to represent the type of summary you are looking for. Click 'OK.'

Read more ►

How to Use Page Orientation on Excel 2007

Selecting Page Orientation
1. Open Microsoft Excel 2007.
2. Click the 'Page layout tab.'
3. Click 'Page setup.'
4. Click 'Orientation' and click either 'Landscape' or 'Portrait.'

Read more ►

How to Merge Cells in a Shared Workbook

1. Navigate to the location of the shared workbook on your computer.
2. Double-click on the workbook to open it.
3. Click the top left cell that is going to be part of your cell merge, then drag the mouse pointer until all of the desired cells have been selected.
4. Right-click anywhere in the highlighted area of cells, then select the 'Format Cells' option.
5. Click the 'Alignment' tab, then check the box next to 'Merge cells.'
6. Click the gray 'OK' button to close the window.

Read more ►

How to Write Macros in Excel 2007

1. Make the 'Developer' tab of the ribbon visible. Click the 'Office Button' and select 'Excel Options.' Select 'Show Developer Tab in the Ribbon' in the 'Popular' category. Click 'OK.'
2. Enable macros. Go to the 'Developer' tab. Click 'Macro Security' in the 'Code' group. Select 'Enable All Macros' and click 'OK.'
3. Click 'Visual Basic' in the 'Code' group. The 'Microsoft Visual Basic for Applications' window opens. Go to the 'Insert' menu and select 'Module' to open a new module.
4. Type or paste the macro that you want to use in Excel 2007. Press the 'F5' key to run the macro and ensure that it works correctly.
5. Go to the 'File' menu and select 'Close and Return to Microsoft Excel' when you are finished.

Read more ►

How to Unlock an Excel Password

1. Download an Excel macro designed to unlock passwords.
2. Double-click 'allinternalpasswords.xls' to open the macro. The workbook itself is hidden and the macro displays a toolbar.
3. Click the 'File' menu and click 'Open ...' to open the workbook that you wish to unlock.
4. Click the button on the toolbar to unlock the password. The macro provides you with a password that will work in the locked workbook.
5. Enter the provided password in order to unlock the workbook.

Read more ►

How to Calculate Correlations Between Three Sets of Data Using Excel

1. Open your Excel file, click the 'File' tab, then click 'Options.'
2. Click 'Add-Ins' at the left side of the window.
3. Click the drop-down menu to the right of 'Manage,' click 'Excel Add-Ins,' then click 'Go.'
4. Check the box to the left of 'Analysis Toolpak,' then click 'OK.'
5. Click the 'Data' tab at the top of the window, then click 'Data Analysis' in the Data Analysis section of the ribbon at the top of the window.
6. Click 'Correlation' and 'OK.' This opens a new Correlation window.
7. Check the 'Columns' option if your data is sorted by columns, or check the 'Rows' option if your data is sorted by rows.
8. Hold down the 'Ctrl' key and use your mouse to highlight each set of data for which you want to calculate correlations.
9. Click the 'OK' button to calculate your correlation and have it displayed on a new worksheet in your workbook.

Read more ►

How to Remove Dashes From Social Security Numbers in Excel

1. Open the Excel worksheet containing the Social Security numbers or other data from which you want to remove the dashes. Select the cells containing the numbers. If you want to remove the dashes from the entire worksheet, click the 'Select All' button, which is the rectangle between 'A' and '1' in the upper left of the worksheet. To select an entire row or column, click on the number or letter pertaining to that row or column. To select several cells in the worksheet, press and hold the 'Ctrl' key while you click on each cell.
2. Click the 'Format' drop-down in the 'Cells' group of the 'Home' tab in Excel 2007 and select 'Format Cells.' In Excel 2003 or earlier, go to the 'Format' menu and click 'Cells.'
3. Go to the 'Number' tab of the 'Format Cells' dialog box. Select 'Number' in the 'Category' box. Change 'Decimal Places' to '0' and click 'OK.'
4. Open the 'Find and Replace' dialog while the cells are still selected. Go to the 'Find Select' drop-down on the 'Home' tab in Excel 2007 and select 'Replace.' In Excel 2003 or earlier, go to the 'Edit' menu and click on 'Replace.' You can also use the keyboard shortcut 'Ctrl H' to open 'Find and Replace.'
5. Type a dash into the 'Find What' box. Leave the 'Replace With' box empty. Click the 'Replace All' button. Excel will find all of the dashes in the selected cells and remove them.

Read more ►

How to Create a Text Box in Excel

1. Open Microsoft Excel 2007 and or start a new blank workbook or open an existing workbook that you want to create a text box in.
2. Select the 'Insert' tab from the top of the Excel 2007 screen to display the Insert ribbon. This ribbon includes all of the objects you can insert into an Excel workbook.
3. Locate the 'Text' section of the Insert ribbon. It is the section at the end or the right of the Insert ribbon.
4. Choose the 'Text Box' button from the Text section of the Insert ribbon. The button will be highlighted once it's clicked.
5. Click in the area in the worksheet where you want to begin drawing the text box. Hold down your left mouse button and drag outwards from that point to create the text box.
6. Release the mouse button once you are happy with the size and shape of the text box. The text box looks like white empty space with a border and sizing handles surrounding it.
7. Click inside the text box to insert the cursor, then type text or add objects inside it.

Read more ►

Access Denied When Saving From the Excel 2007 Format to Excel 2003

1. Click the Windows 'Start' button and enter the folder location of the Excel file in the search text box. For instance, if the file is located in 'C:\myfolder,' enter this value into the text box and press 'Enter.' This opens an Explorer window that displays the folder contents.
2. Right-click the folder that contains your Excel spreadsheet and select 'Properties.' A window opens that displays several options for your folder.
3. Remove the check mark in the box labeled 'Read-Only.' This allows you to save your converted files to the folder and stops errors such as 'Access Denied.'

Read more ►

How to Change X Axis Values in Excel 2007

1. Click on the x-axis to select it. Click somewhere beneath the bottom horizontal line of the chart to ensure that you select the axis rather than the chart area.
2. Right-click within the selected area and choose 'Format Axis' from the drop-down menu that appears.
3. Click the circle for 'Fixed' next to 'Minimum:' under 'Axis Options' and type the smallest number you want displayed on the x-axis in the box to the right. Do the same for 'Maximum:' but type the largest number you want displayed on the x-axis.
4. Select the 'Fixed' circle next to 'Major unit:' and enter a number in the box to the right if you want to change what numbers are displayed on the x-axis. For example, type '0.1' into the box if you want to display every tenth.
5. Click the 'Close' button at the bottom of the 'Format Axis' box to accept your changes.

Read more ►

How to Make a Graph With a Z

1. Open Microsoft Excel and enter your data into the vertical columns. Highlight your data. Click the 'Insert' tab, then click the 'Chart' button under it.
2. Choose the graph you prefer, making sure that it is in 3-D. Click 'Press and Hold to View Sample' in order to preview the chart you selected before applying it. Click 'Next' once you have found the chart that works best for your purposes.
3. Enter your data range by highlighting the appropriate columns of data and then clicking the button beside the field your selected information appears in. Click the 'Series' tab to edit or modify your data series and their names.
4. Click 'Next,' then click the 'Titles' tab of the next window. Type in a title for your graph and titles for the x, y, and z axes.
5. Click the 'Axes' tab for options to make your axes' information visible or invisible. Click the 'Gridlines' tab to make gridlines visible or invisible. Click the 'Legend' tab to make your legends visible or invisible. You can also use this tab to determine legend placement.
6. Click 'Data Labels' to choose which pieces of series information and titles you want to show out of all you have entered.
7. Click 'Data Table' to view all of the series data you have entered in your graph in table form.
8. Click 'Next.' Select your chart location and placement in the final window that pops up. Click 'Finish.'

Read more ►

How to Use Excel 2010

1. Open a new Excel 2010 spreadsheet by double-clicking on the Excel icon on your desktop. Look at the spreadsheet and its layout. New files have three worksheets. Move between the three spreadsheets by clicking 'Sheet 1,' 'Sheet 2' or 'Sheet 3' in the lower left part of your screen.
2. Examine the tabs along the top -- 'File', 'Home,' 'Insert,' 'Page Layout,' 'Formulas,' 'Data,' 'Review' and 'View.' Click on each one to see its options. Most basic Excel 2010 commands are found on the 'Home' tab.
3. Click the cell in the upper left part of the spreadsheet marked A1, found in column A, row 1. Type the name of your first variable in cell A1 and additional variable names in B1, C1 and so forth.
4. Create your data table by entering data beneath each variable name in the cells A2, A3 and so forth. Use as many cells as necessary to fit your data set. Scroll down using the arrows on the right hand of your screen.
5. Change the formatting of the cells using the commands found on the 'Home' tab. Click on a cell or group of cells and change their font, color, size or appearance.
6. Move cells by highlighting them and hovering over the thick black border until you see a four-headed arrow. Click and drag the cells to your desired location. Copy cells by highlighting them and right-clicking on them. Click 'Copy,' click to where you want to move them, right-click again and click 'Paste.'
7. Perform basic functions by going to the 'Formulas' tab and clicking 'Insert Function.' Search for the name of the function you want to perform, such as adding, averaging or finding the maximum. Input a range of cells to tell the spreadsheet what calculation to perform. Press the 'Enter' key to view the result of the formula.
8. Save your worksheet by clicking the green 'File' tab. Select 'Save As' to designate a destination folder and unique name for your Excel 2010 spreadsheet. Click 'Print' to print a copy of your spreadsheet.
9. Access the Excel 2010 help files by clicking the blue question button in the top right corner of the screen. Type your question into the search box to find an answer from Microsoft.

Read more ►

How to Remove Hyperlinks From Excel 2007

1. Double-click your Excel file to open the file in Microsoft Excel 2007.
2. Select a blank cell in your spreadsheet, then type the number '1' into the cell.
3. Right-click on the cell and select 'Copy.'
4. Hold down the 'Ctrl' key on your keyboard as you select each cell containing a hyperlink that you want to remove.
5. Click the 'Home' tab at the top of the Excel 2007 window.
6. Click the arrow below 'Paste' in the 'Clipboard' section, then click 'Paste Special.'
7. Click 'Multiply' in the 'Operation' section, then click 'OK.' This removes the actual hyperlink from the cell, but it leaves your data underlined.
8. Click 'Cell Styles' in the 'Styles' section at the top of the window.
9. Click 'Normal' under the 'Good, Bad and Neutral' section to remove the underlines.

Read more ►

How to Construct a Histogram Using Excel 2007

1.
Capture the stock data. Go to Yahoo Finance and type 'SBUX' in the symbol box. Click on the link that says 'historical prices'. Go to the bottom of the page and click 'download to spreadsheet'. The info will download automatically and then open in an Excel spreadsheet.
2.
Get the Max and Min values of the 'Adj Close' column. Go to the editing option of the Home menu. In the drop-down box of mathematical functions select 'Max.' Type 'G2:G501' and press 'Enter.' Repeat the same with 'Min.' The Max value should be 28.29 and the Min value should be 7.17.
3.
Create the bin values. Round 28.29 to 30 and 7.17 down to 5. Start at 5 and add increments of 1 until you get to 30. Type those numbers in the column next to 'Adj Close' and call it 'Bin values.'
4.
Open the histogram dialog box. Under the 'Data' tab select 'Data Analysis'. In the dialog box select 'Histogram' and press 'OK.' The Histogram dialog box will then open.
5.
Input the histogram setting. In the 'Input Range' field type '$G$2:$G$501' and in the 'Bin Range' field type '$H$2:$H$25'. These are the cell ranges of the data and bin values respectively. In 'Output Options' select 'New Worksheet Ply' and name the worksheet 'Histogram.' Then select chart output and press 'OK.'
6.
Survey the Histogram. Observe the distributions of the lines. If they bundled in the middle the histogram is said to be 'evenly distributed' or 'bi modal.' This is usually the case with test or survey data. As is sometimes expected with erratic stock data the histogram in this article turned out to be 'saw-toothed.' This kind of distribution might indicate that the stock under inspection has been quite volatile over the past 500 days.

Read more ►

How to Make Sums in Excel 2010

1. Open the Microsoft Excel 2010 spreadsheet that contains the numbers you want to add together.
2. Click on an empty cell in the spreadsheet, where you want the summation to appear. Type the equals sign into the cell to start a formula.
3. Enter 'SUM(' if you want to add together a number of cells. Type in the column letter and row number of the first cell that you want to include. Place a colon after this cell reference if you are adding together a continuous range of cells, then type in the last cell in the range. Place a comma after the first reference if the selected cells are not continuous on the spreadsheet, and enter in the second cell reference. Continue adding commas and cell references until you have entered all of the cells you want to add together. Enter a close parenthesis and press 'Enter.' For example, if you want to add the cells from 'A1' to 'B10,' enter: '=SUM(A1:B10).' If you want to add just 'A1' and 'B10,' enter '=SUM(A1,B10).' If you want to add 'A1' through 'A10,' but include 'B10' as well, enter '=SUM(A1:A10,B10).'
4. Enter 'SUMIF(' if you only want to add together some of the cells, based on the values of adjacent cells. Type in the first cell in the range that you want to check for a given criteria, then place a colon followed by the last cell in the range of cells. Type in a comma, then enter the value that you want to check for in the range of cells. This can be a simple number, a piece of text enclosed in quotes, or a cell reference. Type in another comma, then type in the range of cells that you want to add together if the cells qualify given your condition. So if you entered '2001' as your criteria value, Excel will look through the first range of cells and whenever it finds '2001,' it would add together the corresponding cell in the second range of cells. Type in a close parenthesis and press 'Enter' to complete the formula. For example, if you want to check cells 'A1' through 'A10' for the value '23,' and then add together the corresponding cells in the range of 'B1' through 'B10,' enter: '=SUMIF(A1:A10,23,B1:B10).'
5. Type 'SUMIFS(' into the cell if you want to sum together a range of cells based on multiple criteria. SUMIFS is similar to SUMIF, except the arguments are arranged in a slightly different order. Type the range of cells that you want to sum together into the formula, then enter a comma. Type the range of cells to check for a criteria, followed by a comma and the criteria itself. Enter another comma and continue to add criteria ranges and criteria until you have entered all data. Place a close parenthesis at the end of the formula and press 'Enter.' To add together cells 'A1' through 'A10' whenever '23' appears in column 'B,' and '25' appears in column 'C,' enter: '=SUMIFS(A1:A10,B1:B10,23,C1:C10,25).'

Read more ►

How to Link Data in Other Excel 2007 Workbooks

1. Open the Excel 2007 workbook that contains the data for which you want to link to other workbooks.
2. Double-click in the cell on the Excel workbook the contents of which you want to link to other workbooks. This will select all the contents in that cell.
3. Right-click in the selected cell and then click 'Copy.'
4. Open the other Excel 2007 workbook to which you want to link the data you selected from the workbook that you opened in Step 1.
5. Right-click in an empty cell on the workbook, click the 'Home' tab, click the downward pointing arrow below 'Paste' and then click 'Paste Special.'
6. Click the 'Paste Link' button on the Paste Special dialog box that opens and then click 'OK.' Repeat steps 3 to 6 in other workbooks to which you want to link the selected data.

Read more ►

How to Use the Cursor to Highlight Rows in Excel 2003

1. Move the cursor to the row number on the left side of your spreadsheet and click the number to highlight the row.
2. Move the cursor to another row number, hold down the 'Shift' key, and click the row number to highlight all the rows between the first highlighted row and the new row. For example, highlight row 12, move the cursor to row 20 and shift-click the row number to highlight all rows between 12 and 20.
3. Move the cursor to another row, hold down the 'Ctrl' key and click the row number to highlight only individual rows. For example. highlight row 12, move the cursor to row 20 and ctrl-click the row number to highlight rows 12 and 20.

Read more ►

How to Create a Drop Down List in Microsoft Excel

1. Type the list items into cells in a column of the current worksheet or another worksheet. Name the list if you enter it into a different worksheet. Select the list and click inside the 'Name' box at the top left corner of the worksheet next to the 'Formula Bar.' Type a name for the list and press 'Enter.'
2. Click on the cell in which you want to create a drop-down list. To enter the list into several cells, press and hold the 'Ctrl' key and click on each cell in which you want to use the list.
3. Go to the 'Data' menu in Excel 2003. Click 'Validation' and go to the 'Settings' tab of the 'Data Validation' dialog box. Go to the 'Data' tab in Excel 2007. Click 'Data Validation' and select 'Data Validation' from the menu. Go to the 'Settings' tab of the 'Data Validation' dialog box.
4. Select 'List' in the 'Allow' box. Enter an equal sign followed by the cell range containing your list into the 'Source' box if the list is on the same worksheet. Enter an equal sign followed by the range name into the 'Source' box if you created the list on another sheet. For example, if the range name is 'Fruits,' type '=Fruits' into the 'Source' box.
5. Clear the 'Ignore Blank' check box if you want to require users to select a list item rather than leave the cell blank. Go to the 'Input Message' tab if you want to display a message when the cell is selected. Type your message into the 'Input Message' box. Click 'OK' to create the drop-down list in the selected cell or cells.

Read more ►

How to Count All Rows With a Blank Cell in Excel 2007

1. Type '=COUNTBLANK(' in an empty cell.
2. Highlight the column of data you want to calculate the number of empty cells.
3. Press 'Enter.'

Read more ►

How to Create a Report in Microsoft Excel 2007

1. Complete the data and calculations in your worksheet. Even if your data and calculations span multiple worksheets, you can pull the data together into one report.
2. Roughly lay out how you want the report to look, including what you want in headers and footers, what text you want to be emphasized and what kind of graphical elements you want to include.
3. From the Insert tab on the Office Fluent Ribbon, click 'Header Footer' in the Text group to design the headers and footers, which are the text that displays on every page of the report. This opens the Header Footer Tools ribbon, where you can add page numbers, variables, date and time stamp, and pictures.
4. From the Insert tab, add visual interest to your report by inserting your own pictures, Microsoft clip art or SmartArt. You can also insert shapes, freehand drawings and text boxes. Using these tools, which are similar to the drawing tools in other Microsoft applications, you can do things such as add a stylized title to your report, include a pertinent graphic or illustration, or represent some aspect of your worksheet in a way other than a traditional graph.
5. From the Home tab, format the text and cells of your worksheet using features such as cell shading, cell borders, text alignment and fonts.
6. From the Page Layout tab, adjust printing aspects of your report, including the size of page margins, which rows or columns to repeat on subsequent pages and where page breaks occur. If you have more data on a given worksheet than you want to print on the report, use the Print Area command to explicitly identify the area of the worksheet to print.
7. From the Microsoft Office Button (the round, muticolored button in the upper-left corner of the Excel window), select Print and then Print Preview.
8. Iterate through steps 3 through 6, adjusting graphics, layout and formatting until your report is printing appropriately.

Read more ►

How to Calculate Sample Variance Using Excel

1. Add the numbers in the first column of your Excel 2007 document. For example, add the numbers 100, 200, 300, 400, 500 and 600 in A2, A3, A4, A5, A6 and A7.
2. For this example, click on the 'A9' cell. This is the cell where you will calculate the variance. When you calculate another variance, choose any cell at the bottom of the list of numbers you are using.
3. Click on the 'Formulas' tab while you are in the 'A9' cell. Click on 'Statistical' on the drop-down menu.
4. Click 'Insert Function' on the top left-hand side of the Excel spreadsheet. The 'Insert Function' window will pop open.
5. Click on the drop-down menu of 'Or select a category.'
6. Scroll down the 'Select a function' window. Choose 'VAR,' which is the function of variance based on the sample.
7. Click 'OK.' The 'Functions Arguments' window will pop open. Ensure that on 'Number 1' cell, A2:A7 is populated. If A2:A7 is not populated, enter A2:A7 manually. Click 'OK.'
8. The variance has been successfully calculated. In this example, the calculated value of the variance is 35,000.

Read more ►

How to Add a Subtotal to a Pivot Table

1. Select your items, row, or column that you would like to subtotal in your pivot table report.
2. Click 'Field Settings' in the 'Active Field' group on the 'Options' tab.
3. Click 'Automatic' under 'Subtotals' to subtotal the outer row or column label.
4. Select 'Custom' under 'Subtotals' to choose a function for an inner row or column label.

Read more ►

How to Adjust Chart Fonts in Excel

1. Start Microsoft Excel 2007 and open a spreadsheet from your files that contains a chart in which you want to change the formatting of the font in that chart.
2. Right-click on the text in the chart that you want to change the font or other formatting feature. The 'Mini Toolbar' will appear over the shortcut menu that appears. The 'Mini Toolbar' contains everything you need to adjust the chart font.
3. Use the 'Font Type' drop-down list to choose a new font for the selected text. The 'Font Size' drop-down list allows you to change the size of the font that you have selected. The 'Increase Font' and 'Decrease Font' buttons allow you to quickly adjust the size.
4. Use the styles buttons to make the selected text bold or italic by choosing the 'B' button for bold or the 'I' button for italic.
5. Align the selected text by choosing the 'Right Align,' 'Center Align' or 'Left Align' buttons.
6. Change the color of the selected text by picking a color from the 'Text Color' drop-down box. Click 'More Colors' at the bottom of the drop-down box to display the Color Picker where you can create a custom color for the selected text.

Read more ►

How to Add a Counter in Microsoft Excel

1. Log on to your computer and open Microsoft Excel. Create a new spreadsheet.
2. Label the columns in your spreadsheet by giving them descriptive titles. For instance, you could create a 'Description' column, a 'Price' column, a 'Quantity' column and a 'Total Cost' column for a spreadsheet used to track orders.
3. Add a column and give it the title 'Count.' Go down to the bottom of the spreadsheet and type '=COUNT(firstrow:lastrow).' For instance, if the first cell in your spreadsheet that contains data is B2 and the last cell containing data is B50, your formula would read '=COUNT(B2:B50).'

Read more ►

How To Enable Excel Macros

1. Launch Microsoft Office Excel, click the 'File' tab and click 'Options' to open the Excel Options Window.
2. Click 'Trust Center' to open the Trust Center Window from the left pane of the Window.
3. Click 'Macro Settings' and choose the option that says 'Enable all macros (not recommended, potentially dangerous code can run).' Click 'OK' and click 'OK' again to close the Windows.
4. Exit Excel and restart it to enable all macros.

Read more ►

How to Select Multiple Non

1. Select the first range of cells by holding down the 'Ctrl' key, selecting the fist cell of interest with the left mouse button, and mousing over the range. When you have finished highlighting the range, release the mouse button but keep the 'Ctrl' key depressed.
2. Move the cursor to the next range of cells you would like to highlight.
3. Press the left mouse key to highlight the cell, then (keeping the left mouse button down) highlight the next area you would like to select. When finished highlighting, release the left mouse button.
4. Repeat Step 3 for as many ranges as you would like to select.

Read more ►

How to Convert XPS to Excel 2003

1. Download a preferred converter software. Websites such as Free Downloads Center or File Buzz have XPS-to-Excel 2003 converter software available for downloading. Simply click on the preferred software and select 'Run' when prompted. Install the software when the download is complete.
2. Open Excel 2003. Select 'File' and 'Open.' Browse through the files to find the XPS file. Select the file and click 'OK.' The software will convert the XPS file into a format that Excel 2003 can read.
3. Select 'File' and then 'Save As.' Create a preferred name and change the file extension of .xps to the Excel extension instead. Click 'Save.'
4. Close the file and reopen it to check that it saved properly. Close Excel 2003 when completed.

Read more ►

How to Un

1. Open the spreadsheet you wish to modify. Hold down the 'Ctrl' key, and tap the 'A' key twice. This should select all of the cells in the spreadsheet. Press 'Ctrl C' to copy the cells to the clipboard.
2. Click on the Microsoft Office logo at the top-left corner of the Excel screen and click 'New'. Click the cell labeled A1 to select it, then press 'Ctrl V' to copy the cells into the worksheet.
3. Press 'Ctrl S' to bring up the 'Save As' dialog box. Click the 'Tools' button, and select 'General Options'. Make sure the password box is empty. Delete the contents of the box if necessary. Click 'Ok' to close the options screen, then type in a new file name and click the 'Save' button.
4. Open the new spreadsheet file to confirm all of the data is present. Right-click on the old spreadsheet file and select 'Delete'.

Read more ►

How to Create Macro Buttons in Excel 2007

1. Open an Excel workbook that contains a macro.
2. Click the arrow to the right of the Quick Access Toolbar to reveal a drop-down menu; from that menu choose 'More Commands....'
3. Click the left-hand drop-down menu in the resulting window. Choose 'Macros.'
4. Double-click a macro in the resulting list to move it into the 'Customize Quick Access Toolbar' list.
5. Click the 'Modify' button below the list of Quick Access Toolbar buttons.
6. Choose a button image in the resulting window, and type a new display name for the button, if you want. The button name appears in a tooltip when you hover the mouse cursor over the button.
7. Click 'OK' to close the Modify Button window, then 'OK' to close the Excel Options window and return to the main Excel window, where your macro button appears on the Quick Access Toolbar.

Read more ►

How to Make a Chart on Excel With Coordinates

1. Open a new Microsoft Excel 2010 spreadsheet.
2. Click on cell 'A1' and type in the header for the first half of your set of coordinates. This header will not appear on the spreadsheet, but may be of use for referencing purposes when you are entering your data. Click on cell 'B1' and type in the header for the second half of your set of coordinates. This header will wind up as the title for your chart, and will be displayed in the chart's legend as well.
3. Select cell 'A2' and enter the first part of your first set of coordinates. This part of your coordinates will be plotted on the horizontal axis. Select cell 'B2' and end the second part of that set of coordinates. This part of the coordinates will be plotted on the vertical axis. Continue to enter in sets of coordinates in the first two columns until you have added all your data to the spreadsheet.
4. Click on cell 'B1' and select the 'Insert' tab at the top of the screen. Click the 'Scatter' button, located in the Charts area of the ribbon. Choose any of the five different XY Scatter charts that appear in the pop-up menu. The different charts will all plot the same data, but will allow you to choose to add curvy lines, straight lines and data markers. Once you click on your desired chart type, the chart will appear on your spreadsheet.

Read more ►

How to Spell Check on Excel 2007

1. Launch Excel 2007 and open the file you want to spell-check.
2. Click the 'Review' tab at the top of the screen.
3. Click the 'Spelling' button in the 'Proofing' section on the ribbon at the top of the screen. The 'Spelling' button is represented by the letters 'abc.'
4. Click one of the options in the 'Spelling' window when Excel encounters a potential spelling mistake. You can choose 'Ignore' if the word is spelled correctly or you can select the correctly spelled word under 'Suggestions,' then click 'Change' to fix the misspelled word.
5. Click 'OK' after all spelling mistakes have been corrected.

Read more ►

How to Add Gridlines to an Excel Chart

1. Start Microsoft Excel 2007 and open a workbook from your files that contains a chart to which you would like to add gridlines.
2. Click the chart you want to add gridlines to so it is selected. You can tell the chart is selected because it will have a light blue border surrounding it.
3. Select the 'Layout' tab at the top of the Excel 2007 screen to display the settings in the 'Layout' ribbon. Find the 'Axes' group in the 'Layout' ribbon.
4. Choose the 'Gridlines' button in the 'Axes' group of the 'Layout' ribbon and point to 'Primary Horizontal Gridlines' to display the horizontal gridline options.
5. Use 'Major Gridlines' to display gridlines only at major units, 'Minor Gridlines' to display them at minor units or 'Major Minor Gridlines' to display the gridlines at both the major and minor unit markings.
6. Opt for 'Primary Vertical Gridlines' from the 'Gridlines' button to choose to display either 'Major Gridlines,' 'Minor Gridlines' or 'Major Minor Gridlines' at the vertical units in the chart.
7. Watch as the gridlines are displayed on the selected chart as you have indicated.

Read more ►

How to Use Command Line Parameters in Microsoft Excel

1. Open a command prompt by clicking 'Start,' choosing 'Run,' entering 'cmd' and clicking 'OK.'
2. Type 'excel' on the command prompt. Enter a space. Do not press Enter yet.
3. Type any command line switches you'd like to use, separating them with spaces.
'/r fileName.xls' will open fileName.xls in read-only mode.
'/t fileName.xls' will create a new document, using fileName.xls as a template.
'/s' will cause Excel to start in 'safe mode,' which prevents any start-up scripts from loading.You can see the full list of commands at the Microsoft Office page devoted to the topic.
4. Press enter. This will cause Excel to load. After you are done using Excel, you can close your command prompt window.

Read more ►

How to Upgrade Excel 2003 to 2007

1. Insert the Microsoft Office 2007 CD into your computer's disc drive. The automatic setup will begin.
2. Type the product key into the text box. The product key is a 25-character key and is usually located on the back of the CD jacket.
3. Click on the 'I accept the terms of this agreement' check box and then click on the 'Continue' button.
4. Click on 'Upgrade,' which will remove Excel 2003 and replace it with Excel 2007. Wait for the installation to complete; it will take 15 to 30 minutes.
5. Click on the 'Close' button to complete the installation of Excel 2007.

Read more ►

How to Change a Reference to an Absolute in Excel 2007

1. Place a dollar sign in front of the column delimiter if you want to fix it, and in front of the row delimiter if you want to fix it.For example, you can change =VLOOKUP(A1,K1:P20,4) to =VLOOKUP(A1, $K$1:$P$20, 4) so that the reference to the table's location in K1:P20 won't change if you copy and paste or autofill this formula into empty cells elsewhere.
2. Mix the dollar sign use in order to fill a table. For example, if column headings are in B1 through Y1 and row headings are in A2 through A80, and the cells of the table depend on the values in the headings, then you can enter one cell the right way using mixed absolute references and drag to fill the entire table without the cells incorrectly referencing headings below row 1 or right of column A. For example, enter in B2 the formula =B$1$A2. You'll be able to drag this to fill the entire table because the formulas will always be pointing to the heading row (row 1) and heading column (column A).
3. Use shortcut keys to toggle through the dollar-sign permutations. Specifically, highlight the cell reference that you want to change in the formula bar (the long thin field at the top of the screen). Press the F4 function key to toggle through the different possible placements of $. (This feature doesn't work in some versions of Excel, such as Excel 2004, though it works in 2007.)

Read more ►

How to Import Access Query Into Excel

1. Open Access and create the following table of sample data, which has field names in the top row. Click 'Create>Table' to create the table.game,saledate,totalsale
quake,12/1/2009,$6.01
quake,12/3/2009,$7.98
guitar hero,12/5/2009,$4.98
guitar hero,12/6/2009,$5.98Save the table (by pressing 'control-s') with the name 'games.'
2. Create a new query for the games table by clicking 'Create>Query Design,' right-clicking on the 'Query1' text in the query's tab, and clicking 'SQL View.'Enter the following statement in the SQL code window:SELECT games.* INTO myqueryres
FROM games
WHERE (((games.game) Like '*tar*'));Save the query (by pressnig 'control-s') as 'myquery.'
3. Run the query by double-clicking 'myquery' in the navigation pane, then close Access and open Microsoft Excel.
4. Click 'Data' and choose 'From Access.' In the 'Select Data Source' dialog box, open the Access database you created the games table in. Select the table 'myqueryres' from the 'Select table' dialog box, then press 'OK' on the 'Import Data' dialog box. Notice that Excel has imported the query.
5. Close Excel, remembering the filename when you save the file. Re-open Access. Revise 'myquery' in 'SQL View' to read as follows:SELECT games.* INTO myqueryres
FROM games
WHERE (((games.game) Like '*ua*'));
6. Save and re-run the query, then close Access and re-open the Excel file you created the table link in. Select 'Data' and choose 'Connections,' then press the 'Refresh' button in the 'Workbook Connections' dialog box. Close the dialog box and notice that the query results have changed.
7. (For users of Excel 2003) Complete steps 1 and 2. Run 'myquery,' then press 'alt' 'F11' to enter the Visual Basic integrated development environment (IDE). Press 'Insert' and select 'Module,' then paste the following program code into the new code window:Public Sub sendToExcel()'''''''''''''''''''''''''
Set curdb = CurrentDb
Set recs = curdb.OpenRecordset('myqueryres')
st = 'game' ', ' 'saledate' ', ' 'totalsale' vbCrSet xlapp = CreateObject('Excel.Application')
xlapp.Workbooks.Add
r = 1: c = 1
xlapp.ActiveSheet.Cells(r, c) = st
r = 2
st = ''
Do While Not recs.EOF
st = st recs![game] ', ' _
recs![saledate] ', ' recs![totalsale] vbCr
xlapp.ActiveSheet.Cells(r, c) = st
recs.MoveNext
r = r 1
st = ''
Loop
recs.Close: curdb.Close
xlapp.ActiveWorkbook.SaveAs ('c:\accessquery.xls')
xlapp.QuitEnd Sub
8. Click 'Tools' and choose 'References,' then check the check box labeled 'Microsoft Excel Objects' so your macro can recognize the functions that Excel makes available.
9. Run your macro by placing the cursor anywhere in the sendToExcel subroutine and pressing 'F5.'
10. Double-click the file 'c:\accessquery.xls' from Windows Explorer, and notice the query's results in Microsoft Excel when it opens.

Read more ►

How to Create a Simple Budget in Excel 2003

1. Gather your budget information. Have your monthly statements and expenditure amounts ready.
2. Double-click on the 'Excel' icon on your computer. If you can't find it on the desktop, open the program using the 'Start' menu on your toolbar.
3. Decide whether you want to make your budget from scratch or use a template. Using a template is the easiest method. If you're going to use a template, skip to Step 5.
4. Make your budget from scratch by setting up your worksheet any way you like. Start by naming the rows and columns and then add figures for various incomes and expenditures.
5. Click 'New' on the task bar on the top of the page to display a box with various different templates for projects in Excel. Select the simple budget template option. Follow the instructions and fill in the cells with your expenses and income.
6. Save your budget by pressing the 'Ctrl' and 'S' keys at the same time. You can also print it out by pressing 'Ctrl' and 'P.'
7. Update and change your budget as needed. Your Excel 2003 budget is fully customizable and can be changed based on your needs. You can even make graphs and charts from your data for visual assistance.

Read more ►

How to Match Destination Formatting in Word

1. Launch Microsoft Word and open your document. Highlight and copy or cut the source material that you want to paste. Click within your Word document where you want to paste the copied text. Right-click or depress the 'Control' button simultaneously with the letter 'v.' Recent versions of Microsoft Word will show a little clipboard icon titled 'Paste Options.' Click on the 'Paste Options' button and a drop-down box will appear. If this is the only material that you intend to copy and paste, select the radio-button to the left of 'Match Destination Formatting' and your content will paste, matching what is already in your document. Click 'Edit' then 'Paste Special' if you are using earlier versions of Word. Alternatively, you can select the 'Tool' menu then click 'Options,' 'Edit' and then 'Show Paste Options.'
2. Change the default so that the paste font, size and color will automatically match every time. Select the 'Set Default Paste' option to change the default setting in the drop-down menu. A new window called 'Word Options' will appear. Scroll down the page to 'Cut, Copy, and Paste'. Drop-down boxes appear to the right of the first five options. The option 'Match Destination Formatting' appears in the first four boxes. Select your desired preferences. Click 'OK' at the bottom right.
3. Click the Microsoft Office Button in the upper left corner of your Word document to set the default in recent versions of Word before you select any material for pasting. Click the 'Word Options' box in the lower right corner of the box. From the menu column at the left, select 'Advanced.' The same window as in Step 2 will appear. Scroll down the page to 'Cut, Copy, and Paste'. Drop-down boxes appear to the right of the first five options. The option 'Match Destination Formatting' appears in the first four boxes. Select your preferences. Click 'OK' at the bottom right of the window.

Read more ►

How to Unlock an Excel 2003 Spreadsheet

1. Open the Excel spreadsheet you want to unlock.
2. Select 'Tools,' 'Protection' and 'Unprotect Sheet' from the toolbar. If you used a password to lock the spreadsheet, you'll be prompted to enter it in the 'Unprotect Sheet' pop-up box.
3. Enter the password and press 'OK.' The spreadsheet will unlock.
4. Click on 'File' and 'Save' to save your changes.

Read more ►

How to Merge Cells in Microsoft Excel 2003

1. Select the cells that you want to merge. To select cells for merging, left-click on the first cell and hold the mouse button in as you scroll over the cells that you wish to merge it with. Once you have selected the desired number of cells you can release the mouse button and they will stay highlighted.
2. Use the cell merge tool. After you have selected the cells that you want to merge, click on the cell merge icon located on the command bar. The icon looks like a lowercase letter 'a' sitting on top of a small book that is open. Left-click on this icon to merge the cells.
3. Set the text alignment in the merged cells. Use the text alignment icons located in the command bar to select left, right or centered alignment of the text within the merged cells after you have merged them.
4. Save your updated spreadsheet. After you have made the desired changes, do not forget to save your spreadsheet. Simply click on the “File” tab and select “Save” to save your changes.

Read more ►

How to Use Data Tables in Excel

Excel 2003
1. Open a new workbook.
2. Select the 'Data' tab.
3. Click 'Table.' Excel will create a table on your worksheet.
4. Create the data for your table. For example, you may have a set of values in column A and a formula you want to use in column B1 (there's no need to retype the formula, the table will carry it down for you).
5. Open a workbook.
6. Click on the 'Insert' tab, and then click 'Table.'
7. Provide the source of the data for the table. For example, if your data is in cells A1 through A10, then enter 'A1:A10' in the source box.
8. Click 'OK.' Excel will enter a table onto the worksheet.

Read more ►

How to Add a New Workbook in VBA

1. Press the 'Alt' and 'F11' keys together in your workbook to open the Visual Basic Editor (VBE).
2. Click 'Insert' and then click 'Module' to open a blank module window.
3. Type the following:Sub AddNew()Set NewBook = Workbooks.AddWith NewBook.Title = 'All Sales'.Subject = 'Sales'.SaveAs Filename:='Allsales.xls'End WithEnd Sub
4. Press 'F5' to run the program and open a new workbook.

Read more ►

How to Repair an Excel File

Attempt to Open the File
1. Repair the file manually. From the menu, click “File,” “Open.” Select the damaged file. Click the arrow next to the “Open” button. Click “Open and Repair.” At the prompt, click “Repair.” The file may open successfully.
2. If you have AutoRecover turned on, open the recovery file. Since recovery files are deleted when you quit Excel, try this before restarting. The default file location for AutoRecover files is “C:\\Documents and Settings\\
\\Application Data\\Microsoft\\Excel.”
3. Revert to the most recently saved version. On the menu, click “File” and “Open.” Select the name of the file you want to recover. A dialog box appears, asking “Revert to Saved Document?” Click “OK.”
4. Close Excel, then reopen it and see if you can open the file.
5. Restart the computer, then open Excel and try opening the file.
6. Clear temporary files. In Windows Explorer, navigate to \'C:\\Windows\\Temp.\' Delete the contents of the folder. Restart your computer, open Excel and see if you can open the file.
7. Start Excel in Safe Mode. Click “Start.” Under “Accessories,” click “Run.” Type the following command, including quotation marks (the “/s” switch specifies Safe Mode):
“c:\\program files\\Microsoft office\\office\\excel.exe” /s
Press “Enter.” When Excel opens, try to open the file.
8. If you have a more recent version of Excel installed, try opening the file in that version.
Save as SYLK or HTML
9. You may be able to filter out errors in the active sheet by saving in SYLK (Symbolic Link) or HTML (Hypertext Markup Language) format. To save as SYLK, select “File,” “Save As.” Click the arrow next to “Save as type,” and select “SYLK (Symbolic Link) (*.slk).” Click “Save.”
10. One or more warning messages will appear. Click “OK” or “Yes.”
11. Close the saved file.
12. Click “File,” Open.” Change the file type to “All Files.” Select the SLK file you just saved and click “Open.”
13. Click “File” and “Save As.” Give the file a different name, and save it as a Microsoft Excel workbook (.xls).
14. This method affects the active sheet only. For each additional worksheet in the corrupted file, reopen the workbook, activate the sheet and repeat the process.
15. If the problem persists, try saving the file in HTML format. After saving, close the file, reopen it and save it as an Excel file, using a different filename.
Modify the Registry
16. Back up the registry before making any changes. Changing the registry is risky, and the Registry Editor does not wait for a “Save” command before making your changes permanent. For information on backing up the registry, see the Microsoft Knowledge Base at support.Microsoft.com/kb/322756/en-us.
17. Open the Registry Editor. Click “Start,” then “Run.” Type “regedit” and press “Enter.”
18. In the left-hand pane, double-click on “HKEY_CURRENT_USER.” You will see a list of subkeys. Navigate to HKEY_CURRENT_USER\\Software\\Policies\\Microsoft\\Office\\10.0\\Excel\\Options by double-clicking each subkey.
19. In the right-hand pane, double-click on “ExtractDataMode.” In the “Value Data” box, change the “2” to “1.” Click “OK.” Close the Registry Editor and restart your computer to see if the change fixed the problem.
20. Follow the same procedure to change the value of “ExtractDataFormulas” from “2” to “1.” Restart your computer and see if the fix worked.
21. Repeat the process to change the value of “ExtractDataDisableUI” from “2” to “1,” and restart your computer.

Read more ►

How to Create Division Formulas in Cells in Microsoft Excel 2003

1. Choose the cells you wish to divide. Make sure the cells contain divisible dates.
2. Select a cell that will contain the formula. Pick an empty cell and left-click on it to activate and select it.
3. Create the division formula. In the blank cell, you will create a sum formula. The formula will have to include the cell you wish to divide and the cell that contains that division integer. A division formula for two cells would read like this: =Sum (D1/D2). This tells the spreadsheet to take the data contained in cell D1 and divide it by the data contained in cell D2. The program will place the results of the division operation into the blank cell in which you created the formula.
4. Implement the division formula. Once you are done entering the division formula, simply click on the 'Enter' key, and the formula will be implemented within your spreadsheet.

Read more ►