How to Insert a Dynamic Date and Time in Excel

1. Start Microsoft Excel 2007, and open an existing spreadsheet from your files that you want to insert a dynamic date and time into. Or, start a new, blank spreadsheet.
2. Click to select the cell into which you want to insert the dynamic date and time. The cell will be outlined in a thick, black line indicating it is selected.
3. Use your keyboard to type '=now()' (without the quotation marks) into the selected cell. This is the formula that is used to instruct Excel 2007 to insert the dynamic date and time.
4. Press the 'Enter' key on your keyboard to enter the formula into the selected cell. You will now see the current date and time appear in the cell you typed the formula into. This date and time will update every time the 'Enter' key is pressed while working in Microsoft Excel.
5. Repeat Steps 2 through 4 above to insert the dynamic date and time into any other cells inside the open spreadsheet you would like to display the current date and time.

Read more ►

How to Convert a Word Document to a CSV File

1. Open the Microsoft Word document in Word and save it as a '.txt' file. To do this, select 'File' and then chose 'Save As.' Next, use the down arrow next to 'File as Type' and select '.txt.'
2. Open the Microsoft Word document in MS Excel by selecting 'File' and then 'Open.' Find the file in the 'Look in' directory from within the 'Open' dialog box.
3. Click option 'Delimited' and then click '1' beside 'Start Import at Row' to indicate the first row to import the data. Next, select the geographical location of the original file format beside 'File Origin.' When done, click 'Next.'
4. Click 'Tab' under Delimiter preference and then click 'Next.' Additional options include 'Semicolon,' 'Comma,' 'Space' and 'Other' for you to customize the separating character type.
5. Click 'General' as the format option for the 'Column Data 'and then click 'Finish.' Other column data formats include 'Date,' 'Date' and 'Do not import column (skip).'
6. Select 'File' and then choose 'Save As' from the toolbar menu.
7. Choose '.csv' as the 'Save as Type' and then click 'Save.'

Read more ►

How to Convert Word to Excel 2003

1. Open the Word document with the data you want to convert to Excel 2003.
2. Highlight the data with your mouse. Choose 'Convert Text to Table' from the 'Insert' menu and convert the text into a table if it is not already.
3. Hover your mouse over the table until you see a ' ' appear in the upper-left corner. Click on the ' ' sign to select the entire table.
4. Click 'Edit' and then 'Copy.'
5. Launch Excel 2003 and click into a blank cell.
6. Click 'Edit' and then 'Paste.' Your data will appear within Excel.
7. Click 'File' 'Save As' and choose 'Excel Workbook (.xls)' from the 'Save as Type' drop-down field. Click 'Save.'

Read more ►

How to Change the Axis on Excel 2007

Swap X and Y Axes
1. Open the Excel file that contains the chart you want to manipulate.
2. Right-click anywhere within the chart itself. Choose 'Select Data' from the pop-up menu. A small data window will appear on the screen.
3. Click the 'Switch Row/Column' button in the middle of the window. Click 'OK' to confirm your changes. Your X and Y axes will now be swapped on the graph.
Alter an Individual Axis
4. Open the Excel 2007 file that holds the chart you want to change.
5. Select one of the cells that contain the information used in the axis you want to alter. Press 'Delete' to remove any incorrect information and type in whatever you want to replace it. The Excel chart will update as you type.
6. Click anywhere within the chart and click the 'Design' tab at the top of the screen. Press the 'Select Data' button on the left side of the ribbon. Press the 'Edit' button under the 'Horizontal (Category) Axis Labels' area to select a new set of cells to make up the horizontal axis. Click and hold on the first cell then drag the mouse to the last cell and release the button. If you want to remove an individual label from the axis you will first need to press the 'Switch Row/Column' button to get the X-axis items on the left side of the screen. Select the item and choose 'Remove.' Then press the 'Switch...' button again. Click 'OK' to close the window.
7. Right-click on any piece of text in the horizontal axis. Choose 'Format Axis' from the pop-up menu. A small window will appear on the screen. Click and drag the top of the window to the side of your chart so that you can see your changes as you make them.
8. Make changes to how the chart displays the tick marks in the first two sections of this window. You can also alter the 'Axis Labels' to move the labels around the chart or remove them entirely. At the bottom of the window you can alter how the two axes intersect. Click on any of the six other options on the left side of the window like 'Number,' 'Line Fill' or 'Line Style' to alter how the text appears on the axis. Click 'Close' when you are done.
9. Right-click on any text on the vertical axis and choose 'Format' axis from the menu. You can change the way that the numbers are displayed at the top of the new screen that appears. Near the middle of the screen you can alter the tick marks and axis labels and near the bottom you can change how the two axes intersect. This menu also contains an additional six settings on the left that will affect how the axis label text appears. Click 'Close' when you are done.

