How to Restore MS Excel Toolbar

1. Access the toolbar setting in Microsoft Excel 2008 by going to the “View” menu and selecting “Customize Toolbars and Menus.”
2. Restore the toolbars by clicking the boxes next to the toolbar names. The most commonly used toolbars are the “Standard” and “Formatting” toolbars. If you want these toolbars to appear at the top of the document, click the “Dock” option for each one.
3. Press “OK” to complete to process and return to your document.

Read more ►

How to Copy an Excel Spreadsheet Into PowerPoint

Copy Entire Worksheet
1. Select the PowerPoint slide in which you want to insert the Excel worksheet. If the slide has multiple content boxes, click the content box where you want the Excel information to appear.
2. Click the 'Insert' tab at the top of the PowerPoint 2010 window. Locate the 'Text' field and select the 'Object' button to open the 'Insert Object' window.
3. Select the radio button next to 'Create from file' on the left side of the window. Then click the 'Browse' button and navigate to the Excel file that you want to add. Place a check next to 'Link' if you want the image of the Excel spreadsheet to update whenever the Excel file changes. Click 'OK' to add the image of the top worksheet in the Excel file to your PowerPoint slide.
Copy Range of Cells
4. Open the Excel 2010 file and select the worksheet that contains the information you want to add to a PowerPoint slide. Click the upper left cell in the range of information and hold down the mouse button. Move the mouse to the lower right cell and release the button. Press 'Ctrl' 'C' to copy the cell information to the clipboard.
5. Open the PowerPoint 2010 presentation and select the slide in which you want to add the Excel information. If multiple object boxes are present on the slide, select the one where you want the Excel information to go. Click the 'Home' tab at the top of the screen and select the 'Paste' button on the far left side of the ribbon. Five options will appear.
6. Select 'Use Destination Styles' to paste the cells as a PowerPoint table and use the same style as the current PowerPoint presentation. Select 'Keep Source Formatting' to paste the cells as a PowerPoint table but keep the exact same appearance as the cells had in the Excel worksheet, including conditional formatting. Select 'Embed' if you want to paste the cells as a small piece of the Excel program, which you can then edit like an Excel worksheet. Select 'Picture' to paste an image of the selected cells. Select 'Keep Text Only' to convert the Excel information into text and paste it into the object box. When you make your selection, the Excel information will appear on your PowerPoint slide.

Read more ►

How to Get a Percent of a Total on Microsoft Office Excel 2007

1. Use the SUM function to total the values of the cells you want to include in the total. For example, if you want to determine the total of your income for the year and your income for each month is listed in cells A1 through A12, you would use the function SUM(A1:A12).
2. If you want to take a percentage of the total, enter in a new cell '=SUM(Cells you want to include)*Percentage.' For example, if you wanted to use the income mentioned in step 1 and find 10 percent of that income, you would enter '=SUM(A1:A12)*0.1.'
3. If you want to use a percentage found in another cell, enter that cell instead of a number for percentage in the formula '=SUM(Cells you want to include)*Percentage.' For example, if you had the income tax percentage in cell C5, you would enter '=SUM(A1:A12)*C5'.

Read more ►

How to Make a Chart in Excel 2003

