How to Check for Duplicate Text in Excel

Excel 2007
1. Go to Microsoft Excel 2007 and open the worksheet you want to check.
2. Insert a column header for the column you’re checking. Then select the column and click on the “Data” tab.
3. Click on “Remove Duplicates” in the “Data Tools” group.
4. Place check marks by “My data has headers” and the columns you want to verify. Then click on “OK” to remove the duplicates.
Excel 2003
5. Open your document in Excel 2003. Make sure the column has a column header, then select the column you want to verify.
6. Select “Data,” “Filter” and “Advanced Filter” from the toolbar.
7. Accept the selected range or use your own. To change the list range, click on the “List Range” button and select your range on the spreadsheet.
8. Select “Copy to another location” under “Action” and place a check mark by “Unique records only.” Click on the “Copy to” button and choose the location where the updated data is placed. Then click on 'OK' to apply the update.
9. Double-check that the updated list looks correct, then select the old column and delete it.

Read more ►

How to Convert Xlsb to Xls

1. Double-click the XLSB file on your computer. This opens the file and loads Microsoft Excel on your desktop.
2. Click the 'File' menu button and then click 'Save As'. This opens your 'Save' dialog window. Select 'XLS' from the 'File type' drop-down box.
3. Click 'Save'. The file is saved to your hard drive and converted to the XLS file format.

Read more ►

How to Install Microsoft Excel Features in Excel 2003

1. Click the 'Start' or Windows button in the lower left corner of the screen, then select the 'Control Panel' option.
2. Choose the 'Programs and Features' or 'Add/Remove Programs' option, depending on which version of Windows is installed on your system.
3. Scroll to Microsoft Office 2003, then select the 'Change' option.
4. Choose the option to 'Add or Remove Features', then click the 'Next' button.
5. Check the box next to Microsoft Excel, as well as the box next to 'Choose advanced customization of applications'. Click the 'Next' button.
6. Click the ' ' sign next to Microsoft Office Excel, then click the feature that you would like to install. Select the 'Run from my computer' option. Repeat for any additional features you would like to install, then click the 'Update' button.

Read more ►

How to Disable the Automatic Updates for MS Office

1. Click the Windows 'Start' button and type 'Windows Update' in the search bar. Click on 'Windows Update' (it should be the first item listed).
2. Click 'Change Settings' located on the left hand column.
3. Click on the option list under 'Important Updates.' It will currently be set to 'Install Updates Automatically' but you can change this. There are a few options such as not downloading updates at all, or having the computer only download them automatically (but not install them without you choosing to do so). Pick the option that you feel most comfortable with; as long as you don't select the automatic install option you will be fine.
4. Click 'OK' to save the option.

Read more ►

How to Automatically Number Rows for an Excel Spreadsheet

1. Open the Microsoft Excel application on your computer. Click on the first cell where you want to establish a numbered pattern.
2. Type the beginning of the pattern in the first cell, like a “1.” Click on the next cell to continue the sequence by typing a following number in the sequence, like “2.”
3. Highlight the cells that you put numbers in and click on the fill handle in the lower right corner of the highlighted selection. Drag the handle down to complete as many rows as you want and the rows will be automatically numbered.
4. Click on the “Tools” option from the top tool bar menu if you don’t see the fill handle appear. Click the “Options” button and then click on the “Edit” tab.
5. Check the box next to the “Allow cell drag and drop” field. Every time you start to perform a function in a new row, or if you add a row, then a sequential number will automatically be updated.

Read more ►

How to Type a Negative Number in MS Excel

1. Launch Microsoft Excel 2010.
2. Click on a blank cell.
3. Press the 'Minus' sign ('-') on the keyboard and immediately press the desired numbers on the keyboard. Press 'Enter,' 'Tab' or an arrow key to save the number, and move to an adjacent cell.
4. Right click on the cell with the negative number displayed. Click 'Format Cells' on the context menu.
5. Click the 'Number' tab and click the desired format name in the left column to display options for that particular number format. Click the desired options for the number on the right. The options will vary by the type of number format being used.

Read more ►

How to Calculate Covariance in Excel 2007