Read more ►

How to Recover an Excel 2007 File

After an Excel Crash
1. Restart Microsoft Excel 2007. You may also need to restart your computer if you had a system crash or power outage. The document recovery task pane should automatically open on the left side of the screen.
2. Scroll through the documents in the 'Available Files' list. Excel will try to recover up to three versions of the document you were most recently working on.
3. Select a file from the list. Click the down-arrow icon.
4. Click 'Open' to view the recovered document. If you know you want to keep the file, click 'Save as' to rename it. Click 'Delete' if you want to delete the particular file. Save the recovered file that is most useful.
Avoid Losing Data
5. Open Microsoft Excel 2007.
6. Click the 'Microsoft Office Button.'
7. Click 'Excel Options.'
8. Click the 'Save' link.
9. Select 'Save AutoRecover Information Every x Minutes.' Enter the number of minutes in the 'Minutes' list. This will be how often Excel will automatically save your work and program state.

Read more ►

How to Merge Data From Two Spreadsheets

1. Open Excel 2010 and locate the workbook containing the worksheets that will be merged. Click the 'File' tab and select the 'Open' icon. Find the workbook and double-click it.
2. Click in the next blank worksheet in the workbook. Select the 'Data' tab. Click 'Consolidate.' The Consolidate dialog box opens.
3. Select the function you will use to merge the data. If you are adding the merged values, select 'Sum.' Click the red box in the reference section.
4. Click the worksheet that contains the first set of data that will be merged. Highlight the range and click the 'Add' button. Select the worksheet containing the second set of data that will be merged. Highlight the range and click the 'Add' button.
5. Select the option that displays the location of the row or column headers in this merged data. Select either 'Top Row,' 'Left Column' or both. Click 'OK.' The data is merged in the new worksheet.

Read more ►

How to Define Cell Ranges in Excel

1. Enter Microsoft Excel and open a worksheet.
2. Select the range of cells (or even the nonadjacent cells) that you want to name.
3. Locate the name box at the top-left of the formula bar, just above the row and column headings.
4. Click in the box and type the name you want for the cell range.
5. Press Enter to accept the name.
6. Use the name in formulas you create.

Read more ►

How to Disable a Date Autofill in Excel

Disable the AutoComplete Option
1. Open the Excel file.
2. Click the 'File' tab on the command ribbon. A list of basic commands appears.
3. Click 'Options.' The 'Excel Options' window appears. The left pane includes the 'Advanced' command.
4. Click 'Advanced.' A list of editing options appears.
5. Clear the check box for 'Enable AutoComplete for cell values.'
6. Click 'OK.' This button is located at the bottom of the dialog window. The 'AutoComplete' command no longer copies the cell data to new cells. The worksheet is open for editing.
Disable the AutoFill Option
7. Open the Excel file.
8. Click the 'File' tab on the command ribbon.
9. Click 'Options.' A list of basic commands appears.
10. Click 'Advanced.' A list of editing options appears.
11. Clear the check box for 'Enable fill handle and cell drag-and-drop.'
12. Select the check box for 'Alert before overwriting cells.' This text may appear faint.
13. Click 'OK.' The worksheet opens. The fill handle does not activate in the corner of the cell.

