1. Run the program that the infecting macro was originally opened with, such as Microsoft Word or Excel, by double-clicking on its appropriate desktop icon.2. Click on the 'View' tab at the top of the screen. Scroll all the way over to the far right side of the screen and click on the button labeled 'Macros.' Click on 'View Macros' on the drop-down menu that will pop up underneath the Macro button.3. Wait for the new window to pop up and then scroll through the list of macros installed until you find the one that infected your computer. Click on the name of the macro and then click on the...
Browse » Home » Archives for November 2012
Wednesday, November 28, 2012
How to Format Rows and Columns in Excel 2003
1. Open your Excel worksheet and select the rows or columns you want to format. To select, hold down the left mouse button and drag.2. Click 'Format' on the top menu bar to summon a list of options for formatting your worksheet.3. Click either 'Row' or 'Column.' The rows are horizontal, the columns are vertical.4. If you click 'Row,' a box will appear. Enter the row height. If you pick 'Column,' enter the column's width in the designated box.5. When you've finished formatting, click 'OK' and save your wo...
Tuesday, November 27, 2012
How to Restore Microsoft Excel to Its Default Spreadsheet
Excel 2003 or Earlier1. Go to \'C:\\Documents and Settings\\\\Application Data\\Microsoft\\Templates.\' Open \'My Computer\' and open the \'Documents and Settings\' folder. Open your username, then \'Application Data,\' \'Microsoft\' and finally find the \'Templates\' folder.2. Rename the Book.xlt and Sheet.xlt files to something that you will remember. This step is optional, but allows you to save the settings for later use. Either move these files, or delete them if you don't want to use the template again. If there are no XLT files in this folder, continue below.3. Go to \'C:\\Program...
How to Flip Column Headings As Row Headings on an Excel Spreadsheet
1. Select and copy the entire data range you want to transpose. For example, if you have 10 columns and 10 headers, highlight them as well as all the data within. Excel will accurately transpose not only the column and header titles but also the data.2. Click on a new location in your worksheet for the transposed information to go. The simplest thing to do is go down a few columns and click. This way you can compare the new information with the old before deciding which information to keep. You can delete the other data or decide to use the information in both formats.3. Click on the “Edit”...
How to Perform the Command to Center a Worksheet Both Horizontally Vertically
Excel 20031. Log on to your computer and open Excel 2003. Click the 'File' menu and choose 'Page Setup.'2. Click the 'Margins' tab. Go to the 'Center on Page' section.3. Check both the horizontal and vertical check boxes. Click 'OK' to print your centered worksheet.Excel 20074. Open Microsoft Excel 2007 and open the spreadsheet you want to center. Click the Office button on the upper-left corner of the screen. Go to the 'Print' menu and select 'Print Preview.'5. Choose the 'Page Setup' option and click the 'Margins' tab. Check the 'Horizontally' and 'Vertically' boxes in the 'Center...
Monday, November 26, 2012
How to Compare Two Columns in VLookup
1. Open Excel 2010 and select a workbook. Click the 'File' tab and select 'Open.' Browse the files and locate the workbook. Click the workbook and select the 'Open' button. The workbook opens.2. Sort the values that will be included in the vlookup. The first column needs to sort in ascending order. Click in the first cell of the third column. Click the 'Formulas' tab and select the 'Lookup Reference' button. Select 'Vlookup' from the list of functions. The function arguments window opens.3. Click the 'Lookup value' field. Click the red arrow. Select the first cell in the third...
How to Align Text in Excel Cells
1. Start Microsoft Excel and open the file you want to change.2. Select the cells in which you want to align the text.3. Open the Format menu and select Cells.4. In the Format Cells dialog box, select the Alignment tab.5. In the Text Alignment pane, click the horizontal text box.6. Select the horizontal alignment type such as left, right, center.7. Click the vertical text box.8. Select the vertical alignment type, such as top or bottom.9. Select OK to accept the chang...
Sunday, November 25, 2012
How to Make a Selection in Microsoft Excel
1. Click a single cell with the mouse to select it. This cell will be surrounded by a black border and the row and column it belongs to will be highlighted in the frame around the spreadsheet. If you're only looking to select one cell, you're done!2. Click the initial cell, keep the mouse button pressed down, and drag the mouse horizontally, vertically or diagonally to select multiple adjacent cells. Now the entire group of cells (called a range) will be shaded gray and surrounded by a black border.3. Click the name of a column or row in the frame around your Excel spreadsheet to select...
How to Make an Ogive in Excel
1. Open a new Excel spreadsheet. Type 'Data' into cell A1, then type 'Bins' into cell B1. Enter the data set that you want to use to create the Ogive chart into column A, starting with cell A2.2. Enter the bins for your histogram into column B, starting with cell B2. The bins are the numbers that represent the top value in the data ranges for your histogram. For example, if you want to determine the frequency of ranges from '0 to 5,' '6 to 10' and '11 to 15,' your bins would be '5,' '10' and '15.' The bins will appear on your Ogive chart as values plotted on the horizontal axis.3. Click...
Saturday, November 24, 2012
How to Import OFX Files Into Microsoft Excel
1. Click 'Start,' type 'notepad' (without quotes) and press 'Enter.' Press 'Ctrl O.' Click the 'File type' drop-down menu and select 'All Files and Folders *.*.' Locate your OFX file, select it and click 'Open.'2. Browse through your OFX file. You will notice that there is a pattern among all entries. Each OFX file will be different, but in general you will notice fields of data such as times, amounts or comments. There will also be a selection of letters or characters separating each line of data (e.g., hrt]). This 'separator' will be the same throughout. Determine what the separator is.3....
How to Make Graphing Paper in Excel
1. Open a new Microsoft Excel 2010 spreadsheet. Click on the small square above the '1' and to the left of the 'A' in the spreadsheet's top-left corner. This will select the entire spreadsheet.2. Move your mouse between the 'A' and 'B' at the top of the spreadsheet. Once the pointer changes to appear as a line with two opposite arrows coming off of it, click and hold the mouse button. Drag the mouse to the left to shorten the columns until you get the horizontal spacing that you desire for your graph paper. Make note of the number of pixels that appear in the small popup box above your mouse...
Friday, November 23, 2012
How to Remove a Lost Excel Password
1. Open Excel and then the workbook file for which you wish to remove the password. If you are using Excel 2007 skip straight to Step 5; for all previous versions continue on to Step 2 below.2. Click on the 'Tools' menu at the top of the Excel window. Select 'General Options' from the drop down list of choices that appear.3. Locate the box labeled 'In the Password to open' and double-click on the asterisk in it. Click 'Delete', and click 'OK.' Repeat the process for the box labeled 'Password to modify.'4. Click 'Save', and then 'Yes' to complete the removal of the password in versions...
Thursday, November 22, 2012
How to Insert Animated GIF Files in Excel
1. Navigate to the folder that contains your animated GIF file. Write down the full path name of the folder and the name of the file. For example, if the file is contained in a subfolder of your C: drive called Pictures and the file name is bear.gif, then the full path name would be c:\pictures\bear.gif.2. Open the Microsoft Excel document to which you would like to add your animated GIF.3. Click on the 'View' menu and choose 'Toolbars' => 'Control Toolbox.'4. Click on the top button in the 'Control Toolbox,' which activates 'Design Mode.' 'Design Mode' allows you to draw an item in...
How to Highlight Duplicates in Excel
1. Highlight the cells you want to check for duplicates. You can highlight a row, a column, any array or non-contiguous group of cells, or the entire worksheet.2. Click 'Home,' then 'Styles,' and then 'Conditional Formatting' in Excel 2010, or the 'Conditional Formatting' drop-down in the Home tab in Excel 2007.3. Choose 'Highlight Cell Rules,' then click 'Duplicate Values....'4. Leave 'Duplicate' selected in the drop-down list of the resulting window, and choose a preset or custom format. Click 'OK' to close the window and view the highlighted resul...
How to Transfer an Adobe InDesign Table Into Microsoft Excel
1. Count the exact number of rows and columns in the InDesign table you wish to transfer. Knowing the exact number will be important when you are working in Microsoft Excel.2. Click on the Type tool in the Tool Palette. The Type tool looks like a capital letter T.3. Select all columns and rows of the table. To do this, hold your mouse over the left most line on the top row of the table. The cursor will turn into a solid back arrow. Hold the mouse button down to highlight the first row and drag the mouse down to the bottom of the table to highlight all of the rows. The table will be selected...
How to Add a Footer in Excel 2007
1. Click the 'Insert' tab in Microsoft Excel.2. Click 'Header Footer' in the 'Text' group.3. Click the bottom scroll arrow until 'Click to add footer' is visible and click it.4. Type the text you wish to display. To enter dynamic elements, click the appropriate button in the 'Header Footer Elements' group of the current Design tab. Available elements include 'Page Number,' 'Number of Pages,' 'Current Data,' 'Current Time,' 'File Path,' 'File Name,' 'Sheet Name' and 'Picture,' which allows you to add a picture to the footer.5. Click the 'Home' tab to access text formatting features...
Wednesday, November 21, 2012
How to Make Negative Numbers = 0 in Excel
In Formulas1. Write a formula to evaluate data. For example, if you're subtracting A1 from B1 and showing the results in C1, type '=(B1-A1)', minus the quotes, into cell C1.2. Add 'MAX' to the formula to designate the maximum answer allowed: '=MAX(B1-A1)'. This is only part of the formula; if you press 'Enter' at this point, you will get an error message.3. Insert the amount for the maximum number allowed as the formula result -- in this case, zero: '=MAX(0,B1-A1)'. Any results that would normally be negative become 0, not just as display text, but as value. If the formula result of B1-A1...
How to Create a Weekly 24 Hour Calendar With Excel
1. Open a blank worksheet in Excel. Select cells A1 through H1 by clicking on A1, holding down the mouse button and dragging the mouse over to H1. Go to the Cells section of the Home tab, click the 'Format' drop-down arrow and select 'Row Height.' Change the row height to '26.25' and click 'OK.'2. Type the word 'Time' in cell A1. In cell B1, type 'Monday.' Click B1 to select it, then click on the fill handle, which is a small black square in the bottom right corner. Drag the fill handle across to cell H1 to fill with in the other days of the week.3. Type '12:00 AM' in cell A2. Select A2...
How to Insert Page Breaks on a Pivot Table
1. Open the Excel file that contains the pivot table you want to format. Then select 'View,' 'Toolbars' and 'PivotTable' from the toolbar to open the 'PivotTable' toolbar if it's hidden.2. Select 'PivotTable' and 'Table Options' from the 'PivotTable' toolbar. The 'PivotTable Options' dialog box will open. Add a checkmark to 'Repeat item labels on each printed page' and to 'Set print titles.' Then click 'OK.'3. Go to the 'Pivot Table Field List' task pane. You can open the task pane if it's closed by clicking on the 'Show Field List' button in the 'PivotTable' toolbar.4. Customize how each...
How to Check for Circular References in Excel
1. Start Microsoft Excel 2007 and open a workbook from your files that contains formulas that aren't properly calculating a result.2. Study the formula that isn't calculating a result. Check to see if a cell reference in the formula is referring to the cell that the formula resides in. If it is, then you have a circular reference.3. Select the 'Formulas' tab to display the 'Formula' ribbon. This contains all the formula options for an Excel workbook.4. Click the arrow to the right of the 'Error Checking' button in the 'Formula Auditing' section of the 'Formula' ribbon.5. Point to 'Circular...
Tuesday, November 20, 2012
How to Get Document Recovery Task Pane in Excel 2007
1. Open Microsoft Excel 2007 on your computer and then select the 'Microsoft Office' button. Click the 'Open' button.2. Select any Excel file and then click the 'Open' button. Press the 'Ctrl,' 'Alt' and 'Delete' keys at the same time to bring up the Task Manager.3. Click the 'Applications' tab and then select the Excel 2007 file you have open. Click the 'End Task' option.4. Open the Excel 2007 program again and the Document Recovery task pane will appear. Click the 'Recovered' button from the status bar to hide the Document Recovery task pane.5. Click the 'Recovered' option again at...
How to Display Statistical Worksheet Functions in Excel
1. Click the Microsoft 'Office' button in the top left corner of Excel.2. Click the 'Excel Options' button.3. Click 'Add-Ins' in the list. The window to the right will display all the inactive add-ins that you can add. You do not need to click any of these at this point.4. Click 'Excel Add-Ins' under the Manage section at the bottom and click 'Go.' You will get a pop-up window with available add-ins.5. Check the 'Analysis ToolPak' box and click 'OK.' If you get a message that it is not installed and are asked if you want to install it, click 'Yes' to install it.6. Click the 'Data'...
How to Use Countif on Excel 2003
1. Open Excel 2003 and select a workbook. Click 'File' on the menu bar. Select 'Open.' Browse your computer file and locate the workbook. Click the workbook and select the 'Open' button. The workbook opens.2. Click on a cell to enter the Countif function. Enter the following formula in the cell: '=Countif.' Notice the Excel hint that appears beneath the formula. Hints serve as a mini guide to assist you as you enter the formula. Click the 'Insert Function' button on the formula bar. The Function Arguments dialog box appears.3. Click the box with the red arrow in the 'Range' field....
How to Create a Curve Graph in Excel or Word
1. Input your x-values into the first column, starting at cell A1.2. Input your y-values into the second column, starting at cell B1.3. Select 'Insert' from the toolbar and choose the 'Scatter' button. Choose 'Scatter With Smooth Lines' from the drop-down menu.4. Select the chart by left clicking on it. Go up to the top toolbar and select 'Layout' underneath 'Chart Tools.' Select 'Primary Horizontal Axis' from the 'Axes' drop-down menu (press the down arrow beneath 'Axes' for the menu). Select 'More Options,' and change the minimum and maximum x-values by selecting the top two radio buttons....
Sunday, November 18, 2012
How to Remove a Password on Excel
Office 20031. Launch Excel from the desktop icon or the “Start” menu of your computer. Go to the “File” menu and select “Open.” Navigate to the folder that contains the password-protected Excel workbook and double-click the file to open it.2. Enter the password that you created for the Excel workbook, when prompted. Press “Enter” to open the workbook.3. Go to the “File” menu in Excel and choose “Save As.” Open the “Tools” menu in the “Save As” dialog box and select “General Options.”4. Highlight the asterisks in the “Password to open” box. Press the “Delete” key and click “OK” to close...
How to Use Excel Formula Functions
1. Launch Microsoft Excel. You can begin with a blank document or open an existing document for which you want to use formula functions. If you do not have MS Excel, use the link in Resources for a free trial.2. Populate the spreadsheet with the data appropriate to one or more of the Excel functions that you want to use. Click once inside the cell in which you want to use a formula. Click once on the 'Insert Function' button, which is represented by the symbol 'fx' and is located immediately to the left of the 'Formula Bar.' This will launch a separate window in which you may choose the appropriate...
How to Unprotect Specific Areas in Excel
1. Launch Microsoft Excel 2010 and open the spreadsheet that's protected.2. Click the 'Review' tab on the toolbar and click 'Unprotect Sheet' from the 'Changes' group. Enter the password if prompted.3. Highlight the cell or cells that are to become unprotected.4. Hold 'CTRL' and 'Shift' and press the letter 'F' on the keyboard and then release all of the keys to bring up the 'Format Cells' dialog box.5. Click the 'Protection' tab and clear the check from the 'Locked' check box. Click 'OK' to save the changes. Repeat for additional cells or ranges as necessary.6. Click the 'Review'...
How to Create Percentages in Microsoft Excel 2003
1. Write out your fraction. The numerator, or top number, will be the amount you want to determine as a percent of the total. The denominator, or bottom number, will be the total amount. For example, if you have 18 marbles, five red and 13 green, and you want to determine the percent of green marbles, then 13 is the numerator and 18 the denominator.2. Type the numerator in cell A1 of your Excel spreadsheet. Type the denominator in cell B1. Using our example, you would type 13 in cell A1 and 18 in cell B1.3. Type the following equation in cell C1 to get a percentage from your equation:=...
How Do I Print Out Row Numbers for My Excel Spreadsheet?
Microsoft Office Excel 20071. Select the worksheet whose row numbers you want to print. If you want to have row numbers print on multiple worksheets, you must repeat the process for each worksheet.2. Click 'Page Layout' from the options across the top of the screen.3. Locate the 'Sheet Options' subgroup, which will be the fourth subgroup from the left.4. Click the box next to 'Print' under 'Headings' to turn on the row and column titles for printing for the worksheet.Microsoft Office Excel 20035. Select the worksheet whose row numbers you want to print. If you want to have row numbers...
How to Use the CORREL Function in Microsoft Excel
1. Start Microsoft Excel. You can do this by clicking on Start, highlighting Programs, and clicking Microsoft Excel, or double-clicking the Microsoft Excel icon on your computer's desktop.2. Before we work with data, it's important to understand an important fact about the correlation coefficient, the value that represents the strength of the relationship between two random variables. The correlation coefficient ranges from -1 to 1, with -1 indicating a perfect negative correlation and 1 indicating a perfect positive correlation.3. Enter the data. I'll use cells A1 to A25 and B1 to...
How to Multiply Using Excel 2007
1. Determine the cell references that will be multiplied together. The cell reference refers to the labels on the columns and rows where the cell is located and will include a letter and a number.2. Choose the cell where the multiplication results will be returned by clicking within that cell.3. Click in the Formula Bar (denoted by 'Fx' at the top of the screen). Type = , then the cell reference of the first cell, * and finally the cell reference of the second cell. A correct formula will appear as: =G10*X10, according to Home Learn.4. Press 'Enter' on the keyboard to multiply the...
Saturday, November 17, 2012
How to Center Numbers in a Cell in Excel
1. Select the cell with the numbers you want to center.2. Click the 'Home' tab.3. Click the 'Center' button, located in the Alignment secti...
How to Remove Duplicate Rows From an Excel Spreadsheet
1. Click on the 'File' menu and then the 'Open' option to open the spreadsheet with the duplicate rows. The example highlights the duplicate rows for easier viewing.2. Select the entire spreadsheet by clicking on the top left cell of the column header and then scrolling to the last row. Press the 'Shift' key and click on the lowest right cell with information. The rows are highlighted.3. Click on the 'Data' menu, 'Filter' and then 'Advanced Filter.' The Advanced Filter dialog box appears.4. Choose 'Filter the List, In Place' and 'Unique Records Only.' Then click the 'OK' button. Excel...
How to Install Speech in Office Excel
1. Click the Windows 'Start' menu. Click 'Control Panel' and select 'Add or Remove Programs.' The 'Add or Remove Programs' screen will appear.2. Click on 'Microsoft Office' and click the 'Change' button. Select 'Add or Remove Features' and click 'Next.' Double-click 'Office Shared Features.'3. Double-click 'Alternative User Input' and select 'Speech.' Click the down arrow next to 'Speech' and select 'Run from my computer.' Elect to update Microsoft Office. The installation of speech recognition is complete after the update finishes.4. Open Microsoft Excel. Click the 'Tools' menu button....
Friday, November 16, 2012
How to Calculate the Percentage Change in Two Numbers in Excel
1. Find the beginning number and the ending number. For example, assume a business has income of $700 in 2009 and $1,300 in 2010.2. Type the beginning number in cell A1 of your Microsoft Excel page. In the example, type '700' in cell A1.3. Type the ending number in cell A2. In the example, type '1,300' in cell A2.4. Type '=((A2-A1)/A1)' in cell A3. This calculates the percent change. In the example, your results should be 0.857. You can convert this to a percentage by formatting the number as a percentage using the tool b...
How to Learn Descriptive Statistics Using MS Excel 2007
1. Define variability in data using the range, variance and standard deviation functions. In MS Excel 2007, use the Data Analysis Tool under the Data Tab in the top navigation bar. If the option is not available, install the Excel Analysis Toolpack using the MS Office Button. First select Excel Options, then Add-ins, then select Analysis Took Pac, click Go, then OK. Once installed, select the Data tab, then Data Analysis, then Descriptive Statistics; click on the input field and highlight the data. Then check the summary statistics checkbox and click OK.2. Construct a histogram for analysis...
How to View the Contents of a Cell in Excel 2003
1. Double-click the Excel file that you want to work with to open it in Excel 2003.2. Click on the cell that you want to see the contents of. If the cell is hidden behind a window, you can also navigate to it by clicking any cell and then using the arrow keys to move the selection to your desired cell. Finally, you can also click on the box just above the 'A' column and type in the column and row of the desired cell.3. Look at the formula bar, which starts just above the 'C' column, to see the contents of the ce...
How to Make a Number Line in Excel
1. Open the Excel spreadsheet that needs to have a number line. Click the 'Insert' tab at the top of the window.2. Click the 'Shapes' button inside the 'Illustrations' heading. Select the image of a line with an arrow at either end inside the 'Lines' heading.3. Click the bottom line of the cell that needs to be the far left end of the number line. Drag across to the last cell that needs to the far right end of the number line. For example, click the bottom line of 'D6' and drag across to the end of the 'N6' cell to make a number line that spans from the 'D' column to the 'N' column of row...
Thursday, November 15, 2012
How to Make Excel Accept 20 Digit Numbers
1. Right-click on the cell in which you want the 20-digit number to appear. Use shift or control to select multiple cells first, if multiple cells will be accepting 20-digit numbers.2. Click on 'Format Cells...'3. Choose 'Text' and click 'OK' to exit.4. Paste or type the 20-digit number into the cell. Every digit will remain unchang...
How to Copy Formulas Without Changing Cell References in Excel
1. Click the cell containing the formula that you would like to copy, then use the mouse pointer to highlight all of the text in the formula bar (the bar with 'fx' on the left side) at the top of the screen. Alternatively, press the 'F2' key to display the formula in the cell itself, then highlight it with the mouse pointer.2. Press the 'Ctrl' and 'C' keys simultaneously to highlight the copied text.3. Press the 'Escape' key to take Excel out of the formula editing mode.4. Click the cell that you would like to paste the formula into.5. Press the 'Ctrl' and 'V' keys simultaneously to...
How to Calculate Compound Interest in Excel
1. Create a new blank Excel document by clicking on the 'File' menu and selecting 'New.'2. Enter a column heading corresponding to the following values in the first row of your document starting in column A.Column - HeadingA - Amount InvestedB - Annual Percentage RateC - # Times Compounded AnnuallyD - # of YearsF - Future Value3. Enter the desired values for calculation in row 2 starting in column A. Example values are listed below for each column. This represents $1,000 compounded quarterly at a rate of 2.25% for 10 years.A - 1000B - .0225C - 4D - 104. Enter the following function in...
How to Enter Formulas in Excel to Show Not Less Than Zero
Hide Negative Values With Conditional Formatting1. Select the cell(s) in your Excel spreadsheet you wish to format.2. Click “Conditional Formatting” under the “Format” menu.3. Select “Cell value is” from the first drop-down menu for Condition 1.4. Select “less than or equal to” from the second drop-down menu.5. Enter 0 in the next box.6. Click on the Format button and select white in the color drop-down menu. If the background color of your cells is something other than white, select a color that will blend in and make it appear as if the cell is empty.7. Click OK. Any cells you...
How to Create a One Way ANOVA in Excel
1. Open the Excel 2010 file where you want to create your one way ANOVA. Enter your data sets into the Excel cells. Separate your data sets by columns with the top cell in each column describing the set.2. Click the 'File' tab at the top of the screen. Choose 'Options' from the list that appears on the left side of the screen. Select 'Add-Ins' from the left side of the window that appears. Click 'Go' at the bottom of the window.3. Place a check mark next to 'Analysis ToolPak' and click 'OK.'4. Click the 'Data' tab at the top of the Excel window. Find the 'Analysis' area and click the 'Data...
Tuesday, November 13, 2012
How to Remove Extra Rows in Excel 2003
1. Open Excel 2003. Click the 'File' menu and select 'Open'. Locate the spreadsheet with the extra rows and double-click its file name.2. Press and hold down the 'Ctrl' key on the keyboard. Click once on each row number, in the leftmost column, to delete.3. Right-click any of the highlighted rows. Select 'Delete Row'. The rows are deleted and the rest of the spreadsheet bumps up to replace those ro...
How to Use Excel 2007
1. Enter text or numbers into a cell by clicking in the cell, typing the desired text, and press 'Enter.' Press 'Tab' to move to the next cell.2. To insert a row of cells into your spreadsheet, select where you wish your new row to be, click the Home tab and the 'Insert' button, and then click 'Insert Sheet Row.' Create a new column by clicking 'Insert Sheet Column' under 'Insert.'3. To merge multiple cells together, either vertically or horizontally, select the cells you wish to merge, and click 'Merge Cells,' which appears under the 'Merge and Center' button in the Alignment group under...
How to Enter Dates in SUMIF
1. Open the Microsoft Excel 2010 spreadsheet where you want to create your SUMIF formula.2. Click on the cell where you want to create your formula. Enter the following into the cell, without quotes: '=SUMIF(A1:A10,'. Change 'A1' to the first cell in the column of dates that you are searching through, and 'A10' to the last cell in that column.3. Enter the following formula, without quotes, after the comma in your SUMIF formula: 'DATE(2011,x,y),'. Change '2011' to your desired year, 'x' to your desired month and 'y' to your desired day. The DATE function will ensure that your spreadsheet...
How to Construct Yield Curves in Excel 2007
Preparation1. Identify yield data for the construction of the yield curve. This data requires clear yield information associated with time factors. Yahoo! Finance provides yield data as part of its free service for sharing bond information.2. Open Excel 2007.3. Create a new blank worksheet. Press the 'New' button at the top of the program window, or choose the 'File' menu and the 'New' option.Import Yield Data4. Type or import the yield information into a new spreadsheet in Excel 2007. If using Yahoo! Finance, Excel 2007 can pull this information directly from the website. Click the 'Data'...
How to Disable Scroll Lock in Excel 2007
1. Click the Windows 'Start' menu.2. Click 'Programs' and click 'Microsoft Office.' Click 'Microsoft Excel' to open Excel.3. Press the 'ScrLk' or 'Scroll Lock' button on your keyboard. The abbreviation 'SCRL' will appear in the lower-right corner of Excel if scroll lock is turned on and will disappear when it is turned o...
Monday, November 12, 2012
How to Enter Sum Formulas into Multiple Cells in Microsoft Excel 2003
1. Select and activate an empty cell. Do this by left-clicking on that cell; you will also need at least two cells that contain data to be summed.2. Enter the sum formula perquisites into the cell you have selected. Your first part of the formula should read as: =Sum(.3. Highlight cells you wish to include in the sum formula. These cells will appear in a blue formula box.4. After highlighting the desired cells to be included in the sum formula, press the enter button to implement this new formu...
How to Make a Date Change Color After Expiraton in Excel
1. Open Excel 2007 and select a workbook. Click the 'Office' button and select 'Open.' Browse your files and locate the workbook. Double click the workbook name. The workbook opens.2. Highlight a range of cells that contains dates. Select the 'Home' tab and click 'Conditional Formatting.' Select 'New Rule.' Select 'Format only cells that contain.' In the Edit the Rule Description field, select 'Cell Value' and 'greater than.' In the next field, enter your expiration date.3. Click 'Format' and assign a format to cells that match this condition. To change the color of the cell, modify the...
How to Delete an Objects Worksheet in Excel Download
1. Double-click the Microsoft Excel file you downloaded. The file will open in the Excel program window.2. Locate the 'Objects' worksheet. This will be presented as a tab at the bottom of the Excel window. The tab will contain a clear label called 'Objects'. A worksheet labeled 'Objects' may contain a variety of different content, depending on the intended use of the Excel file. Microsoft uses the 'Objects' term to refer to any integrated content based on another Office application. The 'Objects' worksheet could thus contain Microsoft Word text, or a PowerPoint presentation, displayed within...
Sunday, November 11, 2012
How to Put Cells in a Microsoft Excel Header
1. Open your Excel spreadsheet. Type the data in the uppermost cells of the spreadsheet. For example, type 'test' in cells A1 and D1.2. Click the 'Page Layout' tab. Click on the square with the arrow on the 'Page Setup' panel to see additional options.3. Click the 'Header/Footer' tab, and then select the header to use from the 'Header:' drop-down box, or press the 'Custom Header' button and type your preferred header.4. Click the 'Margins' tab, and adjust how far the header will be from the top of the page. Press the up or down arrow buttons beside the 'Header' b...
How to Create a Button Object in Excel Spreadsheet
1. Open Excel. Create a new spreadsheet or use an existing sheet.2. Click the 'Insert' menu at the top of the Excel program window. Choose the 'Object' command. If the 'Object' command is not listed, the menu is automatically collapsed to show only the most frequently-used features. Click the double arrow at the bottom of the menu to expand and show all features. A pop-up window will appear after the 'Object' command is chosen.3. Click the 'Create New' tab at the top of the 'Object' window if you wish to insert a blank object into the Excel spreadsheet. The object can be edited later, if...
How to Make a Combo Box in MS Word
1. Open a Word document. Click the “Microsoft Office” button and select “Word Options.” Choose “Show developer tab.” Click “OK.”2. Click the “Developer” tab on the Word menu ribbon. Click “Design Mode” in the 'Controls' section. Click “OK” to enable macros.3. Select the area on the document where the combo box will be placed and click the “Combo Box” icon in the Controls section. A gray box will appear on the document that reads “Choose an item.” This will be your combo box. Click on the words “Choose an item” and type in user instructions for the combo box. Click outside of the box when...
How to Link Two Excel Spreadsheets
Create a Document with Multiple Spreadsheets1. Create and name the first spreadsheet. At the bottom of the worksheet, right-click on the first tab (Sheet 1) and select 'Rename.' Type a new name. Example: Feb26.2. Create and name the second spreadsheet. At the bottom of the worksheet, right-click on the second tab (Sheet 2) and select 'Rename.' Type a new name. Example: Feb27.3. Make sure you are in spreadsheet Feb27. Enter numeric data in A1 and B1. In cell A1, type the number 2. Then in cell B1, type the number 3.4. Enter a formula in cell C1 on the Feb27 spreadsheet. Click in the cell...
How to Change the Name Order From First to Last in Excel
1. Open your list of names in Excel. The list of names should be in column A.2. Enter the following formula in column B1:=RIGHT(A1,LEN(A1)-FIND(' ',A1))Note that there is a space between the quotation marks in the find function.3. Enter the following formula in column C1:=LEFT(A1,LEN(A1)-LEN(B1)-1)4. Enter the following formula in column D1:=CONCATENATE(B1,', ',C1)5. Copy the contents of cells B1, C1 and D1 down for as many rows as you have names. For example, if your name list goes to row 200, make sure you copy the contents of cells B1, C1 and D1 down through B200, C200 and D2...
How to Do Fractions in Microsoft Word
1. Place the cursor in the document where you would like to insert a fraction.2. Click the 'Insert' tab above the Ribbon. Notice that the options in the Ribbon change.3. Click the 'Equation' button in the Ribbon. New options will appear.4. Select 'Fraction' from the Structures section.5. Choose the desired fraction type from the resulting drop-down menu. An equation box will appear where your cursor is.6. Type the fraction's denominator and numerator into the equation box. Click outside of the box when finish...
How to Split a Cell in Excel 2007
1. Open the Excel document that has the cell you need to change.2. Click the 'Home' tab in the Office ribbon at the top of the screen.3. Click on the merged cell you want to split. The button labeled 'Merge Center' in the alignment group is highlighted in orange by default, indicating that you've selected a merged cell.4. Click the 'Merge Center' button to split the cell into separate cel...
How to Unprotect an Excel Spreadsheet
1. Open the Excel workbook with the worksheet you want to unprotect.2. Right-click on the worksheet's tab at the bottom of the window.3. Select 'Unprotect sheet.'4. Enter the password, if applicable, and press 'Ente...
Subscribe to:
Posts (Atom)