How to Fix Excel 2007

1. Double-click the Excel 2007 program icon on your desktop to open it or select its name from the list of programs in the Start menu's 'All Programs' list. Click the Excel Office button and select 'Excel Options.' Click 'Advanced' and scroll down to the 'General' section. Click the checkbox to remove the checkmark from 'Ignore other applications that use Dynamic Data Exchange (DDE).' Close Microsoft Excel. Double-click on any saved Excel file to open it and see that the 'There Was a Problem Sending the Command to the Program' error message no longer appears.
2. Open the Excel program. Click the Office button and select 'Excel Options.' Click 'Advanced' and scroll down to the 'Display options for this workbook' section.' Click the 'All' radio button under 'For objects, show' to get rid of the 'Cannot shift objects off sheet' error message when you try to insert or hide rows or columns. Click 'OK.'
3. Open Windows Explorer. Double-click the 'C:' drive to expand its directory. Double-click 'Program Files' or 'Program Files (x86).' Expand the 'Microsoft Office' directory. Expand either the 'Office,' 'Office10' or 'Office12' folders. Double-click the 'Startup' folder to open it. Right-click on 'pdfmaker.dot' and click 'Cut.' Navigate to your 'My Documents' folder. Right-click the folder and select 'Paste.'Repeat the process to remove the 'pdfmaker.xla' file from the 'Xlstart' folder---located in the 'Office' folder under the 'Microsoft Office' directory---and place it into the 'My Documents' folder. Moving these Adobe Acrobat files gets rid of the 'Compile error in hidden module: Autoexec' and 'DistMon' error messages when opening Excel 2007.
4. Open the Control Panel. Go to the 'Add or Remove Programs' section in Windows XP and the 'Uninstall a Program' section in Vista and Windows 7. Click Microsoft Excel or Microsoft Office from the list of programs. Click 'Change.' Select 'Repair' and click 'Continue' to run the 'Detect and Repair' tool to automatically have Microsoft find and repair problems with your Excel program.

Read more ►

What Are Some Practical Uses for Excel?

1. Manage your finances with Excel. Create a personal or family budget and track your income and expenses by month or year. Create a spreadsheet that helps you plan and track your savings for retirement, or for your child's college education. Use Excel's built-in mathematical functions to automatically calculate routine or complex equations.
2. Create a calendar or schedule with Excel. Whether it's a weekly, monthly or yearly calendar for your family; a personal daily appointment planner; or a schedule for managing homework, bill payments, or your favorite sport team's games, Excel makes it easy to organize, filter and search through large amounts of data.
3. Plan and manage a project or event with Excel. Whether you are planning a large work project or a wedding or holiday party, use Excel to keep track of multiple tasks and deadlines, and the schedules of other participants or collaborators--and as a central database of all information and files you need to execute the project or event.
4. Create lists through Excel. Excel's convenient tabular layout makes it easy to format many different types of lists. Create checklists to make traveling and packing easier. Create an emergency phone list for your babysitter. Manage your book, wine or DVD collections via lists. Run your household better by using Excel lists to manage your groceries, chores and holiday gift-giving.
5. Create an address book to manage your mailing labels. Excel's extensive 'filter,' 'sort' and 'search' functions make it easy to create and manage a large contact database. You will be able to find and sort contacts by city, state, street, last name or birthday, or by whatever other criteria and detail you enter. When you need to create mailing labels to send greeting cards or announcements, use Excel's mail-merge feature to quickly format and print out the names and addresses of your contacts.

Read more ►

How to Lock Cells in Microsoft Excel

Microsoft Excel 2007
1. Open the Microsoft Excel 2007 application on your computer. Make sure you have the worksheet with the cells you want to lock open.
2. Select the cells that you want to lock on your worksheet using your mouse. You can also select an entire column or row.
3. Click on the “Home” tab and then click on the “Format” option from the “Cells” group. Click on the “Format Cells” option.
4. Click on the “Protection” tab and then click on the box next to the “Locked” field so that it’s selected. Click on the “OK” button.
5. Click on the “Review” tab and then click on the “Protect Sheet” option from the “Changes” group.
6. Enter a password for your worksheet in the “Password to unprotect sheet” field. Click on the “OK” button, and your cells will be locked.
Microsoft Excel 2003
7. Open the Microsoft Excel 2003 application on your computer. Make sure you have the worksheet with the cells you want to lock open.
8. Use your mouse to select all of the cells in the worksheet that you want locked. Make sure the cells are highlighted.
9. Click on the “Format” option from the top toolbar menu and then click on the “Cells” option.
10. Click on the “Protection” tab and then click on the box next to the “Locked” field so that it’s selected. Click on the “OK” button.
11. Click on the “Tools” option from the top toolbar menu and scroll over the “Protection” option. Click on the “Protect Sheet” option and then click on the “OK” button.