Read more ►

How do I Create Mailing Labels in MS Word From an MS Excel Spreadsheet?

Prepare the Mailing List
1. Open a new spreadsheet and use the first row to create column headers across the top of the document. Name the top cell of each column to correspond with the address fields on your labels, for example: 'First Name,' 'Last Name,' and so on.
2. Start in the first cell on the second row and enter the data that corresponds with the cell header. For example, enter the recipient's first name in the row under the 'First Name' label. Continue until you have entered all of your mail recipients and save your document.
3. Highlight all of the data in the mailing list. Single-click on the first cell at the beginning of the first row of your address list. Scroll to the last cell, on the last row of your address list, hold down the 'shift' key and single-click on the last cell.
4. Click on the 'Formulas' tab, select the 'Define Names' group and click 'Define Name.' Type a name for your list and click 'OK.'
5. Save and close the Excel document.
Prepare the Label Document
6. Launch Microsoft Word to open a new document.
7. Click on the 'Mailings' tab and select the 'Start Mail Merge' group. Then click 'Start Mail Merge' and select 'Labels.' In Word 2010, select 'Start Mail Merge' from the 'Mailings' tab and select 'Labels.'
8. Select the type of printer, label vendor and type of labels. For example, if you are using an ink-jet printer to print Avery 15160 address labels, select 'Page Printers,' followed by 'Avery' from the 'Label Vendors' drop down, then scroll down and click on the correct product number.
9. Click 'OK' to have word create a blank label document.
Link the Labels to the Excel Document
10. Click the Microsoft Office Button in the upper left corner of the Microsoft Word screen. In Word 2010, click on 'File' and select 'Options.'
11. Select 'Advanced' and scroll to the 'General' section. Put a check in the box next to 'Confirm File Format Conversion on Open' and click 'OK.'
12. Click on the 'Mailings' tab and select the 'Start Mail Merge' group. Then click 'Select Recipients.' In Word 2010, select the 'Mailings' tab and click 'Select Recipients.'
13. Select 'Use Existing List' from the list of options. Navigate to the location of the Excel file, and double-click the file.
14. Highlight the name of the mailing list and click 'OK.' If prompted, select 'MS Excel Worksheets via DDE (*.xls)' and click 'OK.' All of the labels, except the first, should now say
>.
Format and Merge the Labels
15. Put your cursor in the first label field. Go to the 'Mailings' tab and click the down arrow next to 'Insert Merge Field.' Add each address field to the first label with proper formatting. For example:«first_name» «last_name»«address»«city», «state» «zip»
16. Click the 'Update Labels' button, to the right of the 'Insert Merge Fields' drop-down, to copy the address fields to the rest of the label template.
17. Click 'Preview Results' to view your labels.
18. Save your label template. Then click 'Finish and Merge.' Select 'Edit Individual Documents,' 'All,' and click 'OK.'
19. Save and print your new labels.

Read more ►

How to Subtract Using Excel 2007

1. Double-click the Excel 2007 icon on your desktop or in your 'Programs' list to open the program to a blank worksheet.
2. Enter the numbers you want to subtract in separate cells in the spreadsheet.You can select any cells you would like, but it's usually convenient to place the numbers next to one another either horizontally, in two separate columns, or vertically, in two separate rows.If you want to work with data from an existing spreadsheet, open that file to begin working on it.
3. Enter a subtraction formula in a blank cell. The formula is an equal sign, followed by the first cell reference minus the second cell reference.For example, if your two numbers are in cells A1 and A2, then use a blank cell to enter the formula:=A1-A2
4. Click on another blank cell to activate the formula you just entered. The text for the formula will disappear, and the subtraction amount will appear in its place.For example, if cell A1 contains 100 and A2 contains 25, then the cell with the formula will display 75, since 100 - 25 = 75.

Read more ►

How to Fill Cells With Colors in Microsoft Excel 2003

