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 ►