Read more ►

How to Make Merged Cells in Excel 2003 Grow With Wrapped Text

1. Select the cell in which you want the merged text to appear by clicking it.
2. Open the 'Format' menu, select cells from the shortcut menu and when the Format Cells dialog box opens, click on the 'Alignment' tab. The alignment page opens. Go to the Controls section and click the 'wrapped text selection' button. Click 'OK' to close the Format Cells dialog box.
3. Adjust the cell width to the desired size using the 'select and drag' method or the Format Cells dialog box.
4. Begin the merge formula by typing '(=' without quotes in that cell.
5. Click the first cell that contains the wrapped text you want to combine and type ' ' -- be sure to include a space between the two quotation marks if you want the text to be separated by a space.
6. Click the next cell that contains the wrapped text you want to combine with the first cell contents and type ')' to complete the merge formula.
7. Press 'Enter' to view the merged contents in the cell. Make any cell width adjustments desired. Note that the wrapped text positioning will adjust the cell height automatically as you make any column width adjustments.

Read more ►

How to Manually Change the Margins in Excel 2010

1. Open 'Microsoft Excel 2010.'
2. Press 'Ctrl' plus the letter 'O.' Locate and open an Excel spreadsheet that you want to print.
3. Click 'Page Layout' at the top.
4. Click the 'Margins' icon and click 'Custom Margins' at the bottom of the menu. Set custom margin sizes depending on your requirements. Click 'OK.'
5. Press 'Ctrl' and the letter 'P' to open the Print window, which will also show a print preview. If you want to adjust the margins on the page visually, click the 'Show Margins' icon, which is the left-most of two small icons in the bottom-right corner of the Print window. Click and drag the margins on the page to change the page layout. Click 'Print.'

Read more ►

How to Size All Columns to Fit

1. Hold down the Shift key and click on each column you want to size to fit, or click 'Select All' to highlight all columns.
2. Go to 'Format' and select 'Column.'
3. Click 'AutoFit Selection.'

Read more ►

How to Connect Excel Spreadsheets