1. Open your workbook in Microsoft Excel 2003 and select the spreadsheet containing the data you want to chart.
2. Highlight the cells containing the data you want included in the chart.
3. Click 'Insert' in the top menu bar and select 'Chart' to launch the Chart Wizard tool. You can also click the 'Chart Wizard' button on the Standard toolbar.
4. Select the 'Standard Types' tab in the dialog box that opens.
5. Select a general chart type (such as 'Bar' or 'Pie') from the 'Chart type' menu and then select a specific style from the adjacent 'Chart sub-type' menu. You can view a live preview of the chart by clicking and holding on the 'Press and Hold to View Sample' button at the bottom-right corner of the dialog box. Click 'Next' after making your choices.
6. Confirm that you selected the correct data previously. If you did not, highlight the data you want included in the chart, or manually enter the cells you want to use in the 'Data ranges' field. In either case, click 'Next' to confirm your selection.
7. Adjust the appearance of the chart in the resulting 'Chart Options' window by selecting the corresponding tab (such as 'Titles' or 'Gridlines'). The available options will vary, depending on the type of chart selected. Click 'Next' after specifying your preferences.
8. Select the 'As object in' option, click the adjacent drop-down menu and then select the name of the spreadsheet into which you want the chart inserted. To add the chart to a new spreadsheet, select the 'As new sheet' option and give the spreadsheet a name in the adjacent field.
9. Click 'Finish' to confirm your choices and generate the chart.

Read more ►

Copy Pasting in Excel 2007 Freezes My Computer

Detect and Repair
1. Open a new document in Microsoft Excel 2007.
2. Click on the 'Help' tab on the program's task bar. In the drop-down menu, scroll down to the program called 'Detect and Repair.' Click the program to begin it.
3. Allow the 'Detect and Repair' program to run. Hopefully, the program will fix any errors you have with your Microsoft Excel 2007 program. If the error persists, move onto the next section.
Edit Your Registry
4. Click the 'Start' menu and scroll up to 'Run.' Type in 'regedit' in the box and press 'Enter.'
5. Scroll through the folders until you find the pathway that is 'hkey_current_user\software\microsoft\office\10.0\excel.' This is the name for Microsoft Excel 2007. Right-click the folder, click on the option to 'Rename' and change the name to something else. Hit 'Enter' to complete the name change. Exit the registry editor and return to your desktop.
6. Open Excel on your desktop. This may resolve the problem that occurs when you copy and paste cells in the program. However, if it does not, you will need to reinstall the program.
Uninstall and Reinstall
7. Click on 'Start' and scroll up to 'Control Panel.' Choose the option to 'Add/Remove Programs.' Scroll through the list to locate 'Microsoft Excel 2007' and click the option to 'Change/Remove' the program. Follow the instructions to delete the program and restart your computer.
8. Insert the Microsoft Excel 2007 installation disc into your computer. Your computer will read the disk and begin the Installation Wizard. Follow the instructions to install Microsoft Excel 2007 onto your computer. You may need to restart your computer for the installation to take effect.
9. Open Excel 2007. When you open the program, you should now be able to copy and paste cells without the program freezing up on you.

Read more ►

How to Extend the Microsoft Excel Record Limit

Open a New Worksheet
1. Open Excel and the worksheet you have hit your record limit on.
2. Click on the 'Insert Worksheet' button located at the bottom of the Excel workbook. The button looks like a folder with a yellow star and is usually located at the end of the worksheet tabs. You can also press the 'Shift' key plus 'F11.' If you do not have function keys, you can also right click on a worksheet tab and click 'Insert.' Select 'Worksheet' to add another worksheet to your book.
3. Save your workbook and begin doing computations in your new worksheet.
Upgrade to Excel 2007 or 2010
4. Navigate to the Microsoft Office website and download a newer version of Microsoft Office to increase the Excel record limit. You can also purchase a stand-alone version of Excel 2007 or 2010.
5. Install the newer version of Excel on your computer.
6. Open your older workbooks in the newer version of the program. Microsoft products are backwards compatible so you can simply open Excel worksheets from 97 to 2003 in a newer version to take advantage of the larger record limit.
Migrate to a Database Program
7. Download and install a database program such as OpenOffice's Base or Oracle's MySQL, or purchase Microsoft Access.
8. Open the database program and set up a blank database.
9. Import the Excel workbooks or worksheets into the database. Expand your database with the records you need.

Read more ►

How to Convert Read

