How to Open Word or Excel in a Specific Program

Open an Excel Document in Another Specific Program
1. Start Microsoft Excel.
2. Click the 'File' tab and then click 'Options' under 'Help.'
3. Click 'Save,' then click 'Save files in this format.' Under 'Save Workbooks,' select a default format from the list and then click 'Save.'
4. Start the specific program and then open your file with the new default format.
Save and Then Open a Word Document in Another Specific Program
5. Start Microsoft Word, click the 'File' tab and then click 'Open.'
6. Click 'OpenDocument Text' from the 'File of type' list.
7. Select the Word file you want to open in another specific program and then click 'Open.'
8. Click the 'File' tab and then 'OpenDocument Text' from the 'Save as type' list.
9. Type in a name for your file and then click 'Save.'
10. Start the specific program you want to use and then open your file.
Link an Excel Worksheet or Word document in Another Specfic Program
11. Start either Microsoft Excel or Microsoft Word as well as the specific program to which you want to link the data. (Note: These steps apply to Microsoft Office 2010 programs.)
12. Select the data from either Excel or Word that you want to create a link from and then press and hold 'CTRL C.'
13. Go to the specific program and then click on the area where you want the Excel or Word file link to appear.
14. Click the arrow for 'Paste' from the 'Home' tab's 'Clipboard' group, then click 'Paste Special.'
15. Select 'Microsoft Office Excel object' from the 'As' list and then click 'Paste link.' (Note: Alternately, you can click 'Paste' to embed the object as static, which will not be automatically updated.)

Read more ►

How to Add a Pointer to Table in Excel 2007

1. Open the Excel file that contains the table to which you want to add the pointer.
2. Click the 'Insert' tab on the Excel Ribbon.
3. Click the 'Shapes' button. Click one of the arrow icons in the 'Lines' section to select it.
4. Click and drag your mouse from a space on your Excel worksheet to the cell in the table to which you want the arrow to point.
5. Click and drag the pointer's circular resize handles to resize the arrow to an appropriate length. Hover over the arrow you inserted with your mouse until a four-way arrow appears. Click and drag the arrow if you want to move or reposition it in the table.
6. Click the 'Format' tab in the 'Drawing Tools' section on the Ribbon. Click the options in the 'Shape Styles' group if you want to add an outline to the pointer, change its thickness and add other effects like a reflection or glow.

Read more ►

How to Create a Check Register in Excel

1. Label columns A through G in the first row, as follows: cleared, date, check #, item description, debit, credit and balance. Highlight columns E, F and G (debit, credit and balance) and right-click to 'Format cells...' and adjust these columns to represent currency. Column B can be adjusted for date format in the same manner.
2. Extend the width of these columns as far as you need by clicking on the right edge of the column and dragging toward the right. For example, the 'item description' column will need to be much longer than the 'cleared' column.
3. Key in your first entry as 'starting balance,' including the date, and enter the balance your check register begins with.
4. Enter in the box below the balance you just entered in Step 3 the following formula: =G2-E3 F3. Hit 'Enter.' That field should now read the same as the balance you keyed in above it.
5. Click on the box you just entered your formula into, and you will see that it is highlighted with a small square at the bottom right-hand corner. Click and hold the small square, dragging the formula down to as many rows as you desire.
6. Take note that all of the balance fields now contain the same amount; however, as you enter in your checking account information, the balance will adjust for you, giving you the new total.
7. Mark an 'X' in the 'cleared' column on any items you know have cleared your bank to balance your check register. Take your most recent bank statement total and add any un-Xed outstanding deposits and subtract any un-Xed outstanding debits. The balance you show on your spreadsheet should equal this calculation.

Read more ►

How to Count Duplicate Value in Excel 2003

1. Double-click the Excel 2003 XLS file on your hard drive. The file loads in the Excel 2003 software for you to edit its content.
2. Click an empty cell in the column directly after your document information. Type the following function in the empty cell:=IF(COUNTIF(A2:A7,A2)>1,1,'')Replace the cell ranges with the cells you want to check for duplicates.
3. Click another empty cell and type '='. This triggers the 'function' feature in Excel. Select 'Sum' from the 'Function Name' drop-down and highlight the column used previously to detect duplicates. Press 'Enter.' The result is the sum of all duplicate records.

