How to Delete Commas From Excel 2007

1. Double-click on the cell that you want to edit.
2. Position the cursor directly behind the comma that you want to delete. Click the mouse once in this spot.
3. Click the 'Backspace' button on the keyboard to remove the comma. If there are multiple commas in the cell that you want to delete, use the arrow keys to move over to them and hit 'Backspace' to delete them.
4. Click 'Enter' when you are finished making changes to the cell.
5. Repeat the process for any additional cells you wish to edit.

Read more ►

How to Insert Copy a Formula in Excel 2007

1. Open Excel and the worksheet in question. Position the cursor in the cell in which you wish to insert the formula.
2. Click on the Formulas tab at the top of the Excel window. Choose the proper category for the formula you will be using, and then select the formula that you wish to insert from the list that appears.
3. Enter the cell references as prompted in the Function Arguments dialog box that appears.
4. Copy any of your existing formulas by first selecting the cell that contains the formula you wish to copy.
5. Click on the Home tab at the top of the Excel window, and select the Copy icon. Select Paste if you would like to paste both the formula and the formatting, and click on Paste Special if you want to paste the formula only.
6. Copy your formula into adjacent cells by using the Excel fill handle. This is a small black square that is located at the lower-right corner of the cell or group of cells you have selected. Move your mouse over it, and when the pointer turns to a black cross, left-click and drag the fill handle over the range of cells into which you wish to copy the formula.

Read more ►

How to Enable a Ribbon Customizer

1. Launch the Microsoft Office application for which you want to customize the Ribbon interface.
2. Right click anywhere on the Office Ribbon, then click 'Customize the Ribbon.'
3. Click the 'New Tab' button at the bottom of the right side of the 'Options' screen. The application creates a new section labeled 'My Tab' in the right pane of the window.
4. Drag and drop desired command functions and options for the Ribbon Tab from the drop-down menu on the left side of the 'Options' screen into the 'My Tab' section of the right-side window pane.
5. Click the 'OK' button at the bottom of the screen after you finish dropping desired function and option commands into your new customized Ribbon Tab. Once you return to the main Office application screen, the new tab is immediately available for use within the program.

Read more ►

How to Make a Time Line in Excel 2003

1. Open a blank worksheet in Microsoft Excel. Click 'View' on the toolbar and click 'Header and Footer'. The 'Page Setup' box will open. Click the 'Custom Header' button and enter the header you want printed on your page. Format it using the 'Font' button. Click 'OK' to close the 'Header' box, but don't close the 'Page Setup' box.
2. Click the 'Page' tab of the 'Page Setup' box. Under 'Orientation', select the 'Landscape' button. Click 'OK' to close the 'Page Setup' box.
3. Select all of the cells on your current page in row 7 using your mouse. Click on the 'Fill Color' button on your toolbar (which looks like a pouring paint can) and choose a fill color for those cells.
4. Select all of the cells in row 6 by clicking on the number 6 with your mouse. Right-click and choose 'Format Cells'. Click the 'Alignment' tab of the 'Format Cells' box. Under 'Orientation', move the 'Text' to 90 degrees. If desired, click the 'Font' tab and make changes to the font for those cells. Repeat these steps for row 8, except change the 'Text Orientation' to -90 degrees. This will align your text up and down from the timeline bar.
5. Enter times in the bar itself and enter data in the corresponding cells in rows 6 and 8. If desired, you can add clip art pictures by going to the 'Insert' menu, pointing to 'Pictures' and clicking on 'Clip Art'. Search and enter pictures that suit your timeline. When you are finished, you can print your personalized timeline.

Read more ►

How to Do a Frequency Distribution in Excel 2007

1. Click the 'Data' tab and then click 'Data Analysis.'
2. Click 'Histogram' and then click 'OK.'
3. Type 'A1:A2' into the 'Input Range' box, where A1 and A2 represent the actual range of cells on your worksheet where your input data is. For example, if your range of data is in A1 to A10, type 'A1:A10'
4. Type 'B1:B2' into the 'Bin Range' box where B1 and B2 represent the range of cells where your bin data is located. Bins represent the groups you want your data to fall into. For example, if you want your data to fall into bins of 1-10 and 11-20 and those values are located in cells C1 and C2, then type 'C1:C2' into the Bin Range box.
5. Click 'New Workbook' under 'Output Options,' then click the 'Chart Output' check box. Click 'OK.' Excel will create your frequency distribution table in a new workbook along with an embedded chart.

Read more ►

How to Turn on the Developer Tab in Excel 2007

1. Open the Microsoft Excel 2007 file for which you want to open the Developer tab.
2. Click on the 'Microsoft Office' button in the top-right corner of the application.
3. Click on the 'Excel Options.'
4. Click on the 'Popular' option and then click on the box next to the 'Show Developer Tab in the Ribbon' field so that it's selected.
5. Close the dialog box and then click on the Developer tab in the ribbon at the top of the application. You now have the Developer options available to you.

