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...
Browse » Home » All posts
Tuesday, November 13, 2012
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)