How to Find and Replace Text in Microsoft Excel 2003

1. Access the 'Find and Replace' menu. Scroll to the “Edit” tab on the command bar and select “Find.” A “Find and Replace” properties menu will open.
2. Type in the text you want to find. Under the “Find” tab, you can type in the text that you wish to find.
3. Type in the text that you wish to replace. Under the “Replace” tab, you can type in the text that you wish to replace.
4. Find and replace desired text. You can do this in two different ways. One way is by pressing the “Find All” button, which will find all occurences of the text you have typed, and another method is by using the “Find Next” button, which will find each separate occurrence of the text. Choose the desired option and, when you find text to replace, click on the “Replace” button to replace it. You can also click on “Replace All” to replace all occurrences of the text inside of the spreadsheet.

Read more ►

How to Override an Excel Password

1. Make a new spreadsheet. Leave it entirely blank. If it is a protected workbook, instead of just one sheet, make a new workbook.
2. Click on the top left corner of the protected spreadsheet's header bars (above the 1, left of the A) to highlight the whole sheet.
3. Copy the spreadsheet, either by pushing 'Ctrl' 'C' or by selecting 'Edit' from the menu bar and clicking on 'Copy.'
4. Click on your new blank spreadsheet. Click the top left corner to highlight the whole sheet, as in Step 2.
5. Paste the copied spreadsheet by pushing 'Ctrl' 'V' or by selecting 'Edit' from the menu bar and clicking on 'Paste.' You now have an identical copy of the protected spreadsheet---only it's not protected.
6. Rename the new spreadsheet to match the name of the old one (you may have to first rename or delete the old one to do this, if they are in the same workbook).
7. Manually copy all of the page setup settings, if you need to print this spreadsheet just like the old one. With the old, protected spreadsheet pulled up, select 'File' from the menu bar and click on 'Page Setup.' Go through the tabs and write down all the settings. Return to the new spreadsheet. Open the page setup box and enter the settings.
8. Repeat Steps 1 through 7 for each spreadsheet, if it is a whole workbook being copied. Rename the new workbook to match the old one when you are finished.

Read more ►

How to Make Pie Graphs in Excel

1.
Enter the data that you want your pie graph to represent into a spreadsheet in Microsoft Excel. Make sure to include column headings that explain what the data signifies. Try to be as descriptive with your data entry as possible because these elements will automatically feed into the pie graph. To help explain, we will construct an example in which we create a pie graph that breaks down a favorite color list by percentage.
2.
Click on the cell that contains your first column heading. Then, from the “Insert” menu, click on the arrow underneath the word “Pie” and the picture of a sample pie graph. Another menu will open.
3.
Choose the type of pie graph that you want to create with your data. For this example, we will choose the simplest of the two-dimensional options. Once you have made this selection, the pie graph will appear in your spreadsheet.
4.
Right-click on the pie graph and another menu will appear. Use the options in this menu to make any modifications that you wish to the format. For our example, we will change the wording in the title and apply labels to the pie graph.
5.
Save your Excel file so that you do not lose your work.

Read more ►

How to Make Address Labels From Excel 2007

1. Open Excel by clicking 'Start,' then 'All Programs,' then 'Microsoft Office,' and finally 'Microsoft Office Excel 2007.'
2. Click the 'Microsoft Office Button,' then select and click 'New,' and under the Template > Microsoft Office Online section click 'Labels.'
3. Click 'Mail and shipping,' then select and click 'Business.'
4. Select and double click the icon 'Avery 8160 Template' and the label template will begin downloading onto your computer system. Once it has completely downloaded, 30 labels will appear on a letter-size, 8.5-inch by 11-inch, Excel worksheet window.
5. Type the address information onto the address labels.
6. Print out the typed labels using the Avery 8160 labels.

Read more ►

How to Compare Two Excel Spreadsheets for Duplicate Rows