1. Open the 'Read-Only' spreadsheet in Microsoft Excel 2007. You can open the file by double-clicking on it from it's current location or in Excel 2007 by clicking on the 'Office' button and then 'Open.' When the 'Open' dialog box open, click on the file and then click 'Open.'
2. Click on the 'Office' button and then 'Save As' to begin the process of saving the file in a earlier, editable version. The 'Save As' dialog box appears.
3. Click the drop-down arrow next to 'File type as' and choose 'Excel 97-2003' Workbook. Choose a file location for the file and then click 'Save.' Close the workbook.
4. Open the workbook in Excel 2003. Click on 'File > Open.' Locate the workbook and click 'Open.' You can now edit the document all you want. It is no longer locked for editing.

Read more ►

How to Make Three Dimensional Graphs in Excel

1. Open the Excel worksheet that contains the source data.
2. Click and drag to select the worksheet's categories and data to appear in the chart.
3. Click the “Insert” tab on the command ribbon.
4. Click the arrow under the preferred chart type in the “Charts” group -- for example, click “Pie,” “Bar” or “Area.” A gallery of thumbnail charts displays, including “3-D” for three-dimensional options.
5. Click a thumbnail chart in the “3-D” section -- for example, click “3-D Bar.” The source data converts to a three-dimensional chart.

Read more ►

How to Use Decimal Numbers in Excel

1. Launch Excel and open the worksheet where you want the number formatting changed to decimals.
2. Highlight the cells you want to change. If you want to use a whole column for decimals, click in the shaded box with the column's identification letter, or use the identification number box for rows to highlight the whole row.
3. Select multiple cells, rows or columns by holding down the 'Ctrl' key as you click on other cells, rows or columns after your first selection.
4. Click the 'Home' tab, and then click in the bottom right corner of the 'Number' section, where you will see a small box with an arrow. This launches a window with the full set of number options.
5. Click on 'Number' in the left menu column, and then select your preferred number of decimal places using the arrows in the field next to 'Decimal places' in the middle of the dialog box. You can also manually enter a number into the decimal places selector.
6. Choose any other options you want to modify, such as using a comma to separate digits at every 1,000 and how negative numbers are formatted, and then click 'OK.' Your numbers will appear as decimals.
7. Enter new decimal amounts as you would on any computer keypad, using the period on your keyboard to indicate a decimal point. If you have a numeric keypad on your keyboard, the decimal key there will also work.
8. Choose special decimal formatting, such as how many decimal places to show in dollar amounts, by highlighting the appropriate cells and accessing the same dialog box. Choose 'Currency' instead of 'Numbers,' and then refine your settings from there. Click 'OK' to reset the format.
9. Increase or decrease the number of decimal places that appear in your cells by highlighting your cells again, and then tapping the decimal increase or decrease buttons on the number's pane of the Home menu, just above the box and arrow icon.

Read more ►

How to Share Modify Excel Documents

Sharing
1. Open your workbook.
2. Click 'Review,' then 'Share Workbook.'
3. Check the ' Allow changes by more than one user at the same time' and 'This also allows workbook merging' check boxes.
4. Click 'Advanced,' then change the settings for tracking changes. Click 'OK.'
5. Save the document in a network directory.
Modifying
6. Open the workbook on the network drive by double-clicking on the workbook.
7. Click the 'Office' button, then 'Excel Options.'
8. Click 'Popular,' then 'Personalize your copy of Office.' Enter your name in the user name section.
9. Edit the data as you normally edit a workbook.
10. Save the file.

Read more ►

How to Use Microsoft Excel for Payroll

1. Navigate to the Microsoft Office Payroll Calculator template page (see Resources) and click 'Download,' then 'Accept.' Excel will automatically open to the template when the download is complete.
2. Fill out the columns with the information according to the headings above each column. The date you enter will include employee names and IDs, hourly wages, state tax percentage, insurance deductions and other relevant tax deduction information. As you enter the data, Excel will automatically calculate the figures in the 'Total Taxes Withheld' and 'Total Regular Deductions' fields.
3. Click 'Payroll Calculator,' which is near the bottom of the spreadsheet. Enter the requested information about the employees' hours, including overtime, and the calculator will provide you with the total net pay for each employee.

