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 ►

How to Make an Excel Spreadsheet Expire

1. Open Microsoft Excel, go to the “File” menu and choose “Open.” Browse for the Excel file that you want to make expire and double-click the file name to open it.
2. Press “Alt F11” to launch the Visual Basic Editor from Excel. Use either “Ctrl R” to switch to the “Project Explorer” window or go to the “View” menu, point to “Other Windows” and choose “Project Explorer” from the list of options.
3. Right-click “ThisWorkbook” in the “Project Explorer” window. Select “View Code” from the list of available options.
4. Type the code that makes the spreadsheet expire into the code box provided. A proper code format that provides users with a message regarding the expiration date and the number of days left until the spreadsheet expires looks like this:
Sub Auto_Open()\\ Dim exdate As Date \\ exdate = \'12/01/10\' \\ If Date > exdate Then \\ MsgBox (\'Spreadsheet has Expired\') \\ ActiveWorkbook.Close \\ End If \\ MsgBox (\'Workbook Valid Until\' exdate - Date \'Days left\') \\ End Sub
Enter the date that the spreadsheet should expire by “exdate=” and any message you prefer regarding the expired worksheet in the place of “Spreadsheet has Expired.”
5. Return to the open Excel spreadsheet, go to the “File” menu and select “Save” to save the workbook with the new macro attached. Close the workbook and reopen it in Excel. The message you entered into the macro should appear, stating the expiration date of the file and how many days are left until it expires.

Read more ►

How to Calculate Cells in Excel 2007

1. Open Microsoft Excel and create a worksheet with the data you want to calculate. Place your cursor in an empty cell below or beside the column you want to calculate.
2. Select the 'Formula' tab from the Ribbon and click on 'AutoSum' under the 'Function Library' group. To add all the numbers in a column, click on the 'AutoSum' button. Excel 2007 will select the calculated cells on the worksheet for you.
3. Press the 'Enter' key to accept the calculation or manually select the cells you want to calculate, then press the 'Enter' key.
4. Repeat the calculation for additional columns or rows, or copy the formula to your other cells. To copy your calculation to another cell, select the cell with the formula. Then place your mouse just outside the cell (on the bottom-right portion of the cell) until your mouse becomes a plus sign.
5. Drag the cell in the direction of the cells where you want the formula added. The formula will be repeated on those cells.
6. Calculate the average of numbers by placing your cursor in an empty cell and clicking on the arrow for the 'AutoSum' button in the 'Formula' tab. Then click on 'Average.'
7. Use a different formula by clicking on 'More Functions' within 'AutoSum.' Find the formula you need by searching for the function or changing the category and selecting it. The 'Function Arguments' dialog box will open up
8. Click on the button to the right of the dialog box and select the range of values you need. Click on the button again to return to the 'Functions Argument' box. Then press 'OK' when you are finished.

Read more ►

How to Convert Quicken to Excel 2003

1. Open the 'Report' menu from the top of the Quicken window.
2. Select 'Reports and Graph Center.' Choose the information that you want to export to Microsoft Excel. Specify the start date and end date of the information you want to export. Quicken will turn that information into a report that will open on screen.
3. Click the 'Copy' button in the Quicken toolbar. This will copy all of the data contained in your Quicken report to the Windows clipboard.
4. Open Microsoft Excel 2003 on your computer. Select 'New' and 'Blank Spreadsheet' to create a new blank spreadsheet on screen.
5. Use your computer mouse to highlight all of the cells in your Excel 2003 spreadsheet where you want your Quicken information to go. Click the 'Paste' option in the Excel toolbar at the top of the screen to paste all of your information from Quicken into the Excel spreadsheet.

Read more ►

How to Calculate Upper Lower Limits With Excel 2007

1. Select a blank cell where you would like to display the minimum or maximum value. If the range of values is all in one contiguous row or column, select a cell below or to the right of it.
2. Click the arrow next to the 'AutoSum' button in the 'Editing' group on the 'Home' tab of the Excel Ribbon.
3. Select 'Max' if you would like to calculate the maximum value or 'Min' if you would like to calculate the minimum value.
4. Select the data you for which you would like to find the minimum and maximum value. If the numbers are in a contiguous column or row, Excel should select them automatically. If they numbers are not in contiguous columns or rows, click on them one by one while holding down the 'Ctrl' key.
5. Press 'Enter.' Excel will calculate the largest or smallest value in a set of numbers.