Read more ►

How to Remove All Macros in Excel 2007

1. Open up your spreadsheet workbook in Microsoft Excel.
2. Press (ALT) (F11). This will open up the VBA editor.
3. Right-click on the module associated with the macro. You'll find all of the modules that are active in your current spreadsheet in the upper left-hand corner.
4. Select 'Remove Module X,' where 'Module X' will be the name of the module you want to remove. Excel will ask if you would like to export Module X. Click 'No.'
5. Repeat steps three and four until you've removed all of the modules associated with your workbook.

Read more ►

How do I Delete Control From Excel Spreadsheet at Runtime?

1. Click the Office Button, then click 'Excel Options'.
2. Select the 'Popular' category and check the 'Show Developer Tab In The Ribbon' box. Click 'OK'.
3. Open the Developer tab and click 'Design Mode'.
4. Find the control you want to delete. It will be surrounded by a border, either simple and thin, or thick and dotted, depending on whether or not it is an ActiveX control. Click on this border to select the control.
5. Press the 'DELETE' key on your keyboard.

Read more ►

How to Rotate a Worksheet in MS Excel 2003

1. Select the entire table you want to rotate by left clicking at the top, left cell, dragging the mouse down to the bottom, right corner, and releasing.
2. Press 'Ctrl' and 'C' at the same time to copy your table.
3. Select a cell somewhere outside of the table you're rotating. You can even select a cell on a different worksheet entirely.
4. Click the black, down arrow under 'Paste' in the Clipboard section of the Home tab. Select 'Paste Special.'
5. Click the 'Transpose' check box, then click 'OK' to paste the transposed data.

Read more ►

How to Create an Email Distribution Mailing List in Excel

1. Open Microsoft Excel. Start with a new blank document.
2. Type column headers across row one. Your emails created from the distribution list can include any type of personalized information you desire. The most important column that must be included is the actual email address, so be sure one column header says 'Email' or 'Email address' to make this clear. Alternately, you may include first and last names or other information that will be unique for each email.
3. Enter the data for each recipient on a separate row. The first recipient in the email distribution list will be listed on row two, directly under the column headers. Type the email address in the appropriate column and any other information required by your distribution list, such as the recipient's name.
4. Save the Excel document under any file name you choose. Your email distribution list is now complete.

Read more ►

How to Calculate Subtotal

Calculating a Subtotal in a Few Easy Steps
1. Obtain a data set. This means that you need to have a set of numerical values listed. Using the example of a checking account deposit, this would be the checks and/or cash amounts that you need to deposit. Deposit slips have blank boxes for you to fill in these values.
2. Write your values down. For instance, you may have a check for $50.27, a check for $85 and $75 in cash that you wish to deposit. In the section for checks on your deposit slip, you would write 50.27 and 85.00. In the blank section for cash, you would record 75.00.
3. Add your data set. Using a calculator or just old-fashioned math skills, you should total your figures. In this example, you would perform the following operation: 50.27 85.00 75.00 = 210.27. This is your subtotal.
4. Perform any additional mathematical steps to your subtotal. Once you've obtained the subtotal, you may need to complete additional steps. For instance, if you are depositing money, but you want to keep out some of the money, you have to subtract from your subtotal. In this example, assume you want to keep out $15.50 from the deposit. You would subtract this amount from the subtotal, as illustrated with the following equation: 210.27 - 15.50 = 194.77. Your final deposit would be $194.77.

Read more ►

How to Set the Defaults for an Excel Comments Box