Read more ►

How to Freeze (Lock) Column Headings in Microsoft Excel

1. Launch Excel and open your spreadsheet.
2. Select the 'View' tab at the top of the Excel window.
3. Click the 'Freeze Panes' button. This will open a drop-down menu.
4. Click 'Freeze Top Row.'

Read more ►

How to Span Columns in MS Excel

1. Highlight the cells you want to merge by holding 'Shift' and moving the arrow keys to highlight the data.
2. Right-click on a highlighted cells and select 'Format Cells.'
3. Click 'Alignment.'
4. Check the box next to 'Merge Cells.'

Read more ►

Location of Excel 2003 Commands in Excel 2007

1. Click the Microsoft Interactive: Excel 2003 to Excel 2007 command reference guide.
2. Click 'Start the Guide.'
3. Click 'Start.'
4. Click the Excel 2003 command that you want to find in Excel 2007. For example, click the 'Autosum' command. The program will open a pop-up window showing you where you can find the command in Excel 2007.

Read more ►

How to Use Excel's YEARFRAC Function

1. Install the Analysis ToolPak, if needed. If YEARFRAC returns the #NAME? error value, select Add-Ins from the Tools menu. Mark the checkbox next to Analysis ToolPak and click on the OK button to install it.
2. Learn the syntax of YEARFRAC. It is YEARFRAC(start_date, end_date[, basis]) where start_date is the first date and end_date is the last date of the desired date range. Basis is an optional argument that specifies the method to use for counting the days.
3. Enter start_date and end_date using the DATE function or some other function that returns a date to prevent the problems that can occur when a date is entered as text. YEARFRAC will return the #VALUE! error value if any of its arguments is not a valid date.
4. Specify basis, if needed. The default is zero and indicates the days in the month are to be counted with the United States' 30-day method and a 360-day year. A 1 uses the actual number of days in the year. A 2 uses the number of days in the month with a 360-day year while a 3 assumes a 365-day year. A 4 is the same as 1 but uses the European 30-day method.
5. Study an example of YEARFRAC. =YEARFRAC(DATE(2007,1,1),DATE(2007,7,30),2) returns 0.5833333333. There are 210 days separating these two dates and with a 360-day year, we have a year fraction of 210/360 = 7/12 or 0.5833333333.

Read more ►

How to Remove the Contribute Toolbar

Disabling the Contribute toolbar in Internet Explorer and Firefox
1. Click the \'Tools\' menu and click \'Manage Add-ons\' (Internet Explorer) or \'Add-ons\' (Firefox). A new window launches.
2. Select \'Adobe Toolbar\' and select \'Disable\' in the settings section if you are using Internet Explorer. Select \'Disable\' in he extensions section if you are using Firefox. Select \'ContributeBHO Class\' if you are using Contribute CS3, and set it to \'Disable\' (Internet Explorer) or click the \'Disable\' button (Firefox). Contribute disables the contributeplugin.dll file.
3. Click \'OK\' to save the changes. You should no longer see the Contribute toolbar when you launch Internet Explorer or Firefox.
4. Click the Windows \'Start\' menu and click the \'Control Panel\' if you want to uninstall the Contribute toolbar completely if you are using Contribute 4. Double-click \'Add or Remove Programs\' to launch the programs window if you are using Windows XP. For Windows Vista and 7 users, click \'Programs\' and click \'Programs and Features\' to launch the programs window.
5. Select \'Adobe Contribute 4\' and click \'Remove/Uninstall.\' The uninstallation wizard launches. Click \'Next.\' Select \'Modify for Contribute 4\' and click \'Next\' again. Deselect the Contribute toolbar and click \'Next.\' Click \'Next\' again and click \'Install\' to remove the Contribute toolbar.
Disabling the Contribute toolbar in Microsoft Office
6. Close Contribute and any Microsoft Office programs.
7. Double-click \'My Computer\' on the desktop. Navigate to the \'Program Files\\Adobe|Contribute 4\' if you are using Contribute 4. Navigate to \'Program Files\\Adobe\\Adobe Contribute CS3\' if you are using Contribute CS3.
8. Right-click the \'OfficePlugin.dll\' file and click \'Rename.\' Rename the file \'OfficePlugin.old\' (without quotes).

Read more ►

How to Insert a Static Date in Excel

1. Open Microsoft Excel 2007, and start a new spreadsheet that you would like to insert a static date into or open an existing spreadsheet from your files into which you want to insert a static date.
2. Click to select the cell to which you want to insert the static date. The cell will then be surrounded by a thick, black outline indicating it is ready for you to insert the static date into it.
3. Use your keyboard to enter the shortcut of 'CTRL' ';' into the selected cell. Both the 'CTRL' key and the semicolon key must be pressed at the same time. This keyboard shortcut will tell Excel to enter a static date into the selected cell.
4. Watch as the current date appears in the selected cell. This date will remain static, not being updated at any time during the life of the spreadsheet.
5. Utilize the procedure that is outlined above to insert the static date into any other cells in the spreadsheet where you would like to display a static date.

