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 ►