1. Open the two spreadsheets that you want linked (you should have two open windows).
2. Go to the worksheet you want to import data to and click on a cell that you want the imported data displayed.
3. Type an '=' sign into the formula window (the blank line at the bottom of the toolbar.
4. Navigate to the sheet you want to import the data from and click on the cell with the data. For example, click on cell A1.
5. Go back to the spreadsheet that you want the data imported to. Excel will paste the name of the worksheet and the cell reference into the formula line. Press 'Enter' and the imported total will show in the specified cell.

Read more ►

How to Disable Auto Backup in Excel

1. Click the 'File' tab and then 'Save As.'
2. Click the down arrow next to Tools and click 'General Options.'
3. Un-check the 'Always create backup' box to stop Excel from automatically backing up your files.

Read more ►

Microsoft Excel Visual Basic Tutorial

1. Click on the 'Alt' and 'F11' keys from within any Excel worksheet or workbook to open the Visual Basic Editor (VBE). You can also access the VBE by clicking on the 'Developer' tab and then clicking on 'Visual Basic.'
2. Click on the 'Insert' tab, and then click on 'Module' to open a blank window for your program.
3. Type the word 'Sub' (for subroutine) or 'Function' into the window, followed by the name of your program. For example, 'Sub italics()' is the first line of a subroutine called 'Italics.' If the VBA returns a result such as a number, it's a function. If it performs a task without returning anything, it's a subroutine.
4. Type an apostrophe on a new line, followed by a description of what the program is for. For example: ''this macro italicizes a highlighted cell.'
5. Type the body of your code starting on a new line. For example, to italicize a cell, type:'Selection.Font.Italic = True.'
6. Type 'End Sub' or 'End Function' on a new line, depending on if you defined a Sub or Function in Step 3.
7. Run the code by pressing the 'F5' key.

Read more ►

How to Merge Cells on an Excel Spreadsheet

1. Click the 'Home' tab on the command ribbon.
2. Click and drag to select two or more adjacent cells. A black border surrounds the range of cells. The highlighted cells display one white cell in the upper-left corner and one or more blue cells. Only this white cell retains its data.
3. Click the down-arrow in the 'Merge Center' command in the 'Alignment' group. The three merge options include 'Merge Center,' 'Merge Across' and 'Merge Cells.'
4. Click the preferred merge option. The cells become one larger cell.

Read more ►

How to Create a Table in Excel 2003

1. Open Excel on your computer, and start a new spreadsheet.
2. Enter your data into the spreadsheet. If the table is to be row-oriented, enter the desired calculation formulas to the left and just below the data. If the table is column-oriented, enter the calculation formulas above the first value and in the column immediately to the right of the data. Assistance for understanding formulas is available in the Excel 'Help' section.
3. Go to the 'Data' tab, and select 'Table.'
4. Enter the cell number where the calculated data should appear in the 'Column input cell' field or 'Row input cell' field, depending on the orientation of your table. Click 'OK.'

Read more ►

How to Remove Mass Links in Excel 2007

1. Open the Microsoft Excel 2007 file on your computer that contains the links you want to remove.
2. Enter '1' into a blank cell within your worksheet. Right-click on the cell with your mouse and then click on the 'Copy' option.
3. Hold down the 'CTRL' key on your keyboard and select each link in your worksheet that you want to remove.
4. Click the 'Home' tab. Click the arrow below the 'Paste' field in the 'Clipboard' group. Click the 'Paste Special' option.
5. Click the 'Multiply' option and then click the 'OK' button. Click the 'Home' tab again and then click the 'Cell Styles' option from the 'Styles' group.
6. Select the 'Normal' option below the 'Good, Bad, and Neutral' field and all of the links you selected will be removed.

Read more ►

How do I Add the Microsoft Excel 11.0 Object Library?

1. Insert your Office 2003 disc. The Office 2003 Setup window will open.
2. Select 'Add or Remove Features.' Click 'Next.'
3. Check the 'Choose advanced customization of applications' box. Click 'Next.'
4. Click the plus sign next to 'Microsoft Office Excel.' This expands that section of the applications and tools list.
5. Click the down arrow beside '.NET Programmability Support.' Click 'Run from My Computer.' Click the 'Update' button.

Read more ►

How to Remove Grid Lines

For Excel 2003
1. Select the cells in the spreadsheet from which you want to remove the grid lines. Do this by left-clicking on the mouse and holding it down as you move the cursor over the cells you want to select.
2. Click on the 'Format' menu at top of page.
3. Click 'Cells.'
4. Click on the 'Patterns' tab.
5. Click on the background color of the spreadsheet. In most cases, the color is white.
6. Click on the 'Border' tab.
7. Click on the arrow in the 'Colors' box. Click on the color of the gridlines. In most cases, the color is 25% gray.
8. Click 'Outline.'
9. Click on 'OK.' The grid lines are now gone.
For Excel 2007
10. Open your spreadsheet.
11. Click 'View' on the taskbar.
12. Look for the 'Show/Hide' group.
13. Clear the checkbox near 'Gridlines' to uncheck the box. The gridlines disappear.
For Excel 2010
14. Select your spreadsheet.
15. Click 'File' in the taskbar. Click 'Options.' A dialog box will appear.
16. Click 'Advanced' in the right pane. Scroll to find 'Display Options for this Worksheet,' and click on it.
17. Disable 'Show Gridlines' by clicking on the check box to remove the check. The gridlines disappear.

Read more ►

How to Determine if a File Exists in Excel VBA

1. Copy the following code:Option ExplicitFunction FileOrDirExists(PathName As String) As Boolean'Macro Purpose: Function returns TRUE if the specified file' or folder exists, false if not.'PathName : Supports Windows mapped drives or UNC' : Supports Macintosh paths'File usage : Provide full file path and extension'Folder usage : Provide full folder path' Accepts with/without trailing '\' (Windows)' Accepts with/without trailing ':' (Macintosh)Dim iTemp As Integer'Ignore errors to allow for error evaluationOn Error Resume NextiTemp = GetAttr(PathName)'Check if error exists and set response appropriatelySelect Case Err.NumberCase Is = 0FileOrDirExists = TrueCase ElseFileOrDirExists = FalseEnd Select'Resume error checkingOn Error Goto 0End FunctionSub TestItWithWindows()'Macro Purpose: To test the FileOrDirExists function with Windows'Only included to demonstrate the function. NOT required for normal use!Dim sPath As String'Change your directory heresPath = 'C:\Test.xls''Test if directory or file existsIf FileOrDirExists(sPath) ThenMsgBox sPath ' exists!'ElseMsgBox sPath ' does not exist.'End IfEnd SubSub TestItWithMacintosh()'Macro Purpose: To test the FileOrDirExists function with a Macintosh'Only included to demonstrate the function. NOT required for normal use!Dim sPath As String'Change your directory heresPath = 'HardDriveName:Documents:Test.doc''Test if directory or file existsIf FileOrDirExists(sPath) ThenMsgBox sPath ' exists!'ElseMsgBox sPath ' does not exist.'End IfEnd Sub
2. Open Excel and press 'Alt-F11' to enter the Visual Basic Editor.
3. Click 'Insert' and then click 'Module.'
4. Paste the code into the right-hand pane by pressing 'Ctrl-'V.'
5. Change 'text.xls' to the file name you are searching for.
6. Press 'F5' to run the procedure. The procedure will return a pop-up window telling you whether the file exists.

Read more ►