1. Run Microsoft Excel 2007 and open the workbook that contains your data arrays.
2. Determine the cell addresses for your two arrays. For example, if your arrays are contained in the first 10 columns of rows A and B, then the cell addresses for those arrays are A1:A10 and B1:B10.
3. Click a blank cell that you would like to use to display the covariance between your data arrays.
4. Type the following in the cell:=COVAR(A1:A10,B1:B10)Substitute the cell addresses for your two data arrays in place of the sample addresses in the example.
5. Press 'Enter.' The cell displays the covariance between the two data arrays.

Read more ►

How to Calculate Pecentage Using Excel

1. Browse to the Excel file containing the data for which you wish to calculate a percentage, and then double-click that file to open it in Excel 2010.
2. Locate the cells containing the data that represents your 100 percent value and the cell to which you are comparing it.
3. Note the cell names for those two particular cells. For example, if one piece of data is in the upper-leftmost cell, then the cell name would be 'A1.'
4. Click inside the cell in which you want to display the percentage.
5. Type '=AA/BB,' where 'BB' is the name of the cell containing your 100 percent value, and 'AA' is the name of the cell containing the amount to which you are comparing it.
6. Press 'Enter' to perform the calculation.
7. Right-click the cell into which you just typed your formula, and then click 'Format Cells.'
8. Click the 'Number' tab at the top of the window.
9. Click 'Percentage' in the column at the left side of the window, and then click 'OK.'

Read more ►

How to Upgrade to Excel 2007

1. Insert the Microsoft Office 2007 setup disc into the computer. The installer should automatically launch. If it does not, open the 'Computer' folder, open the Microsoft Office disc and double-click the 'setup.exe' file.
2. Enter your Product Key when prompted. Accept the license agreement.
3. Click 'Custom.' Select 'Remove all previous versions' or 'Remove only the following applications: > Microsoft Office Excel.' The former will remove all applications in the currently installed Microsoft Office suite.
4. Select 'Installation Options.' Select 'Microsoft Office Excel > Run from Computer.' If you wish to upgrade other Office applications during this installation, select those as well.
5. Click 'Install Now.' Click 'Close' when the upgrade completes.

Read more ►

How to Find the Regression Equation in Excel 2007

From Graphing
1. Select all the x (independent variable) and y (dependent variable) data.
2. Click on 'Insert' in the top menu bar, then on 'Scatter.' Click on any of the five chart options.
3. Click once on the graphed line. Right-click the line and choose 'Add Trendline...' from the menu that appears.
4. Click the check-box for 'Display Equation on chart' at the bottom of the window that appears. Click 'Close.' The regression equation for the data appears on the chart. With example x-values (1,2,3,4,5) and y-values (10,12,14,16,20), the equation that appears is 'y = 2.4*x 7.2.'
Built-in Excel Functions
5. Find the slope of the regression equation, 'm,' by typing in any empty cell '=slope(known_ys, known_xs).' For example, if the known y-values are the cell range B1:B5 and the known x-values are in the cell range A1:A5, then type '=slope(B1:B5,A1:A5).' With example x-values (1,2,3,4,5) and y-values (10,12,14,16,20), the result is a slope of two and four tenths.
6. Find the y-intercept of the regression equation, 'b,' by typing in any empty cell '=intercept(known_ys, known_xs).' For example, if the known y-values are the range B1:B5 and the known x-values are in the range A1:A5, then type '=intercept(B1:B5,A1:A5).' With the same examples values as before, the result is a y-intercept of seven and two tenths.
7. Write out the regression equation now as 'y = m*x b.' In our example, the regression line equation is 'y = 2.4*x 7.2.'
Brute Force Calculations
8. Calculate the sum of all the x-values, denoted (x). Do this by typing in an empty cell '=sum(A1:A5),' where A1:A5 is the range of x-values. Perform the same operation to find the sum of all the y-values, denoted (y), which may for example be in the range B1:B5.
9. Calculate the sum of the product of each x and y pair, denoted (xy). Do this by summing together A1*B1, A2*B2, etc.. in the same fashion as step one. Also, denote the number of x-y pairs as 'n.'
10. Calculate the sum of the square of each x-value, denoted (x^2). Do this by summing together A1^2, A2^2, etc.. in the same fashion as step one.
11. Calculate the slope, 'm,' of the regression equation by performing the following calculation: n(xy) - (x)*(y). Then calculate n(x^2) - (x)^2. Lastly, divide the first result by the second result. With example x-values (1,2,3,4,5) and y-values (10,12,14,16,20), the result is a slope of two and four tenths.
12. Calculate the y-intercept, 'b,' of the regression equation by performing the following calculation: (y)-m*(x). Lastly, divide the result by 'n.' With the same example data as the previous step, the result is a y-intercept of seven and two tenths.