Read more ►

How to Group and Outline Excel Data

1. Open your Excel spreadsheet. Organize the data to be outlined. Make sure the fields you want to group are adjacent to each other. Insert summary rows or columns beneath or beside the fields that you will be outlining. Summary rows or columns should contain formulas to average or sum up the fields to be outlined.
2. Highlight the series of columns or rows you want to group. Select rows or columns by clicking on the gray letter or number field at the side or top of the spreadsheet.
3. Choose 'Data' from the menu. Choose 'Group and outline.' Select 'Group.' You'll see a gray box on the left side of the spreadsheet, with a line beside the rows of grouped Excel data. If you grouped columns, you will see the gray box and the line at the top of the spreadsheet.
4. Click the '-' to collapse or hide the grouped fields, and the ' ' to expand or display them.
5. Select the rows and columns that you have grouped. Click 'Data,' 'Group and outline' and 'Ungroup' to remove the grouping. To remove all groups and outlining, click 'Data.' Click 'Group and outline' and choose 'Clear outline.'

Read more ►

How to Make a Graph for Density in Excel With Microsoft

1. Select the two Excel spreadsheet columns that contain density graph data, and then click the 'Insert' tab on the Excel main menu.
2. Set the Excel graph to a “Scatter with only Markers” type by selecting this option from the drop-down menu on the 'Charts: Scatter' section of the Excel Ribbon menu. This is the best option for a density graph, not only because you are comparing pairs of values, but also because each pair represents a separate measurement.
3. Right-click anywhere on the graph, and choose “Select Data” from the resulting pop-up window. The 'Select Data Source' window will open, and 'Series 1' will appear as the only entry in the Legend Series column on the left.
4. Click the Series 1 entry, and then click the Edit button to close the 'Select Data Source' window, open the 'Edit Series' window, and enable Chart Tools on the Excel Ribbon. Verify that mass data is on the y-axis and volume data is on the x-axis.
5. Locate and open the set of Chart Layout types -- the third section from the left on the Ribbon -- by clicking the down-arrow button. Select Layout 9.
6. Double-click on the Chart Title to change the default title to one that is more appropriate. Click on and change the vertical y-axis title to Mass (g) and the horizontal x-axis title to Volume (ml), substituting units of measurement if yours are something other than grams and milliliters.
7. Draw a straight line -- called a trendline -- through the data by right-clicking on any data point and selecting 'Add Trendline' from the resulting pop-up box.
8. Select 'Linear Regression,' check the Set Intercept box, and set the intercept to zero. This action will ensure the trendline is the best fit for your data. By default, Excel will display the equation you are working with on the graph as well as its R2 value. Uncheck these boxes if you do not want to display this information.
9. Make final adjustments to your density graph, using 'Format Axis' and 'Format Size' options. These allow you to change line thickness and color, and increase the size of the graph.

Read more ►

How to Use Multiple Data Sources in One PivotTable

1.
Data with the same headers can be stacked in longer columns.
Prepare the data to consolidate by making sure the source spreadsheets all have the same column headers and row names. This will enable you to place the correct data in the correct column during the consolidation (see Resources).
2.
The Pivot and Chart Wizard can expedite tasks.
Click a blank cell in the Excel spreadsheet where you will create the consolidation.Hold down 'Alt' 'D' 'P' to open the 'PivotTable and PivotChart Wizard.' If you plan to use this wizard often you can add it to the 'QuickAccess' toolbar by clicking the tiny arrow at the very top of Excel to the right of the 'Save' icon. Click 'More Commands,' then under 'Choose Commands From,' select 'All Commands.' Click 'PivotTable and PivotChart Wizard,' then click 'Add,' then click 'OK.'
3. Click 'Multiple Consolidation Ranges' in the 'PivotTable and PivotChart Wizard' then click 'Next.' On 'Step 2a' click 'I will create the page fields,'' then click ''Next.' On ''Step 2b'' first open the first worksheet that contains the data. Click ''Collapse Dialogue,'' if it appears, for each cell range you select in the next step. Select the cell range, then click ''Expand Dialogue,'' then click ''Add.' Where the wizard asks 'How many page fields do you want?' click ''0,'' then click ''Next.''
4. In ''Step 3'' you will be asked to select a location for the PivotTable. Select a location for the first spreadsheet, then click ''Finish.''
5. Repeat this process for each cell range in each of the multiple spreadsheets, appending them by the column names which should be the same on each spreadsheet. When the last spreadsheet is consolidated you are ready to begin using the multiple data sources in the PivotTable.

Read more ►