Set Excel Comment Defaults in Windows XP
1. Right-click the desktop, avoiding any icons. Select 'Properties' to open the 'Display Properties' dialog box.
2. Go to the 'Appearances' tab. Click the 'Advanced' button to open the 'Advanced Appearance' dialog box.
3. Select 'Tooltip' from the 'Item' list near the bottom of the dialog box.
4. Select the new default color for Excel comments in the 'Color1' box. Choose a default font in the 'Font' box, a font size in the 'Size' box and a font color in the 'Color' box.
5. Click 'OK' to apply the changes. Close any open dialog boxes.
Set Excel Comment Defaults in Windows Vista
6. Right-click the desktop, avoiding any icons. Select 'Personalize' to open the 'Personalize' window.
7. Select 'Windows Color and Appearance.'
8. Click 'Open Classic Appearance Properties for More Color Options' at the bottom of the 'Windows Color and Appearance' window to open the 'Appearance Setting' window.
9. Click the 'Advanced' button to open the 'Advanced Appearance' dialog box. Select 'Tooltip' from the 'Item' list near the bottom of the dialog box.
10. Select the new default color for Excel comments in the 'Color1' box. Choose a default font in the 'Font' box, a font size in the 'Size' box and a font color in the 'Color' box. Click 'OK' to apply the changes. Close any open dialog boxes or windows.
Set Excel Comment Defaults in Windows 7
11. Click the 'Start' button. Type 'Window Colors' into the 'Instant Search' box at the bottom of the Start menu and press 'Enter.' The 'Windows Color and Appearance' window will open.
12. Click 'Advanced Appearance Settings' at the bottom of the window.
13. Select 'Tooltip' from the 'Item' list near the bottom of the dialog box.
14. Select the new default color for Excel comments in the 'Color1' box. Choose a default font in the 'Font' box, a font size in the 'Size' box and a font color in the 'Color' box.
15. Click 'OK' to apply the changes. Close any open dialog boxes or windows.

Read more ►

How to Find Cells With Strikethrough in Excel

1. Open Microsoft Excel. Hold the 'Control' key and press the 'F' key on the keyboard. The combination opens the'Find' function.
2. Click on the 'Format' button in the 'Find and Replace' window. Click on the 'Fonts' tab.
3. Check the 'Strikethrough' checkbox in the 'Effects' section and click the 'OK' button.
4. Click the 'Find all' button in the 'Find and Replace' window.
5. Look at the bottom of the 'Find and Replace' window. All the cells with 'Strikethrough' are listed at the bottom of the window.

Read more ►

How to Convert Hours to Seconds in Excel

1. Open a new workbook in Microsoft Excel.
2. Enter the time in a blank cell such as 6:20:35 in A1.
3. Click on a blank cell and enter the following formula: =(HOUR(cell)*60*60) (MINUTE(cell)*60) SECOND(cell), where cell refers to the cell reference that contains the time. The formula extracts the hour, minutes, and seconds from the time. It multiplies the hours by 60 to convert into minutes, then multiplies by 60 again to get seconds. The minutes are multiplied by 60 to get the seconds, and the seconds are added to the calculation to get the total seconds.For example, the formula =(HOUR(A1)*60*60) (MINUTE(A1)*60) SECOND(A1) would bring back 22,835 seconds.
4. Format the cell as general by right clicking on the cell and selecting the 'General' category in the 'Number' tab of the 'Format Cells' window.

Read more ►

How to Change the Password in Excel

1. Open the Excel spreadsheet you want to edit. If the file already has a password configured, enter the password and click 'OK.'
2. Click 'File' in the main menu toolbar and select 'Save As.' In the window that opens, click the 'Tools' button to open a dialog box for advanced settings.
3. Click 'General Options.' In the text box labeled 'Password to modify,' enter a new password for your Excel file. Press 'OK.'
4. Click 'Save' to save your new password settings. The Excel file saves to the hard drive and the password is modified.

Read more ►

How to Convert Phone Numbers in MS Excel

1. Open Microsoft Excel. Open the file you’d like to work on by going to “File”, then “Open,” or begin a new workbook using the blank workbook that opens by default.
2. Select the cell that has the numbers typed to be converted to a phone number format. If you have multiple cells that need to be converted, select them all by holding the left mouse button and dragging the mouse.
3. Locate the “Format” option on the toolbar and click once. This will bring up a drop-down menu. Click on “Cells” to bring up a formatting box. You can also pres “Ctrl” “1” to bring up the box.
4. Click “Special” on the “format cells” box. This will bring up four options on the right-hand side, click on “Phone Number” and then click “OK.” This will close the box and format the number to the correctly display in phone number format.

Read more ►

How to Remove a Title Chart in Excel 2003

1. Open the Excel 2003 chart that contains the title you wish to delete.
2. Click the chart title once.
3. Hit the 'Delete' key to delete the chart title in Excel 2003.

Read more ►