Read more ►

How to Hide Gridlines in Excel

1. Open Microsoft Excel.
2. Click on the 'Office' button. Select 'Open' to load your saved spreadsheet, or select 'New' to start a new project.
3. Click on the 'View' tab. Tabs are located at the top of the main Excel window, and clicking on a tab does not take you away from your spreadsheet.
4. Click on the 'Gridlines' check box to deselect it. The box is checked by default, and deselecting the box turns off gridlines for the spreadsheet. Changes appear immediately within your Excel spreadsheet.

Read more ►

How to Duplicate Sheets in Excel 2007

1. Open Excel 2007 and click the 'Office' button. Select the 'Open' option. Browse the files and locate the Excel workbook. Click the workbook and the 'Open' button. The workbook opens.
2. Right-click on the spreadsheet and click the 'Copy' option. The 'Move Or Copy' dialog box appears. Select the workbook to duplicate the worksheet to in the 'To Book' drop down list. Click the worksheet where this copied worksheet will appear before in the 'Before Sheet' drop down list.
3. Click the 'Create A Copy' check box. Click 'Ok' to complete the copy.

Read more ►

How to Convert a Number to Text in Excel 2007

1. Open the Excel spreadsheet that has the numbers you want to convert to text.
2. Use your mouse to highlight the cell(s) you want to convert to text.
3. Click the 'Home' tab located in the Excel ribbon at the top of the page and look to the 'Number' section of the ribbon.
4. Click the arrow next to 'Number' on the ribbon to open the 'Format Cells' dialog box.
5. Click the 'Number' tab when the 'Format Cells' box opens. A list of options you can convert the numbers to is located in the left pane of the dialog box. Some options you can convert the numbers you selected to include percentages, fractions and text.
6. Select 'Text' from the options and click 'OK.' The numbers you selected on your spreadsheet will now be formatted as text.

Read more ►

How to Delete Every Other Row Automatically in Excel 2003

1. Open a new workbook in Excel and type the number '1' in cell A1. Skip cell A2 and type '2' in cell A3. Repeat this process until you have the numbers 1 through 5 entered in cells A1 through A9. The following cells should have the following numbers: '1' for A1, '2' for A3, '3' for A5, '4' for A7 and '5' for A9.
2. Click 'Tools' and select 'Macro.' Click on 'Visual Basic Editor.'
3. Select the 'Insert' tab and click 'Module.'
4. Copy the following macro and paste it in the Visual Basic sheet:Sub Delete_Every_Other_Row()' Dimension variables.Y = False ' Change this to True if you want to' delete rows 1, 3, 5, and so on.I = 1Set xRng = Selection' Loop once for every row in the selection.For xCounter = 1 To xRng.Rows.Count' If Y is True, then...If Y = True Then' ...delete an entire row of cells.xRng.Cells(I).EntireRow.Delete' Otherwise...Else' ...increment I by one so we can cycle through range.I = I 1End If' If Y is True, make it False; if Y is False, make it True.Y = Not YNext xCounterEnd Sub
5. Click 'Close and Return to Microsoft Excel' to exit, then test the macro by highlighting rows A1 through A9 on the Excel spreadsheet you made earlier. Click 'Tools,' then 'Macro' and then click 'Macros.'
6. Select 'Delete_Every_Other_Row' from the Macro menu and click 'Run.' The alternate rows will be deleted and numbers 1 through 5 will now be displayed in cells A1 through A5.

Read more ►

How to Delete Multiple Overlapped Checkboxes in Excel

1. Start Microsoft Excel. Press 'CTRL O,' select your workbook and then click on 'OK.'
2. Click 'Find Select' under the Home tab on the ribbon toolbar. Choose 'Selection Pane' from the menu. This opens a list panel at the right side of the Excel window.
3. Click 'Show All' near the bottom of the Selection Pane.
4. Hold down 'CTRL' and then click on the items on the list that correspond to the overlapped checkboxes. To de-select an item, click on its name again.
5. Press 'DELETE' to remove the checkboxes from your sheet.

Read more ►