1. Select the cell that you wish to fill. You will need to left-click on the cell that you wish to fill with color in order to activate that cell.
2. Access the color-fill palette. The color-fill palette is located on the command bar and looks like an icon of a paint bucket spilling out paint. Simply left-click on this icon and a color palette will open.
3. Select a fill color. Once the color palette is open, just click on the desired color.
4. Fill the cell with the desired color. Once you click on the desired color, the cell will automatically fill with that color. You can easily change the color by following the above steps.

Read more ►

How to Divide a Cell in Two

1. Launch Microsoft Excel. Double-click the name of the document you want to edit on your hard drive to open it in Microsoft Excel.
2. Insert a blank column next to the cell or column of cells you want to split. Highlight your cell by clicking on it (or the whole column by clicking on the column heading) and hold down the 'Alt,' 'I' and 'C' keys at the same time to insert a new column.
3. Open the 'Convert Text to Columns Wizard.' In Excel 2003 and earlier versions, drop-down the 'Data' menu and select 'Convert Text Into Columns.' In Excel 2007 and 2010, navigate to the 'Data' tab and click the 'Text to Columns' button.
4. Divide your cell or cells in two. Choose either 'Delimited' or 'Fixed Width,' depending on whether or not a comma (or other character) or a space separates the data you want to split, respectively. Click 'Next,' keeping in mind that you'll need to enter whichever character you used to separate your data on the next screen if you selected 'Delimited.' Click 'Finish.' Your cell (or column) is now divided in two.

Read more ►

How to Speed Up Excel 2007 Calculations

1. Open Excel. Click on the 'Formulas' tab at the top of the spreadsheet, which is between 'Page Layout' and 'Data.' Click on the 'Calculation Options' button that appears to the right; a drop-down menu appears. You will see that the 'Automatic' option is checked.
2. Select the 'Manual' option from the drop-down menu in order to disable automatic recalculations of all cells whenever a change is made to one. Now Excel will only recalculate when you explicitly tell it to do so. Alternatively, you may choose the option 'Automatic Except for Data Tables,' which will automatically make changes to all cells that are directly affected by a cell change except for those in data tables. This will prove faster than the 'Automatic' option, but slower than the 'Manual' option.
3. Click on the 'Options' button at the very top of Excel. From the drop-down menu, select the 'Excel Options' button at the very bottom. A new menu appears. Hit the button called 'Formulas.' More options appear to the right. Under the heading 'Calculation Options,' you will see that 'Automatic' is checked again. Click the 'Manual' bubble in order to enable this feature for Excel more generally. Another box that says 'Recalculate workbook before saving' is also checked. Uncheck this box so that Excel does not automatically calculate every time you save.
4. Go back to the 'Excel Options' menu and select 'Advanced.' From here, go to 'Formulas' and then look for an option called 'Enable multi-threaded calculations.' Check this box and then adjust the number of processors that you want your computer to dedicate to performing Excel calculations. More processors will increase the speed at which Excel calculates. Note that increasing this number will slow down other applications that your computer is running.

Read more ►

How to Turn Off AutoCorrect in Excel

1. Open the Excel file in which you want to disable AutoCorrect. Access the AutoCorrect Options dialog. In Excel 2007 or later, click the 'Office' button in the top left, then 'Excel Options,' then 'Proofing' and then 'AutoCorrect Options.' In earlier versions of Excel, click the 'Tools' menu, then 'AutoCorrect Options.'
2. Uncheck the box next to whatever AutoCorrect features you want to disable. To disable AutoCorrect entirely, uncheck every box.
3. Click 'OK' to finalize the changes and disable AutoCorrect.

Read more ►

Microsoft Excel: How to Remove a Drop

1. Left-click on the Office ribbon button and click on the 'Excel Options' button.
2. Select “Popular” in the Excel options box and then check the “Show the developer tab in the Ribbon” box
3. Click the “Review” tab and make sure the spreadsheet is an “Unprotected Sheet.”
4. Select “Design Mode” in the “Developer” tab.
5. Right-click on the drop-down box and select “Delete.”

Read more ►