Read more ►

How to Create a Dashboard in Excel 2007

1. Log on to your computer and open Microsoft Excel 2007. Open the spreadsheet you want to upload.
2. Click on the Office button and choose 'Publish' from the list. Choose 'Excel Services' from the list and choose 'Distribute the document to other people'.
3. Enter the URL of your website, followed by the name of the file, in the 'File name' box For instance, if you are saving a document called spreadsheet1 to the site xyzcorp.com/reports, you would type 'xyzcorp.com/reports/spreadsheet1.xlsx' in the 'File name' box.
4. Click 'OK' and choose 'Save'. In the 'Document type' box choose 'Reports'.
5. Go to the site where you want to add the spreadsheet and choose 'Site actions'. Choose 'Edit Page' and then 'Modify shared web part'.
6. Click 'Workbook' and then choose 'Select a Link'. Navigate to the workbook you want to add to the dashboard and click 'OK'.

Read more ►

How to Import Data With Excel 2007

1. Log on to your computer and open the Microsoft Excel spreadsheet into which you want to export the data. Click the 'Microsoft Office' button.
2. Click 'Open' and choose the type of file you wish to export. Double-click the file you wish to import.
3. Choose whether the file to be imported is a delimited or fixed-width file. With a delimited file, each field is separated by a particular character, generally a comma, a semicolon or a colon. This type of file is most appropriate for files where each record contains data of varying lengths. A fixed-width file is most appropriate for files where each record is the same size.
4. Review the field names Excel assigns to each field. Type a new name if you wish, then click 'Next.' Click 'Finish' to complete the import process.

Read more ►

How to Import an Excel Macro From 2003

Export from Excel 2003
1. Press 'Alt' 'F11' together from within Excel 2003 to open the Visual Basic Editor (VBE).
2. Click on a macro name in the left sidebar to open the module window.
3. Click 'File' > 'Export File.'
4. Click the 'Save In' drop-down folder to choose a location to save the file, then click 'Save.'
Import the Excel 2003 File
5. Open Excel 2007 or Excel 2010.
6. Press 'Alt 'F11' together to open the VBE.
7. Click 'File' and then click 'Import.'
8. Locate the file on your computer and then click 'Open.'

Read more ►

How to Find the Z

1. Open an Excel worksheet and enter your data in one column. For the purposes of this article, enter sample data into cells A1 through A10, typing a different number in each cell.
2. Click on an empty cell below your data and use the “AVERAGE” function to calculate the mean of the numbers you entered. For the example above, you would type “=AVERAGE(A1:A10)” into the formula bar and press 'Enter.' The “A1:A10” part of the formula indicates the range of cells containing the data you want to analyze. The result of the calculation will appear in the cell you selected.
3. Click on a different empty cell below your data and calculate your standard deviation by typing a formula using the function “STDEV” along with your cell range. Continuing the example above, the formula would be '=STDEV(A1:A10)'.
4. Click on an empty cell beside the cell containing the number you want to find the Z-score for. For instance, click on cell B3 if you want to find the Z-score for the number in cell A3. Click the “fx” button on the formula bar to open the “Function” window. Select 'Statistical' from the category dropdown menu, then choose 'STANDARDIZE' to bring up the Function Arguments window.
5. Enter the number you want to calculate the Z-score for in the “X” box. Enter the number itself or a cell reference where the number is located, such as “A3.”
6. Enter the mean you calculated in Step 2 in the “Mean” box. Again, you can type in the number itself, or the cell where you entered the formula in Step 2.
7. Enter your standard deviation in the “Standard_dev” box. Type the number, or the cell where you entered the formula in Step 3.
8. Press “OK” to display the Z-score for the cell you chose in Step 5.

Read more ►