1. Open your spreadsheet and make sure you know what columns the data you want compared are in. This example will assume the data is in column A, and that the two lists to be compared are in two spreadsheet tabs, labeled Sheet1 and Sheet2 of the same workbook.
2. Enter the following formula in cell B1 of Sheet1. =COUNTIF(Sheet1A:A,Sheet2A:A). Hit Enter. If the record is unique (it doesn't appear on both lists), this will evaluate to 0.
3. Copy the formula from cell B1 through as many rows as you need on Sheet1.
4. Select columns A and B, and click on the Home tab (in Excel 2007) and select Sort and Filter. Choose to filter the results by Column B in ascending order. This will move all the results with a '0' in column B to the top, putting all your duplicate records at the bottom of the list.

Read more ►

How to Draw in Excel 2007

1. Open Microsoft Excel 2007.
2. Click on the 'Insert' tab. This is located near the top right-hand corner of the screen.
3. Click on the 'Line' drawing tool. The 'Line' tool is a good place to start, because you can use basic line shapes to draw a plethora of other custom-drawn shapes.
4. Click 'Lock Drawing Mode,' located underneath the main 'Line' heading. This option lets you connect several lines to predetermined nodes.
5. Click on the document where you want the line to start.
6. Drag your cursor across the spreadsheet to form a line and double-click when the line is long enough. Repeat this process as needed, and click on existing lines to create connection nodes. If you want to move a line or a node, click and drag the entire line or one of the circular nodes.
7. Press the 'Esc' key when you are finished connecting lines. This takes you out of the line editing mode.
8. Click on the 'Shapes' tool if you need to make a simple, pre-drawn shape.
9. Select the desired shape from the list of icons. The 'Shapes' tool gives you access to squares, circles, triangles and oblong shapes, each indicated by different icons underneath the 'Shapes' tool heading.
10. Click and drag the selected shape across your spreadsheet.
11. Click on the 'Home' tab when you are finished. This returns you to the main Excel window, letting you type text, adjust fonts and use Excel macros.

Read more ►

How to Make a Checkable Survey in Excel

1. Open a new Microsoft Excel 2010 worksheet.
2. Enter your desired text into the cells on the spreadsheet. You can click and drag the sides of the letters at the top of each column or the numbers at the left side of each row to resize the cells as you need to. This text is what the survey taker will see when they are using the survey. Leave spaces next to the text so that you can add your checkboxes.
3. Click the 'File' tab at the top of the screen and choose 'Options' from the list that appears on the left side of the window. Select 'Customize Ribbon' from the list on the Excel Options window. Look at the column that appears on the right side of the window and place a check mark next to 'Developer.' This will allow you to use the Developer tools with your spreadsheet. Click 'OK' to go back to your spreadsheet.
4. Select the 'Developer' tab at the top of the spreadsheet. Click the 'Insert' button on the ribbon and choose the small checkbox under 'ActiveX Controls.' Click and hold the mouse button anywhere on the spreadsheet, then drag the mouse down and to the right to create a box that will become your checkbox. Release the mouse button and the checkbox will appear.
5. Click on the checkbox to select it. Press 'Ctrl' and 'C' to copy it to your clipboard, then press 'Ctrl' and 'V' to paste a second copy of the checkbox. Press 'Ctrl' and 'V' repeatedly until you have created all the checkboxes that your survey needs.
6. Move your mouse over a checkbox until the pointer turns into a set of four arrows. Click and hold the mouse button down, then drag the checkbox to wherever you want it located on the spreadsheet. ActiveX objects exist above the spreadsheet level, so you do not have to place the checkbox within any particular cell or set of cells. Move each checkbox to your desired location.
7. Right-click a checkbox, move your mouse over 'Checkbox Object' and choose 'Edit.' You can now change the default text in the checkbox to whatever you desire. Repeat this process for every checkbox. If you don't want to use any text, click and hold the mouse button over either of the corners on the right side of the box. Drag the mouse to make the checkbox smaller until just the actual checkbox is visible, essentially hiding the text. Repeat this process for every checkbox.
8. Click the 'Design Mode' button in the ribbon to exit design mode. Your checkboxes will now be locked in place, and clicking on them will only add or remove a check. You will need to click 'Design Mode' again if you want to edit the boxes any further.

Read more ►

How to Turn an Excel Spreadsheet Into a Standalone Application

1. Download and install the XCell Compiler using the link in the Resources section.
2. Launch Microsoft Excel and open the spreadsheet that you would like to convert to a standalone EXE file.
3. Click the Office jewel in the upper-left corner of the window. Click 'Excel Options.'
4. Click the 'Trust Center' link on the left side of the window, then click the 'Trust Center Settings' button.
5. Click the 'Macro Settings' link on the left side of the window, then place a check in the box labeled 'Trust access to the VBA project object model.' Click 'OK.'
6. Click the 'Add-Ins' tab at the top of the Excel window.
7. Click the 'DoneEx' menu, then click 'XCell Compiler' and 'Compile.' If XCell Compiler is not registered yet, a window will be displayed. Click 'Close.'
8. Click the '...' button next to 'Target Path,' and browse to the location where you would like the converted file to be saved. Click the 'Compile' button.
9. Click 'OK' and close Excel. Find the converted EXE file in the location that you specified in the previous step. The program will open when double-clicked just as a standard application.

Read more ►

How to Copy and Paste Tables From Excel into Microsoft Word 2003

1. Highlight and copy the table from Excel. Left-click and hold as you highlight the entire table in Excel. Release the mouse button and the table will remain highlighted. Right-click on the highlighted table, and then click on “Copy.”
2. Select the area in Word that you wish to paste the table into. Click on the portion of the document that you wish to paste the table into.
3. Paste the table into Word. Scroll to the Edit tab and then select “Paste.”
4. Choose your table paste attributes. On the lower-right corner of the table you just pasted, there will be a clipboard icon. Click on this to change the table paste attributes. You can choose from the following table paste attributes by clicking on the corresponding radial button: Keep Source Formatting (which will paste that table the same way you copied it), Match Destination Table Style (which will copy the formatting of any existing tables in Word), Keep Text Only (which will only copy the text from the table), Keep Source Formatting and Link to Excel (which will update the table in Word any time you make changes to the same table in Excel) and Match Destination Formatting and Link to Excel (which will match the formatting of any existing Word tables, and update the table as you make changes to it in Excel).

Read more ►

How to Check for Duplicates in Excel

1. Click the Windows 'Start' button and select 'All Programs.' Click the 'Microsoft Office 2010' folder to expand the contents of the folder. Click the 'Microsoft Excel 2010' option to launch the Excel application.
2. Click the Microsoft Office button, and click 'Open.' Navigate to the spreadsheet file to search for duplicates.
3. Click the top leftmost cell to select the entire worksheet. To select a range of cells, click the top leftmost cell and drag the cursor to select the desired columns and rows.
4. Click 'Data' from the top navigation ribbon. Click 'Filter' and then click 'Advanced Filter.'
5. Click the 'Filter the List, in Place' option.
6. Check the check box in front of the 'Unique Records Only' option, and then click 'OK.'
7. Click the 'Edit' option on the top navigation ribbon, and then click 'Office Clipboard.'
8. Click the 'Copy' icon on the top navigation ribbon, or press the 'Ctrl' 'C' keys to copy the Excel data to the clipboard in the left pane of the Excel interface.
9. Click 'Filter' and then click 'Show All' from the Data pane in the top navigation ribbon. The original data are displayed, including duplicates.
10. Press the 'Delete' key to delete the original list.
11. Click the filtered list in the clipboard pane. The filter list replaces the original list in the Excel file. Duplicate records are removed.
12. Click the 'Microsoft Office' button, and then click 'Save' to save your new filtered list.

Read more ►

How to Recover a VBA Excel Password

1. Navigate to the A Pass Cracker Atomic Visual Basic for Applications (AVBA) link (see Resources). AVBA recovers passwords for VBA passwords associated with Microsoft Excel and Word. The software promises to recover passwords instantly regardless of length. Although there is a trial version of the software available, it will only show the first two symbols of the cracked password: you must purchase the full version to see the rest of the password.
2. Click on Last Bit's VBA Password link (see Resources) and download the software. VBA Password uses a combination of six different techniques to crack your password, including dictionary attack which tries to match your password against every word in the dictionary. The software uses brute force (trying every possible character and letter combination) to recover some passwords; this process may take days so you can choose to reset the password instantly for access. VBA password works with all versions of Excel.
3. Navigate to Elcomsoft'sAdvanced VBA Password Recovery (AVPR) website (see Resources). AVPR can help you to recover Excel VBA passwords from Excel 97, 2000, XP, 2003. The software can also find the password for any Excel add-ins. The software works by utilizing the 'backdoor' method which bypasses the password and recovers the file. Download the trial version of the software and use it free for 30 days. The trial version is limited to cracking passwords of 3 letters or less.

Read more ►

How to Get Solver for Excel 2007

1. Open a spreadsheet in Excel.
2. Click 'Add-ins' on the Tools menu. Select 'Solver Add-in' check box.
3. Click 'OK,' and the Solver installation will begin automatically.
4. Click on 'Solver' on the Tools menu to run the program.

Read more ►

How to Protect a Pivot Table

1. Open the worksheet with the pivot table. Select the pivot table information in your Excel worksheet that you would like to protect.
2. Click 'Review' from the ribbon menu. Under the Changes group, click 'Protect Sheet.'
3. Click the 'Use PivotTable Report' check box. Type a password in the 'Password to Unprotect Sheet' box.
4. Click 'OK' and re-enter the password. Your pivot table is now protected.

Read more ►

How to Calculate Mode Using Excel

1. Add the numbers in the first column of your Excel 2007 document. For example, add the numbers 9,6,5,9,4,9,2 and 1 in A2, A3, A4, A5, A6, A7, A8 and A9.
2. For this example, click on the 'A11' cell. This is the cell where you will calculate the mode. When you calculate another mode, choose any cell at the bottom of the list of numbers you are using.
3. Click 'Insert Function' on the top, left-hand side of the Excel spreadsheet. The 'Insert Function' window will pop open. With Microsoft Excel 2007, click on the 'Formulas' tab and then 'Insert Function.'
4. Click on the drop-down menu of 'Or select a category.' Select 'Statistical' from the drop-down menu.
5. Scroll down the 'Select a function' window. Choose 'MODE,' which is the function of mode.
6. Click 'OK.' The 'Functions Arguments' window will pop open. Ensure that on 'Number 1' cell, A2:A9 is populated. If A2:A9 is not populated, enter A2:A9 manually. Click 'OK.'
7. The mode has been successfully calculated. In this example, the calculated value of the mode is 9.

Read more ►

How to Add a Calendar Date Picker to an Excel Spreadsheet

1. Download the free 'Calendar' tool available at isamrad.com/ExcelCal/default.htm. This plugin is a standard Excel add-in program. It is offered as a compressed ZIP file which must be unzipped after download. Once the XLA file is placed into the Excel 'XLSTART' directory in the 'Program Files' folder of Windows, Excel will show a date picker icon next to cells that are already formatted as dates. Additionally, the date picker can be launched by right-clicking on any cell and choosing the 'Pick from Calendar' option. The applet also installs a toolbar button for the feature.
2. Activate a free 30-day trial of the Pop-up Excel Calendar created by Office Kit. This program offers a robust calendar interface that includes quick jumps to any month or year as well as shortcut buttons. Additionally, the program installs a unique calendar toolbar which features a quick launch for the Pop-up Excel Calendar as well as other features, including a settings button. The applet works on all major versions of Excel. If you are pleased with the demo, Pop-up Excel Calendar costs $20 as of February 2010.
3. Download the WinCalendar utility. The software comes in multiple versions, including a free option. The program is a robust date picker that displays multiple calendars simultaneously for quick selection of any date within a three-month period. Additionally it highlights holidays and offers user customization of new holiday entries. The calendar can be re-sized to suit the user's preference. It also functions in other Microsoft Office programs, or as a standalone program. The free version is functional but excludes emphasis of some holidays and limits the size of the pop-up interface. The free version also limits the number of entries that may be made.

Read more ►

How to Enter Formulas in Excel Divide the Sum of Several Numbers by a Number

1. Click on an empty cell in your spreadsheet.
2. Type an '=' sign.
3. Type the following formula into the cell: UM(A1:A10).
4. Replace 'A1:A10' with the cell locations of the numbers you want to add. In this example, the series of numbers is in cells A1 through A10.
5. Type a division sign '/' followed by the number you want to divide by. For example, if you wanted to divide the total of cells A1 to A10 by 3, type '/3.'
6. Press the 'Enter' key; Excel will perform the calculation.

Read more ►

How to Create a Flow Chart in MS Word

1. Open Microsoft Word, which automatically defaults to a blank portrait-oriented page on the screen. To change your flow chart to landscape orientation, click the 'Page Layout' tab at the top of the screen and click the 'Orientation' button directly below it. The page changes to landscape.
2. Type the name of the flow chart at the top of the page, such as 'Weather Closing Phone Tree.' Highlight the words, click the 'Home' tab at the top of the screen and change their appearance using the options in the 'Font' section of the ribbon/toolbar, such as font style and text color.
3. Click the 'Insert' tab at the top of the screen. Click the 'SmartArt' button on the ribbon/toolbar below it, which opens the 'Choose a SmartArt graphic' window.
4. Scroll through the different flow chart options, including vertical hexagons, triangles of different sizes and boxes and arrows in a horizontal line. The flow chart options in the 'Process' section of the window may be especially applicable to a flow chart.
5. Double-click a SmartArt shape group and it appears on the Word window. Enlarge the flow chart to fit the page by grabbing a corner and dragging it toward one of the edges of the Word workspace.
6. Click one of the '[Text]' words within the SmartArt flow chart shape and type the shape's information, such as a worker's name. Repeat this to fill the rest of the flow chart with labels for each shape.
7. Recolor the flow chart (optional) by double-clicking anywhere on it to bring up a new 'SmartArt Tools' toolbar. Click the 'Change Colors' button on the toolbar and hover your cursor over the options in the drop-down menu. As you hover over each group of colors, the flow chart changes. Click a color group to commit the change.
8. Click the 'File' tab, click 'Save As,' give the flow chart a name and save it to your computer.

Read more ►

How to Exit Out of Header Footer Option in Excel 2007

1. Add a header or footer. Click 'Header Footer' in the 'Text' area of the 'Insert' tab. Click on the document in the area marked 'Click to add header' or 'Click to add footer.'
2. Design the header or footer. Select preformatted options from the menu, type in your own text, or use a combination of menu items and typed text. When you finish the header or footer, click anywhere on the body of the document.
3. Change to Normal View. Click 'Normal' in the 'Workbook Views' area of the 'View' tab. You will leave header/footer mode and return to your worksheet.

Read more ►

How to Print Address Labels in Excel

1.
Open a blank worksheet in Excel. Go to the 'File' menu, click on 'Page Setup' and go to the 'Margins' tab in Excel 2003. In Excel 2007, go to the 'Page Layout' tab and click 'Margins.'
2.
Enter '0' in the Top and Bottom boxes. Change the margins in the left and right boxes to '.19.' Under Center on Page, select 'Horizontally' and 'Vertically.' Apply these changes by clicking 'OK.'
3.
Select cells A1 through A10 with the mouse. Go to the 'Format' menu in Excel 2003, point to 'Row' and select 'Height.' In Excel 2007, click 'Format' on the Home tab and click 'Row Height.' Enter '72' and click 'OK.' In the same manner, change the Column Width to 35. Repeat the steps in cells C1 through C10 and E1 through E10.
4.
Use the mouse to select the cells in B1 through B10. Change the width of the column to 1.29. Repeat with cells D1 through D10.
5.
Select all of the cells from A1 through E10 with the mouse. Click the 'Borders' drop-down on the Format toolbar in Excel 2003 or the Font group on the Home tab in Excel 2007. Click 'All Borders.'
6. Enter the names and addresses into the label cells. The cells in columns A, C and E are the label areas. Columns B and D are the margins between labels. Print onto the label paper.

Read more ►

How to Use the Transpose Function in Excel

1. Highlight the range of cells where you want the transposed data to appear. For example, if you want to transpose cells A1:A10 into a row in cells B1:K1, you would highlight B1:K1.
2. Go to the 'Formulas' tab and click on 'Insert Function.' Type 'Transpose' in the 'Search for a function' field and click on the 'Go' button. Select 'Transpose' from the 'Select a function' section and click 'OK.'
3. Highlight the range of cells you would like to transpose. In our example, we would highlight cells A1 through A10. The range will appear in the 'Array' field of the Function Arguments window.
4. Hit 'Ctrl,' 'Shift' and 'Enter' on your keyboard simultaneously. The transposed data will appear in the new location, which is B1 through K1 in the example.

Read more ►

How to Delete Shading From Alternate Rows in Excel 2003

1. Open the spreadsheet which contains the unwanted shading.
2. Click on the row number of one of the shaded rows. This will highlight the entire row. Ctrl-click on each row number where there is shading you want to delete.
3. Click on 'Format' on the menu then 'Format Cells.' Click on the 'Patterns' tab. Click the bar above the color palette that says, 'No Color.' This will delete the shading from alternate rows in Excel 2003.

Read more ►

How to Draw a Histogram in Windows Excel

Load the Analysis ToolPak
1. Open a new Excel spreadsheet. Click on the 'File' tab at the top of the screen, and then click 'Options' on the menu that appears.
2. Click 'Add-Ins' from the list on the left side of the Excel Options menu. Click the drop-down arrow next to the 'Manage' box at the bottom of the window. Choose 'Excel Add-Ins' from this drop-down menu, and click 'Go.'
3. Click the small box next to 'Analysis ToolPak' to place a check in the box. Click 'OK' to close this window.
Create the Histogram
4. Click on cell 'A1' and enter the title for the data that you want to use with the histogram. Then select cell 'A2' and enter your first value. Continue to enter values using the cells in column 'A' until you have added all of your data.
5. Click cell 'B1' and type in 'Bin Range.' This column of cells will contain the numbers that represent the number ranges that will make up the horizontal axis of your histogram. Remember that each bin number represents the top of the range of values that will be counted as part of that bin, so be sure to include the highest possible value for your data as part of the bin numbers. Enter the values starting at call 'B2,' and continue down the column until you have entered all your desired bin ranges.
6. Click the 'Data' tab at the top of the screen, and then click the 'Data Analysis' button on the far right side of the ribbon. Select 'Histogram' from the list of options and then click 'OK.' A small 'Histogram' window will appear.
7. Click in the blank next to 'Input Range' in the Histogram window. Click on cell 'A2' and hold down the mouse button. Drag your mouse down until you reach the last cell that holds data in column 'A'; then release the mouse button. Click on the blank next to 'Bin Range' and do the same thing as you did in column 'A,' but this time do it in column 'B' starting with cell 'B2.'
8. Select the radio button next to the output option that you desire. You can place the histogram somewhere on this worksheet, you can place it on a new worksheet within this workbook or you can place it in an entirely new workbook.
9. Place a check next to any of the bottom three options, if any apply to your desired histogram output. 'Pareto' will sort your data in descending order of frequency, 'Cumulative Percentage' will include another column on the histogram that has the cumulative percentages for your frequency data, and 'Chart Output' will display a chart of the histogram in addition to the standard table.
10. Click 'OK' to close the window and Excel will create your histogram.

Read more ►

How to Remove Multiple Duplicate Rows in Excel 2003

1. Open the spreadsheet and select the cells that may include duplicate rows. The values in the rows can be text or numbers.
2. Click the 'Data' menu, hover over the 'Filter' option and choose 'Advanced Filter' from the submenu.
3. Choose 'Copy to another location,' which leaves the original range of data intact, just in case.
4. Check the prepopulated 'List range' to confirm it's the range of data you want to filter of any duplicate values.
5. Choose, in the 'Copy to' field, the first cell to which you want to copy the filtered cells.
6. Place a tick mark in the box labeled 'Unique records only.' Click 'OK' to close the box and filter duplicates from the list of data.
7. Delete the original data when you're satisfied with the filtered results.

Read more ►

How to Make a 2nd Line on MS Office Excel

1. Click 'Start,' then 'All Programs.'
2. Click the 'Microsoft Office' folder, then click 'Microsoft Office Excel.' This will open a new workbook. To open an existing workbook, click the 'File' tab, then click 'Open' and browse to your file.
3. Click the cell into which you wish to add a second line.
4. Add the data for the first line, then press 'Alt Enter' to create a second line within the cell. You can continue to use 'Alt Enter' to add additional lines to your cell as well.

Read more ►

How to Add Data Labels to an Excel Chart

1. Start Microsoft Excel 2007 and open a workbook from your files that contains a chart to which you would like to add data labels.
2. Select the chart you want to add the data labels to by clicking it. The chart will be surrounded by a light blur border indicating it is selected.
3. Choose the 'Layout' tab at the top of the Excel 2007 screen to display the options in the 'Layout' ribbon. Locate the 'Labels' group in the 'Layout' ribbon.
4. Click the 'Data Labels' button in the 'Labels' group of the 'Layout' ribbon to display a drop-down list of options.
5. Opt for 'Center' from the 'Data Labels' drop-down list to display the data labels centered on the data points of your chart. 'Inside End' will display the data labels inside the end of the data points while 'Inside Base' will display the data labels inside the base of the data points.
6. Watch as the data labels are added to the selected Excel chart in the position you have chosen.

Read more ►

How to Add a Custom Menu to an Excel Toolbar in Excel 2003

1. Log on to your computer and open your Excel worksheet. You should be able to locate the program by using your 'Start' button. When you cannot find it there, use your 'Search' or 'Find' function.
2. Go to 'Tools' in the toolbar. Hold the mouse over the arrow to expand the menu and select 'Customize'.
3. Add the functions that appeal to you by checking desired toolbars under the 'Toolbars' heading.
4. Click on the 'Commands' tab. Choose a category from the displayed list, then choose a command and drag it off the dialog box to the toolbar. Repeat as desired.
5. Delete a command by dragging the icon outside the toolbar and letting go of your left mouse button.
6. Determine whether you want a command by selecting the command under the 'Commands' heading, then choose 'Description'. This allows you to view a description of the command.
7. Close your 'Customize' window by clicking the 'X' in the left-hand corner of the window.

Read more ►

How to Multiply in Excel

Single Cell Multiplication
1. Select the cell where the answer will be. You can put a self-contained multiplication problem in one cell anywhere in a workbook and use it just like a calculator.
2. Start with the equals sign in the cell where the answer goes. This is the first step to tell Excel that the cell contains a math function.
3. Use the asterisk sign as the multiplication symbol. Like standard math, insert the asterisk between numbers in the equation with no spaces and hit 'Enter.' The cell should contain the solution to the multiplication problem.
Multiply an Entire Range of Numbers by Another Number
4. Decide what number to multiply the entire data set by and select a random cell in the workbook. This is only a temporary cell entry and is erasable after you complete the function. Enter the multiplier in this cell.
5. Select the cell containing the multiplier, right click and choose 'Copy.'
6. Choose the entire row or column of varied data to multiply. Right click the highlighted row and use the 'Paste Special' function, which brings up a sub-menu window.
7. Click the 'Multiply' option under the 'Operation' section and hit 'OK.' The multiplier now changes all of the data visible in the chosen range within the Excel workbook.

Read more ►

How to Restore the Default Settings in Excel 2007

Tools Menu
1. Log on to your computer and open Microsoft Excel 2007. Open a blank spreadsheet.
2. Click on the 'Tools' menu. Choose 'Customize' from the list of options.
3. Right-click on the menu you want to restore to its default settings. Choose 'Reset' to restore the menu to its original default settings.
Help Menu
4. Open Excel 2007. Click on the 'Help' menu.
5. Choose the 'Detect and Repair' option. Check the 'Restore my shortcuts while repairing' check box.
6. Click 'Start' to begin the repair process. Repairing Excel 2007 will bring it back to its original configuration.

Read more ►

How to Use Visual Basic to Add a Worksheet in Excel 2007

1. Click the Windows 'Start' button and select 'All Programs.' Click 'Microsoft Office,' then click 'Microsoft Excel.' The programming software opens.
2. Click the 'Office' button and click 'Open.' Click your Excel file name to open it in your software. Click the 'Development' tab and 'View Code' to open the VBA coding file for the spreadsheet.
3. Type the following code in your VBA code file:Set newSheet = Worksheet.AddnewSheet.Name = 'New Sheet'newSheet.ActivateThis code creates a new sheet and names it 'New Sheet.' The code then makes it the active sheet.
4. Click the 'Save' button and close the VBA code file. Close the file and reopen it to see a new sheet created in the file.

Read more ►

How to Update Link Workbooks in Excel 2007

1. Close out all of the workbooks in the Microsoft Excel 2007 application. Click on the “Microsoft Office” button and then click on the “Open” option.
2. Select the destination workbook that contains all of the links and then click on the “Open” button.
3. Click on the “Update” button from the pop-up dialog box that appears on the screen to automatically update all of the links for the source workbooks.
4. Click on the “Don’t Update” option if you want to only select links to other workbooks, and then click on the “Edit” option from the top toolbar menu.
5. Click on the “Links” option and then select the object you want to update from the “Source” list. Click on the “Update Values” option.

Read more ►

How to Detect Repair Excel 2007

Microsoft Excel 2007
1. Open Microsoft Excel 2007.
2. Select the 'Microsoft Office' button. Click the 'Excel Options' button.
3. Select 'Resources' located on the left side. Click the 'Diagnose' button and then click 'Continue.'
4. Click the 'Start Diagnostics' button. Office tries to identify your software problem and attempts to repair any problems. Click 'Close' when the diagnostics are complete. If Microsoft Diagnostics cannot fix the problem, repair the software through the Control Panel.
Control Panel
5. Open the 'Start' menu. Choose 'Control Panel' from the menu. Click the link to 'Uninstall a Program.'
6. Select your Microsoft Office Suite from the list of programs. Click the 'Change' button.
7. Choose the radio button to 'Repair.' Click the 'Continue' button. Microsoft Office then repairs the software.

Read more ►

How to Calculate a Date in Excel

1. Populate today's date with the Today function. Type '=TODAY()' in a blank cell to return today's date. The Now function returns the date and the time stamp: '=NOW()'.
2. Calculate a future date by entering a date in a cell. Click on an empty cell and type '=cell reference number of days' where cell reference refers to the date that was entered and the number of days should be substituted for the actual number of days you want to calculate. For example, if we enter 5/22/2009 in cell A1 and want to know what the date will be in 21 days, the formula would be '=A1 21', which returns 6/12/2009.
3. Calculate a past date following the same procedure as in Step 2, but replace the plus sign with a minus. For example, if we enter 5/22/2009 in cell A1 and want to know what the date was 13 days ago, the formula would be '=A1-13', which returns 5/9/2009.
4. Calculate the number of days between two dates with the DAYS360 formula. Enter a start date and end date in two cells. Click on an empty cell and type '=DAYS360(start date,end date)', where the start and end dates would be substituted with cell references. In our example in Step 3, if we had the original date of 5/22/2009 in cell A1 and the calculated end date in B1, the formula would be =DAYS360(B1,A1), which returns 13 days.

Read more ►

How to Learn Basic Microsoft Excel

1. Learn Excel online through the Microsoft Office website, which includes Excel tutorials for all levels. Click the 'support' tab at the top of your page and select 'Excel' from the drop-down list. Select the Excel version you want to learn from the right and click 'Getting started.' Pick a topic -- such as 'Basic tasks in Excel 2010' -- that interests you. (see References)
2. Learn how to complete basic tasks in Excel through video tutorials at Microsoft Office. Click the video that interests you, such as 'Video: Getting Started with Excel 2010,' 'Video: Create a workbook,' or 'Video: Print a worksheet.'
3. Learn basic Excel through books and CDs. You can purchase low-cost books at Amazon.com, Ebay, Craigslist, discount outlets, yard sales or borrow one from your local library. Try books like 'Microsoft Excel 2007 Step by Step,' which also includes a companion CD, 'Excel 2010 in Easy Steps,' 'MS Excel 2007 Training,' or 'Mastering Excel Made Easy Training v. 2010 through 97.'
4. Take a class at your local community college to learn the basics of Microsoft Excel, such as learning about cells, spreadsheets, using formulas and inserting rows/columns.

Read more ►

How to Embed a PDF File in Excel

1. Select the cell in your Excel spreadsheet where you wish to embed a PDF. The PDF file will take up more than just one cell; select the cell you want the top left-hand corner of the file to appear. Click on the 'Insert Object' button in the Text group under the Insert tab. Highlight 'Adobe Acrobat Document' under Object type in the Object pop-up window .
2. Decide how you want your PDF to appear in your Excel document. If you want the PDF to appear as the first page of the PDF, simply click the OK button. If you want the PDF to appear as an icon, click the check mark labeled 'Display as Icon' and choose an icon using the 'Change Icon...' button or click 'OK' to accept the default Adobe Acrobat Document icon.
3. Navigate to the PDF you wish to embed in your Excel workbook in the Windows Explorer pop-up window. Double-click on the PDF file or click the 'Open' button after highlighting the PDF file to embed it in your Excel workbook.
4. Double-click on your embedded PDF or representative icon in Excel to access your embedded file.

Read more ►

How to Unlock a Chart in Excel

1. Open Excel 2010 and the chart that is locked.
2. Click 'Unprotect Sheet,' which is located in the 'Changes' grouping on the 'Review' tab along the toolbar.
3. Enter the password to the chart if you are asked to provide one and click 'OK.' If you didn't create the chart or set the password, speak to the person who did.

Read more ►

How to Do an OHLC Chart in Excel

1. Open the Excel worksheet.
2. Type the data with four series of values in this order: open, high, low and close. For example, row 1 can include the five column headers: “Date,” Open,” “High,” “Low” and “Close.”
3. Click and drag the cursor to select the categories and data values you wish to convert to a chart.
4. Click the “Insert” tab on the command ribbon.
5. Click the arrow for the “Other Charts” button in the “Charts” group. A gallery of thumbnail images for charts and subtypes displays.
6. Click the “Open-High-Low-Close” image link in the “Stock” section. The “Open-High-Low-Close” button displays vertical lines and rectangles. The data converts to an embedded chart on the Excel worksheet. The “Chart Tools” ribbon displays three tabs: “Design,” “Layout” and “Format.”
7. Customize the chart with the commands on the “Chart Tools.” For example, the “Design” tab contains options for “Chart Layouts” and “Chart Styles.” Adjust the fonts with the “Font” commands on the “Home” tab for better readability.

Read more ►

How to Import XML to XL

Import XML Data as an External File
1. Open Microsoft Excel. Click on the 'Data' tab and locate the 'Get External Data' group. Click on the icon for 'From Other Sources' and select 'From XML Data' from the drop-down menu.
2. Locate the XML data file. Select the file name and then click on 'Open' in the lower right hand corner of the current dialog box. The 'Import Data' dialog box will appear.
3. In the 'Import Data' dialog box, specify whether to import the data as an XML table in a new worksheet, XML table in an existing worksheet, or whether to flatten the data into a two-dimensional table with the XML tags serving as column headings in the worksheet.
4. Save the spreadsheet when the import has completed.
Import XML Data Into Mapped Worksheet Cells
5. Highlight the 'Developer' tab in Excel. If the 'Developer' tab does not appear on the menu, click on the Microsoft Office button in the upper left corner of the application window and then click on 'Excel Options' in the lower right hand corner of the dialog box.
6. Highlight 'Popular' in the menu on the left and click on the check box next to 'Show Developer tab in the Ribbon' under 'Top Options for Working with Excel.' Then click on 'OK' to exit the dialog box.
7. Create a workbook that links to an existing XML schema. If there are no mapped elements, use the 'XML Source Task Pane' under 'XML Source Task Pane' to develop a mapping in the current workbook.
8. Import individual data items by selecting one of the mapped cells in the active worksheet and then clicking on the 'Import' icon in the 'XML group' under the 'Developer' tab, which will open the 'Import XML' dialog window. Select the location of the XML data file and click on 'Import.'
9. Import the entire XML data table by clicking on the 'Import' icon in the 'XML group' under the 'Developer' tab, which will open the 'Import XML' dialog window. Select the location of the XML data file and click on 'Import.' Specify whether to import the file into a new or existing worksheet.

Read more ►

How to Change Default Colors in Excel

Adjust the Color in a Worksheet
1. Change the font color. Click on one cell to select it or click on the first cell in a group and drag the mouse to highlight all the cells. You can also click on the gray box at the top left corner of the worksheet to select all the cells on the page.
2. Click on the 'Font Color' button on the tool bar. Click to select one of the standard colors displayed on the palette. The font color button has an 'A' on it, with a bar of the current font color underneath the A.
3. Change the background color of a cell. Highlight the cell or cells you would like to adjust and then click on the arrow on the right side of the 'Fill Color' button on the toolbar. Click on a color to apply it to the cell.
4. Change the color in a chart. Open the chart you want to format and double-click on the element you want to change. You can change the color of the background, labels and font of the chart.
Adjust a Color in the Color Palette
5. Open the workbook containing the color palette you want to change. You can also make the changes for a new workbook.
6. Open the 'Options' dialog box. Select 'Tools' from the tool bar and click on 'Options.' This dialog box contains various selections that you can use to change the default attributes of a workbook.
7. Click on the 'Color' tab. Select the color you want to change and click on 'Modify.' A 'Colors' pop up box should appear.
8. Replace the current color. To switch the color you have selected with another, select a different color from the standard tab of the colors dialog box.
9. Customize a color. Click on the 'Customize' tab of the 'Colors' box to adjust the intensity of the color you have selected.

Read more ►

How to Unsync Split Pane in Excel

1. Open the spreadsheet that has the split screens.
2. Click the 'Synchronous Scrolling' button in the 'Window' group on the 'View' tab.
3. Close the split panes by clicking on the 'Close' button in the upper-right corner of the pane. Repeat this step until only one pane remains open.
4. Click the 'Maximize' button in the upper-right corner of the pane.
5. Click the 'Save' button on the 'Quick Launch' toolbar to save the changes.

Read more ►

How to Replace Blank Cells With Value in Excel 2003

1. Select the range of cells that contain the blank cells you want to replace. Do this by clicking on the uppermost cell on the left side, then drag the cursor down to the right until the last cell of the range is highlighted. Not all of the cells in the range have to be blank.
2. Go to 'Edit' on the menu bar and select 'Replace.' A pop-up menu will appear.
3. Leave the 'Find what' box blank to search for blank cells.
4. Enter the value you want to replace the blanks with in the 'Replace with' box. For example, if you want '4' to replace all the blank cells, type '4' (no quotation marks).
5. Click the 'Replace All' button if you want all the blank cells replaced with your value. If you want only certain cells replaced with the value, click 'Find Next' and then click 'Replace' whenever you want the blank cell replaced. If you do not want a certain blank cell replaced, click 'Find Next' to go to the next blank cell.

Read more ►

How to Create a Pivot Table in Excel 2003

1. Create a spreadsheet in Excel with all of the data you want to place in your PivotTable.
2. Open a new a workbook for your PivotTable report.
3. Click on 'Data' in the menu bar, and then 'PivotTable and PivotChart Report.' This launches the PivotTable and PivotChart Wizard.
4. Select the option to use data from one Excel list or database. Click 'PivotTable.'
5. Select your data range. This is the actual data for your PivotTable. Click on the 'Browse' button and select the file and datasheet for your PivotTable. Click 'Finish.'
6. Drag your fields from the PivotTable Field List into the 'Column' and 'Row' sections of the PivotTable. Put the field that you want totaled into the 'Data Items' section.
7. Right-click anywhere on the table and click on 'Table Options' to change or add options for totals. Right-click on a field and click on 'Field Settings' to rename a field and change its count settings.
8. Drag the fields in the columns and rows to rearrange the data within the table. Switching the columns will change how the table reports the totals.

Read more ►

How to Use the Auto Filter in Microsoft Excel 2003

1. Highlight the cells and columns you wish to apply the auto filter to. Click and hold the mouse button in as you scroll the cursor over the desired groups of cells and columns, release the mouse button and they will remain highlighted.
2. Apply the auto filter. Scroll to “Data” and select “Auto Filter” from the submenu. Downward arrows will appear over all the columns you highlighted, from the top portion of the highlighted columns.
3. Filter the data as desired. Click on any down arrow to filter data in that column. When you click on the arrow a submenu will open. You can filter data by selecting the following options: 'Ascending' (which will sort the data as it ascends the workbook), 'Descending' (which will filter the data as it descends the workbook), 'Top Ten' (which will filter data by the top results of equations) and 'Custom' (which will open a custom filter menu where you can select custom filter algorithms from the drop-down menus).
4. Turn the auto filter off. To turn off the auto filter scroll to “Data” and click on “Auto Filter” again.

Read more ►

How to Move the Excel 2007 Pivot Table Field List

1. Open the Microsoft Excel 2007 application on your computer. Click on the 'Microsoft Office' button and the select the 'Open' option.
2. Locate the Excel 2007 file that contains the PivotTable that you want work with and then click on the 'Open' button to load the file onto your spreadsheet.
3. Click on the 'Options' tab if you don't see the PivotTable Field List after you've clicked on your PivotTable. Click on the 'Field List' option from the 'Show/Hide' group.
4. Locate the layout section at the bottom of the Field List and then click on the 'Move Up' option to move any select field in the list up one position. Click on the 'Move Down' option to move a field down one position.
5. Click on the 'Move to Beginning' option to move a field to the top of the list. Click on the 'Move to End' option to move the field to the bottom of the list.
6. Click one of the options to move a field to the 'Report Filter,' 'Row Labels,' 'Column Labels' or 'Values' area of your PivotTable.

Read more ►

How to Set Excel Macro Security to Medium

1. Open Microsoft Excel. Go to Start–Programs–Microsoft Office–Microsoft Office Excel. Please note that in some versions of Microsoft Office, you will Microsoft Office Excel straight from Programs.
2. Go to the Tools menu at the top of your Excel window.
3. Open the Tools menu and go to Macros.
4. Choose Security from the Macros menu.
5. Choose Medium from the Security Level tab. You also have the options of Very High, High, and Low. For most users High or Medium is best.
6. Click the OK button and restart Excel by closing the program and re-opening it. Your macro security level is now set to medium.

Read more ►

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 ►