Read more ►

How to Buy Microsoft Excel Software

1. Determine the primary functions that you will be using Excel to accomplish. These may include academic, business or other spreadsheet-related matters, such as tracking projects or spending.
2. Choose a version of Excel to purchase based on the functions you will use the software to accomplish. If you intend to conduct extensive spreadsheet analysis or business accounting, then consider purchasing Microsoft Excel 2007 in order to ensure full compatibility with other software products. If you are going to do basic, at-home accounting, then Excel 1997 will fit your needs. Also, if you intend on sharing Excel files with others, Excel 2007 is the only version that supports the Open Office spreadsheet format that can be read by all current spreadsheet programs.
3. Go the Microsoft Office online store listed in the resources section of this article. Note the cost of Microsoft Excel that is listed on the website and compare to the cost listed by other resellers for the same version of Excel. Choose the website that offers you the best price and return policy for the version of Excel you have decided to purchase and and buy the software.

Read more ►

How to Enable VBA in Excel 2003

1. Click the 'Start' button from your desktop and then move your mouse over the 'All Programs' option.
2. Select the 'Microsoft Excel 2003' option from the list of programs. Excel 2003 will then open on your screen.
3. Click the 'Tools' option from the top toolbar menu and then move your mouse over the 'Macro' option.
4. Click the 'Security' option and then select the 'Trusted Publishers' tab from the Security dialog box.
5. Select the 'Trust Access to Visual Basic Project' option and then click the 'OK' button. VBA will then be enabled in Excel 2003.

Read more ►

How to Align Double

1. Go to the 'Insert' tab of the ribbon and click on 'Text Box' in the 'Text' group. Draw a text box onto the worksheet and click on the text box to select it. The 'Drawing Tools' tab appears when the text box is selected. Click on the 'Format' tab under 'Drawing Tools.'
2. Click the dialog launcher button in the bottom right corner of the 'Size' group to open the 'Format Shape' dialog box with the 'Size' tab selected. Clear the 'Lock Aspect Ratio' check box, if it is selected. Change the number in the 'Height' box to '2.' Change the number in the 'Width' box to '3.5' and click the 'Close' button. Drag the text box to the upper left corner of the worksheet.
3. Select the text box. Right-click it and select 'Copy.' Press 'Ctrl V' to paste the copy of the text box. Drag the copied text box to the right of the first one, using the grid lines to align them side by side. Copy and paste six more text boxes, placing three beneath the first box and three beneath the second. Click on cell 'K47' and keep the mouse button depressed. Drag the mouse up to cell 'A1' to select all of the cells containing business cards. Click on cell 'L1.' Press 'Ctrl V' to paste the business cards onto the second page.
4. Press and hold the 'Ctrl' button and click on the four business cards in the first column. Go to the 'Format' tab under 'Drawing Tools.' Click on 'Align' in the 'Arrange' group and choose 'Align Left.' Select the boxes in the second column and repeat the steps, choosing 'Align Right' instead. Align the boxes in the first column of the second page to the left and the final column to the right.
5. Press and hold the 'Ctrl' button and click on the four business cards across the top of the two pages, which should appear side by side. Go to the 'Format' tab under 'Drawing Tools.' Click on 'Align' in the 'Arrange' group and choose 'Align Top.' Repeat for the remaining rows to align all of the cards on both sides.
6. Type the information that you want on the front of the business cards into the text boxes on the first page. Type the data for the backs of the business cards into the text boxes on the second page. Add images by clicking on the 'Insert' tab and selecting 'Picture' to add an image from your computer. Select 'Clip Art' to add a Microsoft clip art image.
7. Press 'Ctrl P' to open the print dialog box. Click the 'Properties' button to open the 'Printer Properties' dialog box. Select the duplex printing option, which will vary depending on your printer. It may be called 'Print on Both Sides,' 'Flip on Long or Short Edge' or something similar. Close the dialog box and print your double-sided business cards.

Read more ►