Thursday, March 28, 2013

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 ►

Wednesday, March 27, 2013

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 ►

How to Protect XLS Cells From Changes


1. Click 'Start,' followed by 'All Programs,' 'Microsoft Office' and 'Microsoft Excel 2010' to launch Excel. Alternatively, launch Excel by double-clicking on a desktop shortcut or an Excel file in Windows Explorer.
2. Navigate to the worksheet that contains the cells you wish to protect.
3. Click the 'Select All' button to select the entire worksheet. It has a small triangular shape and is located in the upper left corner of the spreadsheet between the column 'A' label cell and the row '1' label cell.
4. Click the 'Home' tab. Click 'Format' in the 'Cells' group and click 'Format Cells' from the context menu.
5. Click the 'Protection' tab and clear the 'Locked' check box and click 'OK' to unlock the entire worksheet. Excel locks all cells on a worksheet by default and to lock specific cells it is necessary to unlock the worksheet first and then lock specific cells.
6. Click once on the first cell that is to be protected to select it.
7. Hold down the 'CTRL' key on the keyboard. Click additional cells individually to select them or drag the mouse over a range of cells to select the entire range. Release the 'CTRL' key when all cells on the sheet that are to be protected have been selected.
8. Click the 'Home' tab. Click 'Format' in the 'Cells' group and click 'Format Cells' from the context menu.
9. Click the 'Protection' tab and click the 'Locked' check box and click 'OK' to lock the selected cells.
10. Click 'Format' in the 'Cells' group on the 'Home' tab. Click 'Protect Sheet' and ensure the check box is checked for 'Protect Worksheet and Contents of Locked Cells.' Supply a password if desired and select additional options from the list as necessary to enable users to work with the spreadsheet. Click 'OK' to protect the worksheet and lock the cells.
Read more ►

How to Fill a Word Receipt Form With Excel Data


1. Open your receipt document. Click the 'Mailings' tab.
2. Click the 'Select Recipients' button. Select 'Use Existing List.' Navigate to the location of your Excel spreadsheet. Click the Excel file's name. Click the 'Open' button.
3. Select the worksheet that contains your customer data from the 'Select Table' dialog box. Leave the 'First row of data contains column headers' option checked if it applies to your spreadsheet. For example, it would apply if the first row and cell of your spreadsheet is 'Name' instead of the actual name of a customer. Click the 'OK' button.
4. Click on the place on your receipt where you want to insert the name of your customer. Click on the 'Insert Merge Field' button. Select the field that corresponds to your customer's name. These fields are from your Excel spreadsheet.
5. Repeat Step 4 for all of the customer information you want on your receipt.
6. Click the 'Preview Results' button. You can see the rest of your customer's receipts by clicking on the forward arrow next to the '1.'
7. Click the 'Finish Merge' button. Selecting 'Edit Individual Documents' will create new documents for each receipt. Selecting 'Print Documents' will print each receipt without creating new documents. Select the option that works best for you.
Read more ►

How to Count Cells That Are Not Blank in Excel 2007


1. Open your Excel workbook to the worksheet where you want the data counted.
2. Click in any open cell where you would like the result to appear.
3. Type '=COUNTA(' (without the quotation marks), but do not press 'Enter.' Make sure you include both the equal sign and the left paren.
4. Highlight the range of cells where you want the non-blank entries counted, using your mouse.
5. Release the mouse button and press 'Enter.' The results of the count will appear in the cell where you entered the formula.
Read more ►

How to Format Lines in an Excel Chart


1. Start Microsoft Excel 2007 and open a spreadsheet from your files that contains a chart to which you want to format the lines of.
2. Right-click on top of the line in the Excel chart that you want to format to display the shortcut menu. Choose 'Format (name of line)' from the shortcut list. The name of the line you are formatting will appear after the word 'Format' in the shortcut list. The 'Format' dialog box will open.
3. Select 'Line Color' from the list on the left side of the 'Format' dialog box if necessary. The line color options will be displayed on the right side of the dialog box. Choose 'Solid line,' 'Gradient line' or 'Automatic' to set the line color. If you choose one of the first two, you will see more formatting options appear. You can then specify the color, transparency and gradient settings for the line.
4. Click 'Line Style' from the list on the left side of the 'Format' dialog box. Set the width, compound type, dashed type, cap type and join type using the drop-down lists and boxes. Specify the type of arrow you want to use if applicable in the last part of this section.
5. Choose the 'Shadow' option on the left side of the dialog box to display the shadow settings for the line. Choose a shadow from the preset shadows and set the color. Use the sliders to set the transparency, size, blue, angle and distance of the shadow.
6. Click the 'Close' button to close the 'Format' dialog box and save your settings. You will return to your Excel chart with your newly-formatted lines visible.
Read more ►

Tuesday, March 26, 2013

How to Use VLookup With Different Sheets on Excel


1. Type the following data into 'Sheet1' of an Excel workbook, pressing 'Tab' in place of the commas. This table data associates a job code with a description for that code. This lookup table lets tables on any other sheet in the workbook use a code in place of typing the full description.D, PainterE, SculptorF, Designer
2. Click the top left cell of the lookup table just entered, then drag to the bottom right cell. This action selects the table. Type the name 'jobs' in the text box to the left of Excel's 'Formula bar,' which sits directly above the worksheet grid. The text box into which you typed is the 'Range name' box.
3. Click cell 'C4' of any sheet in your workbook besides 'Sheet,' then type the following sample table. This table uses a job code, for which the 'vlookup' function will display descriptive text.Name, Job codeClark Kent, dLois Lane, e
4. Type the text 'Job description' in the cell to the right of the 'Job code' header. Click the cell below the 'Job description' header and type this function: 'vlookup (D5, jobs, 2)'. Notice that Excel displays the job description where you typed the 'vlookup' function. That function's first argument is a cell reference for the cell containing the first job code of your sample table from step 3. The second argument refers to the lookup table. The third argument is the index of the job description column in the lookup table.
5. Click the lower right corner of the cell you just typed, then drag down to the last row in your sample table. This fills the 'Job description' column with the job descriptions that the 'vlookup' function provides. Note that these descriptions are on a different sheet from that of the sample table.
Read more ►

How to Widen Bars in Excel 2007


1. Open the chart that contains the bars that you want to widen. Click once directly on the data series (bar) that you want to widen. Note that all of the bars in the data series will widen equally, regardless of which you select. This action will launch a separate pop-up window.
2. Click the 'Format' tab and locate the 'Current Selection' section. Click the 'Format Selection' option.
3. Locate the 'Gap Width Field in the 'Series Options' section. Enter a value in the 'Gap Width' field that is lower than the current value. For example if the current gap width is listed as 150, try 125 or 100. The lower the number, the wider the bars become. You may have to try a few different gap width settings until you find an appropriate width. Click 'Close.'
Read more ►

Monday, March 25, 2013

How to Use Conditional Formatting in Microsoft Excel


1. Apply conditional formats to monitor cell values, such as formula results. Stay abreast of dramatic changes affecting your organization, business or personal financial situation like donations increase, sales decline or a bank account overdraft.
2. Know when conditions change. Utilize the conditional formatting color coding system to signal those changes (e.g., red text color can indicate a turn down in stock value). Use conditional formatting in Microsoft Excel to recognize changing conditions to better control the direction and outcome of activities.
3. Open Microsoft Excel and the file you want to affect. Select cells for applying conditional formatting. Use conditional formatting in Microsoft Excel for automatic cell change when a specific condition is met.
4. Choose 'Conditional Formatting' from the 'Format' menu within Excel. See a 'Conditional Formatting' box pop up with options to choose from. Select the 'Cell Value Is' option from the first drop-down menu to utilize existing values in the cells you've selected in the formatting condition. Pick 'Formula Is' instead to enter a formula for the formatting standard if you want to assess information or a condition besides that associated with the values within the cells selected.
5. Type in a constant (number or text) after you have selected the comparison phrase (e.g., 'less than' or 'equal to') for 'Cell Value Is.' Realize a constant is a value that doesn't change since it's not calculated. Start with an equal sign if you choose to enter in a formula.
6. Enter the formula which will evaluate to a logical value, TRUE or FALSE for the formatting criteria for 'Formula Is.' Apply formatting when another condition is met (not based on the evaluation of a condition or data of the selected cell value).
7. Hit the 'Format' button next so that you can access formatting options. Choose one of the tabs, 'Font,' 'Border' or 'Patterns,' once the 'Format Cells' option box pops up. Make your preferred formatting selections to be applied to a condition change or when the formula calculates to TRUE within your selected cells.
8. Click 'Add>>' to include a second or third condition to selected cells. Repeat the same procedure you used for the first condition. Keep in mind that the first condition takes precedence and not all conditions, if met all at once, will be applied by Excel.
Read more ►

Sunday, March 24, 2013

How to Make a Formula in Excel


Simple Math Formulas
1. Open Microsoft Excel by clicking on your Desktop shortcut or by selecting it from the Windows Start menu. You will automatically get an Excel Workbook. The workbook has three blank worksheets that Excel has named Sheet1, Sheet 2 and Sheet 3.
2. Remember that each column has a title that Excel uses in formulas, and each row has a number. The place in a worksheet where a row and column meet is a cell. Each cell's name is made with a column letter and the row number. The first cell at the top of the worksheet is A1. The next cell to the right is B1.
3. Start typing your numbers that you want to calculate in Sheet 1. You can type the numbers in a single column or you can type them across the rows. You also have the option of typing your data in more than one column or row.
4. Put the cursor in the first empty cell below the data in your column or at the end of your first row. Notice that Excel displays the cursor location and cell name below the toolbars at the top of the screen.
5. Begin every formula by typing the equal sign. Excel immediately displays it in the Formula Bar that is above the worksheet's first row.
6. Click the first cell that you want to include in your formula. Excel adds the cell name to your formula. Type a mathematical function. If you are adding numbers, use the plus sign on your keyboard. For subtraction, use the minus sign. To divide, use the slash on the question mark key. To multiply, Excel uses the asterisk, above the number 8 on the keyboard.
7. Click each cell that you want in your formula, then type the arithmetic function that you need. Click the green check mark at the beginning of the formula bar when your formula is finished.
AutoSum
8. Use Excel's AutoSum button for faster addition of one column or row of numbers. It will be much easier than clicking on each cell and typing the plus sign.
9. Place your cursor in the first empty cell after your numbers. Click the AutoSum button. It resembles a fancy capital letter E and is located on Excel's editing toolbar. Excel highlights all the cells in the column above until it reaches an empty cell. For data in rows, Excel selects data to the left of the cursor.
10. Click the green check mark in the formula bar to complete the formula.
Use Excel Functions in Formulas
11. Make a formula with Excel's built-in mathematical functions by placing your cursor in an empty cell first. Then type the equal sign to start the formula. Choose Formulas, and then choose Insert Function in Excel 2007. In Excel 2003, click to open the Insert menu, then select Function from the drop-down list.
12. Select the function that you want. Your choices include financial, date, time, statistical, engineering, trigonometry, logical and many others, arranged in categories. To see all of the functions, select All in the category drop-down box.
13. Select the function that you need by highlighting it in the function list. Click on it to insert it into your formula. Excel places it in the formula bar. Select the function COUNT or AVERAGE to try this out.
14. Complete your formula by clicking each cell that you want to include in the formula. After you finish adding cells, click the green check mark. Excel displays the results of your function's calculation.
Read more ►

How to Create a Conditional Formula in Excel 2007


1. Open an existing or new Microsoft Excel 2007 document. Click 'Start' from the main operating system menu. Then choose 'Programs' from the start menu. Select 'Microsoft Office' from the programs menu. Next, choose 'Microsoft Excel' from the Microsoft Office menu. Now either choose 'New' from the main menu or locate the existing Excel document to use for a conditional formula.
2. Establish the parameters for the conditional formula. For example maybe a person can create a conditional formula for an invoice discount. That way if the invoice is paid in under a certain number of days then a client would receive a percentage discount.
3. Structure the conditional formula. In this example say that if the invoice is paid in less than thirty days, the customer receives a five percent discount. The conditional formula would look like this: IF((C5-B5)
4. Type the conditional formula in the spreadsheet. A person can either type the formula in or use the conditional function. To use the conditional function click on the 'Formulas' tab and choose the 'Logical' option from the format library.
5. Enter the conditional formula in the 'If' formula function dialogue box. Once the 'If' function dialogue box appears enter the previous formula parameter in the provided input boxes. In the 'Logical_test' box enter 'C5-B5
6. Test and save the Microsoft Excel 2007 spreadsheet. Be sure that the conditional formula is working correctly by observing the results and check them against the known data. When the formula is satisfactory, save and close the spreadsheet.
Read more ►

How to Set Up an Employee Schedule in Excel


1.
Open a blank Excel worksheet. Go to the 'Insert' tab in Excel 2007 or the 'View' menu in Excel 2003 or earlier and select 'Header Footer.' Select 'Custom Header' and enter 'Employee Schedule.'
2.
Go to the 'Page Layout' tab in Excel 2007 and click on 'Orientation.' Select 'Landscape.' In Excel 2003 or earlier, go to the 'File' menu and select 'Page Setup.' Select 'Landscape' on the 'Page' tab. Enter 'For the week of:' in cell 'A1.' Select cell 'A4.'
3.
Set up the cell by changing the font size to '12' and select 'Bold' in the 'Font' group of the 'Home' tab in Excel 2007 or on the 'Formatting' toolbar in Excel 2003 or earlier. Type in the first day of the scheduled workweek for employees.
4.
Select cell 'B4.' Type in the first scheduled time for employees to start work. Enter increments of time in the remaining cells of 'Row 4.' These may be hour or half hour increments, or you might want to only enter shift change times.
5.
Select cell 'A5.' Enter the name of the first employee by alphabetical order. In cell 'A6,' enter the next employee alphabetically, and so on until all employees are set up in the schedule.
6.
Skip a row and repeat steps 3 through 5 with the second day of the workweek. Repeat with the remaining days of the workweek. Add color to the cells containing days, times and employee names by using the 'Fill Color' button in the 'Font' group of the 'Home' tab in Excel 2007, or the 'Formatting' toolbar in Excel 2003 or earlier.
7.
Save the employee schedule as an Excel template. Click the 'Office Button' in Excel 2007 or the 'File' menu in Excel 2003 or earlier and select 'Save As.' Enter 'Employee Schedule' under 'File Name.' Select 'Excel Template (*.xltx)' under 'Save as Type' in Excel 2007 or 'Template' in Excel 2003 or earlier and click 'Save.' This will allow you to reuse the schedule without having to set it up again.
Read more ►

Saturday, March 23, 2013

How to Remove 'Getting Started' From Microsoft Excel


1. Launch the Excel application.
2. Click 'Tools' and then 'Options.'
3. Click the 'View' tab. Remove the check mark next to 'Startup Task Pane' and click 'OK' in the dialog box.
Read more ►

Friday, March 22, 2013

How to Make an Excel Sheet Into a Form


1. Open Excel 2010 and select a workbook containing data. Click the 'File' tab and select 'Open.' Browse the files and locate the workbook. Click the workbook and select the 'Open' button. The workbook will open.
2. Add the form to the Quick Access Toolbar by clicking the right drop-down arrow on the Quick Access Toolbar. Select 'More Commands.' Click 'All Commands' in the 'Choose Commands From' section. Drag the scroll bar down and click 'Form.' Click the 'Add' button to add the button to the Quick Access Toolbar. Click 'OK.'
3. Highlight the data in your spreadsheet. Make sure you highlight the column headers too. Click the 'Form' button. A form will appear containing your data.
Read more ►

How to Create a Flow Chart in Excel 2007


1.
Open an Excel worksheet. Go to the 'Insert' tab of the ribbon and click the 'Shapes' drop-down arrow. Select the first shape you want to use from the 'Flow Chart' shape gallery.
2.
Click on the worksheet where you want to place the first shape. Go back to the 'Shapes' gallery, click on the next shape you want to use and place it on the worksheet. You can click on a shape, hold down the mouse button and drag it into position as well. Repeat until all the shapes you need are on the worksheet.
3.
Go back to the 'Shapes' gallery and select the first connector you want to use in the 'Lines' gallery. Click on the first shape in the flowchart from where you want the connector line to begin. Click on the second shape where you want the connector line to end. Repeat with the remaining shapes.
4.
Right-click the first shape and select 'Add Text.' Type a brief description for the first step in the process. Repeat with the remaining steps.
5.
Go to the 'Format' tab and select a color scheme from the 'Smart Art' gallery, or apply effects such as '3-D' or beveled lines. Save the worksheet when you are finished.
Read more ►

How to Reduce File Size in Excel Without Using Software


1. Click on any cell in the Excel file you want to reduce. Open the 'Go To' dialog box in Excel 2007 by clicking the 'Find' drop-down arrow on the Home tab of the ribbon and selecting 'Go To.' In Excel 2003 or earlier, go to the 'Edit' menu and select 'Go To.' You can also use the keyboard shortcut 'Ctrl G' in any version of Excel.
2. Click the 'Special' button on the 'Go To' dialog box. Select 'Blanks' and click 'OK.' Click the 'Clear' drop-down in the 'Editing' group in Excel 2007 and select 'Clear All.' In Excel 2003 or earlier, go to the 'Edit' menu, point to 'Clear' and select 'All.' This will clear any blank cells to help reduce the file size.
3. Go to the very last cell containing data in the Excel file. Select the entire row beneath this cell by clicking the number to the left of it. Hold 'Ctrl Shift' and then press the down arrow key to select all of the cells beneath this point.
4. Click the 'Clear' drop-down in the 'Editing' group in Excel 2007 and select 'Clear All.' In Excel 2003 or earlier, go to the 'Edit' menu, point to 'Clear' and select 'All.' Select the column to the right of the last cell. Hold 'Ctrl Shift' and then press the right arrow key. Again, select 'Clear All.'
5. Repeat Steps 1 through 5 for any other Excel files that are linked to the workbook you are trying to reduce. Save the files and then check the new file size by clicking the 'Office Button' in Excel 2007. Point to 'Prepare' and then click on 'Properties.' In Excel 2003 or earlier, go to the 'File' menu and select 'Properties.' The file size will be listed on the 'General' tab.
Read more ►

Thursday, March 21, 2013

Microsoft Excel 2003 Is Slow in the Page Break Preview


1. Open the Microsoft Excel 2003 file on your computer that contains the page breaks that you are having problems with.
2. Click the 'Tool' menu from the top of the page and then click the 'Options' button. The Options dialog box will then appear on your screen.
3. Click the 'View' tab. Click the box next to the 'Page breaks' field so it is no longer checked.
4. Click the 'OK' button and you will close the dialog box. The page breaks view will be disabled.
5. Click the 'File' option and then click the 'Page Setup' option. Select any changes to meet your preferences and then return to your document.
Read more ►

How to Use Excel to Calculate Coefficient of Variation


1. Enter the data to be analyzed in one column of an Excel spreadsheet.
2. Use the Excel AVERAGE() function to calculate the mean of the data. In a blank cell on the spreadsheet, type '=AVERAGE(' (without quotes) and highlight all of the cells containing the data. Press 'Enter' to see the mean of the data.
3. Use the Excel STDEV() function to calculate the standard deviation of the data. In a second empty cell, type '=STDEV(' (without quotes) and highlight the data. Press 'Enter' to view the standard deviation of the data.
4. Divide the standard deviation by the mean: in a third empty cell, type '=' (without quotes) and click on the cell containing the standard deviation. Type '/' (without quotes) and click on the cell containing the mean. Press 'Enter' to view the coefficient of variation.
Read more ►

How to Convert Multiple Columns in Excel to a Single List in Word


1. Open the Excel 2010 file that you want to work with. Right-click on the 'A' above the first column and choose 'Insert.' This creates a blank first column that you will use to construct your list.
2. Press 'Alt' and 'F11' to launch the Excel VBA console. Right-click on any worksheet in your current workbook -- these are listed on the left side of the console -- move your mouse over 'Insert' and choose 'Module.' Double-click on the module which appears in the list.
3. Copy the following code and paste it into the white space on the right side of the VBA console:Sub Combine()Range('B1').SelectDo While ActiveCell > ''Range(ActiveCell, ActiveCell.End(xlDown)).Copy Destination:=Range('A10000').End(xlUp).Offset(1, 0)ActiveCell.Offset(0, 1).SelectLoopEnd SubThis code creates a macro, called 'Combine,' which combines all adjacent columns, starting with column 'B,' into one long list in column 'A.' If you think the total number of cells will be larger than 10,000, increase the number '10000' in the code so that it will be larger than the number of all your cells combined. The macro runs until it encounters a blank cell in the top row of a column.
4. Click the 'Play' button in the middle of the bar at the top of the VBA console. This creates your list in column 'A.' Click the 'X' in the top-right corner of the VBA console to close it.
5. Select the 'A' above the first column to select the entire column. Press 'Ctrl' and 'C' to copy the information to your clipboard.
6. Open the Microsoft Word 2010 file where you want to paste the list. Click the document to place your cursor wherever you want to insert the list.
7. Click the bottom of the 'Paste' button to open up a pop-up window. Choose the icon labeled with a large 'A' to insert the information as text.
8. Click the last item in the inserted items and hold the mouse button down. Drag the mouse up to the first item and release the mouse button, selecting the entire range of items. Click the 'Home' tab at the top of the screen and find the 'Paragraph' section. Click the 'Bullets' or 'Numbering' buttons to turn the information into a list.
Read more ►

How to Change Pivot Table Source Data


Microsoft Excel 2007
1. Open the Microsoft Excel 2007 application on your computer. Click on the “Microsoft Office” button from the top-right corner of the application.
2. Click on the “Open” option and then locate the Excel 2007 file that contains the pivot table for which you want to change the data source. Click on the “Open” button.
3. Click on the “Options” tab from the top toolbar menu and then click on the “Change Data Source” button from the “Data” group.
4. Click on the radio button next to the “Select a table or range” field. Click on the button in the “Table/Range” field.
5. Select the new range for your data within the pivot table and then click the “OK” button in the Change Pivot Table Data Source dialog box.
Microsoft Excel 2003
6. Open the Microsoft Excel 2003 application on your computer. Click on the “File” option from the top toolbar menu.
7. Click on the “Open” option and then find the Excel 2003 file that contain the pivot table for which you want to change the data source. Select the file and then click on the “Open” button.
8. Right-click on any cell in the pivot table and then click on the “Wizard” option. The PivotTable and PivotChart Wizard will appear on the screen.
9. Click on the “Back” button. Select the radio button next to the “Existing worksheet” field and then click inside of the text box.
10. Select the new range for your pivot table within the spreadsheet and then click on the “Finish” button from the dialog box.
Read more ►

Wednesday, March 20, 2013

How to Find Delete Multiple Instances in Excel


1. Click the Windows 'Start' button and select 'All Programs.' Click 'Microsoft Office' followed by 'Microsoft Excel' to open the spreadsheet software.
2. Click the 'File' ribbon tab, then click 'Open.' Double-click the Excel spreadsheet file that contains the duplicate values.
3. Highlight all the cells you want to check for duplicates. Click the 'Data' ribbon tab at the top of the window. Click 'Delete Duplicates' to start the wizard.
4. Check the box for each column you want to check from the selection. If you want to check all columns, click 'Select All.'
5. Click 'OK' to run the duplicate checker. The window displays the number of duplicates found. Click 'OK' to delete the duplicate instances.
Read more ►

How to Unlock an Excel Workbook Without Knowing the Password


1. Download and install Excel Password Remover 2010 from Straxx.com (see Resources). This is an Excel add-in file that will place two new options, 'Unlock sheet' and 'Unlock Workbook,' under the 'Tools' menu. This is an effective, free program.
2. Try Passware Kit Basic 10.1 (see Resources). This software can recover passwords for Microsoft Word, Excel, and Powerpoint files, as well as passwords for email accounts, network connections and local Administrators.
3. Download Excel Password Recovery Master (see Resources). This software offers near instant recovery of password. Length and complexity of passwords do not affect the speed at which they are recovered. Excel Password Recovery Master also supports Multilingual passwords.
Read more ►

How to Convert MS Excel Files to PDF


1. Open the MS Excel file that contains your document.
2. Ensure that the 'Print Area' has been properly defined. Go to 'Page Layout,' click 'Print Area' and finally, select 'Set Print Area' from the main menu. You will see a dotted line that represents the selected print area.
3. Select 'File' then 'Print' from the main menu. The 'Print and Printer' selection menu appears.
4. Select 'Adobe PDF' from the Printer drop-down selection.
5. Click 'Print'. The 'Save PDF File As' dialog window appears.
6. Navigate to the directory where you wish to save your PDF files and click the 'Save' button. The Adobe PDF progress bar appears and the PDF file is now created.
Read more ►

How to Change Ribbons in Excel 2007


1. Open Excel 2007.
2. Click on one of the following tabs: 'Insert,' 'Page Layout,' 'Formulas,' 'Data,' 'Review' or 'View.' If you previously placed a check in the Excel Options box labeled 'Show Developer tab in the Ribbon,' the rightmost tab you will see is the 'Developer' tab.
3. Click on 'Home' to return to the 'Home' Ribbon.
Read more ►

Tuesday, March 19, 2013

How to Use Freeze Frames in Excel


1. Open an Excel spreadsheet with some data.
2. Choose which rows and/or columns to freeze. To freeze rows only, select the row immediately beneath the row or rows you want to remain visible. To freeze columns only, select the column immediately to the right of the column or columns you want to remain visible. To select both rows and columns, select the cell immediately below and to the right of the row and column you want to remain visible.
3. Click the 'Window' menu in Excel 2003. Click the 'View' tab in Excel 2007/2010.
4. Click 'Freeze Panes' in Excel 2003 to complete the process. Click the 'Freeze Panes' option with the down arrow and continue to the next step in Excel 2007/2010.
5. Select 'Freeze Panes' from the drop-down menu in Excel 2007/2010 to complete the process.
Read more ►

How to Dock Windows in Excel Visual Basic Editor


1. Open Excel and then open VBA. The shortcut to opening VBA is 'ALT F11.'
2. Select the 'Tools' menu then select 'Options.'
3. In the dialog box, click on the 'Docking' tab. Make sure all the boxes are check on this tab, then click 'OK.'
4. The toolbar windows can be docked simply by moving them towards a side of the window pane. The code windows can be docked by double clicking on the header or clicking on the 'Maximize' button in the upper right corner. The code windows are undocked by selecting the greyed 'Restore Window' button in the upper right corner. Code windows can be alternated between by using 'CTRL Tab.'
Read more ►

How to Set the Number of Decimal Places to Appear in a Microsoft Access Table Field


1. Open your table in Design view.
2. Create a Number or Currency field, or click in a Number or Currency field that already exists.
3. Click on the General tab in the Field Properties box at the bottom of the screen.
4. Click in Decimal Places. A small arrow appears on the right side of the text box.
5. Click on the arrow to produce a menu of choices.
6. Select the number of digits to appear to the right of the decimal place.
7. Save your table.
Read more ►

Monday, March 18, 2013

How to Set Up a Spread Sheet for Profit Loss in a Small Business


1. Open Microsoft Excel and locate the template gallery.To find the template gallery in Excel 2003, select 'File' and 'New.' Using the right task pane, locate the templates search box. Type 'profit loss statement.' You will see all of the available templates. Download the profit loss statement.To find the template gallery in Excel 2007, select the 'Office' button and select 'New.' Using your search box, type 'profit loss statement.' You will see a list of matching templates. Download the profit loss statement.
2. Customize the Excel template to your business needs. Since this statement is a comparison of your business performance during different time periods, decide how often you want to generate this report.Open the template and enter the company name, time frame and date of the report.Adjust the sale revenue and cost of sales section by adding products or services that your company sells. This may require you to add or delete rows.To add products and services, type over the generic products and services included in the template. If you need additional rows for more products and services, right click on an existing product row number and select “Insert.” To delete a products and services row, right click on the existing product row and select “Delete.”
3. Adjust your operating expenses section. Add or remove any expenses that do not apply to your business. Clarify the taxes section to reflect the taxes you are responsible for.To adjust add additional expenses, type over the generic expenses. If you need additional expense rows, right click on the row number and select “Insert.” To remove an expense row, right click on the row number and select “Delete.”
4. Save your changes in Excel 2003 by selecting “File” and “Save As.” Type in a name for your template and change your Save As Type to “Template.”Save your changes in Excel 2007 by selecting the “Office” button. Select “Save As” and then select “Other Formats.” Type in a name for your template and change the Save As Type to “Template.'
Read more ►

How to Solve Probability Equations With Excel


1. Click the 'Fx' button just under the ribbon.
2. Select the down arrow to the right of 'Or select a category.'
3. Select the type of probability equation you want to solve from the 'Select a function' list. There are dozens of functions to choose from, including NORMSINV, which returns the inverse of the standard normal cumulative distribution and PERMUT, which returns the number of permutations possible from a given number of objects.
4. Follow the directions in the pop-up window to input the data necessary to solve the probability equations. Some functions, like the COMBIN function, ask you to type the data directly into the window. Other statistical functions may require you to input the data into the spreadsheet.
Read more ►

Sunday, March 17, 2013

How to Make a Data Table in WordPad


1. Click the “Start” button or press the “Windows” button. The Start menu appears.
2. Type “WordPad” in the Search text box. Search results appear.
3. Click “WordPad.” A blank WordPad document screen appears.
4. Click the “Home” tab on the Ribbon.
5. Click on the document screen where you wish to set the table.
6. Click the “Insert Object” button in the Insert group. The Insert Object dialog box opens.
7. Click the “Create New” radio button.
8. Select the “Microsoft Excel Worksheet” program in the Object Type text box.
9. Click “OK.” The Insert Object dialog window closes. A Microsoft Excel worksheet appears.
10. Type the values in the Excel worksheet. Another option includes inserting an Excel table in the Excel worksheet. Click the “Insert” tab on the Excel Ribbon. Click and drag the cursor on the Excel worksheet to select and highlight the rows and columns for the data table. Click the “Table” button in the Tables group. A table appears in the Excel worksheet. Type the values in the table on the Excel worksheet.
11. Click the “X” or “Close” button of the Excel screen. Close the Excel worksheet to copy the data values to the WordPad document.
12. Save this WordPad document.
Read more ►

How to Add Two Cells in Excel 2003


1. Open Excel. 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. Determine which cells you would like to add. Click on the cell where you want your total to appear.
3. Enter an equal sign, followed by the word SUM, begin parenthesis, the column and row of your first cell, comma, then the column and row of your second cell and end parenthesis. For example =SUM(A2,B6).
4. Appearing in the cell will be the sum of the two cells. Your equation will appear in the formula bar.
5. Delete the answer if you do not want it to show by highlighting the cell and pressing the 'Delete' button on your keyboard.
Read more ►

How to Convert Labels to Avery 5160


1. Open Word 2010 and select the 'Mailing' tab. Click the 'Start Mail Merge' wizard. Click 'Labels.' The label dialog box appears. Select 'Avery' in the vendor list and locate the 5160 labels. Click 'OK.'
2. Click the 'Select Recipients' button. Select 'Use Existing List.' Browse the computer and locate the Excel workbook containing the label information. Select the workbook and click the 'Open' button. The table dialog box appears. Select the worksheet that contains the label data. Click 'OK.'
3. Click the 'Insert Mail Merge' button. A drop-down list appears. Select a field from the list. Click the 'Preview Results' button to preview the label changes. Click 'Update Labels' to apply the new changes to all of the labels.
4. Click 'Finish Merge' to finalize the mail merge process. Select 'Edit Individual Documents.' Click 'All.'
Read more ►

How to Align Text in Cells in Excel 2003


1. Open your Excel worksheet.
2. Select the cells containing the text you wish to align. To select, click on each cell individually while holding down the 'Ctrl' key or drag your mouse across the cells.
3. Click 'Format' on the top menu to see the dropdown list of formatting options.
4. Select 'Cells.' A new window will appear with cell formatting options.
5. Click the 'Alignment' tab to study options for aligning the text in your cells.
6. Select the appropriate text alignment features.
7. Click 'OK' to implement your changes. Then save your work.
Read more ►

How to Unhide Columns in Microsoft Excel 2003


1. Highlight the columns that house the hidden columns. To unhide a column, left-click and hold with the mouse on the column letter to the left of the hidden column. Then drag the mouse cursor over that column letter and the one directly to the right of it, highlighting both the columns that sit adjacent to the hidden column.
2. Access the column's Properties menu to unhide. Once you have highlighted the columns, right-click on them to access the submenu.
3. Unhide the column. To unhide the column, scroll to “Unhide” and left-click.
4. Save any changes. To quickly save any modifications to your spreadsheet simply press the hotkeys “CTRL-S.” This will save your file.
Read more ►

Saturday, March 16, 2013

How to Make a Budget on Excel 2007


1. Open Microsoft Excel 2007. Select the 'Office' button and click 'New.' In the 'New Workbook' dialog box, click on the 'Installed Templates' or 'Budget' group to find budget templates that are inbuilt into Excel.
2. Pick a template that works for you. Hit the 'Create' button to use the template.
3. Check out the data and structure of your template. Type in your monthly expenses by selecting the applicable cell and entering the correct data into the cell. Remove any data you don't need by selecting the applicable cell and hitting the delete key or deleting the entire row.
4. Change the monthly income to match your income. The budget will automatically deduct your expenses from the income column.
5. Save your newly created budget by clicking the 'Office' button and choosing 'Save.' Name your file in the 'Save As' dialog box and hit 'Save.' You may reuse the budget for upcoming months and re-save your file by clicking the 'Office' button and choosing the 'Save As' option.
Make a Budget on Excel 2007 from Scratch
6. Open Microsoft Excel 2007.
7. Create columns for your expenses, their projected cost and actual cost in your blank worksheet. Then place your expenses under each header.
Example:
Expense: Electricity
Projected Cost: 75
Actual Cost: 70
8. Enter all the expenses for each bill. Then place your cursor in the blank row just after the last entry of your 'Actual Cost' column. Use Excel's inbuilt formula to calculate the total for your monthly cost by clicking the 'AutoSum' button. Excel will highlight the cells that are being calculated in the 'Actual Cost' column. Hit 'Enter' to accept the calculations.
9. Create columns for your income and balance. Then enter your information under each header.
Example:
Income: 3480
Balance: (calculated automatically)
10. Calculate your balance for the month by selecting the blank cell below or beside the 'Balance' column and typing an '=' sign (no quotes) in the formula bar. Then click on the cell that includes your income and type a '-' sign (no quotes) in the formula bar. Click on the cell that includes your 'Actual Cost' total and hit 'Enter.' Your balance will now appear in the empty cell beside/under 'Balance.'
11. Double-check that your figures are correct and save your file (by selecting the 'Office' button and hitting 'Save.' Your Excel 2007 budget is now complete.
Read more ►

How to Sort Columns by Date in Excel


1. Click on the columns you would like to sort. For example, if you want to sort column A, click on the 'A' column header to highlight the entire column.
2. Click on the 'Data' tab, then click on 'Sort.' This will open the sort dialog box.
3. Click on the 'Continue With the Current Selection' radio button, then click on 'Sort.'
4. Click on the arrow underneath 'Order' and select either 'Newest to Oldest' or 'Oldest to Newest' depending on which way you want to sort the dates.
5. Make sure the 'Sort on' selection box reads 'Values,' then click on 'OK.' Excel will sort the column according to date.
Read more ►

How to Create Input Forms in Excel 2003


1. Open the file you want to modify in Excel 2003. If you have multiple worksheets, go to the worksheet you want to edit.
2. Add column headings to the first row of the spreadsheet. To insert a row, click on the row header for the first row. Right-click and select 'Insert.'
3. Go to cell 'A1' and type a heading for that column. Press the 'Tab' key to advance to the next column.
4. Add column headings to the remaining columns on the worksheet.
5. Highlight the content you want to include in the input form, such as the column headings and any existing content in the spreadsheet.
6. Select 'Data' and 'Form' from the toolbar. If Excel displays a message box, click 'OK' to use the first row for labels. A dialog box for the input form you've created opens.
Read more ►

How to Extract the Last Word in a Cell


1. Open Excel and click 'File' and 'Open,' browsing to the file of raw data. Highlight the file and click 'Open.'
2. Create a blank column next to the first column of raw data you would like to parse. For example, if column 'A' is the first column of raw data, then right-click on the 'B' and select 'Insert.' This will provide you with a new, blank column.
3. Type '=RIGHT(A1,LEN(A1)-FIND('*',SUBSTITUTE(A1,' ','*',LEN(A1)-LEN(SUBSTITUTE(A1,' ','')))))' into cell B2 and click 'Enter.' This formula breaks down the line of text in cell A1 in the following manner:'LEN(A1)-LEN(SUBSTITUTE(A1,' ',''))' makes a count of the spaces.'SUBSTITUTE(A1,' ','|', ... )' replaces the last space with a '|.''FIND('|', ... )' finds the position of the '|.''Right(A1,LEN(A1) - ... ))' returns all characters after the '|.'
4. Click and hold the bottom-right corner of cell B1 and drag it down in order to pass the formula down to the remaining cells.
Read more ►

How to Create a Stock Chart in Excel 2007 With Multiple Stocks


1. Open Excel. Create a new document or open a spreadsheet that already contains stock data.
2. Enter or arrange the stock price data into columns. Each column should represent the changes in a stock's price. For example, if you are creating a chart of daily activity in the stock market for four specific stocks, use the first four columns, A through D. Label the stock name or ticker symbol at the top of each column in row 1, then place the daily price data in the subsequent rows. Do not skip rows or leave any cells blank.
3. Select the entire data set by dragging the mouse from cell A1 to the right through all the stocks' columns and then down through all the rows to the last day of information. When done, the entire data set should be highlighted within the Excel window.
4. Click the 'Insert' tab on the ribbon toolbar at the top of the Excel 2007 window. Locate the 'Charts' group within this tab.
5. Click on the 'Line' chart option and then choose any line chart format that appeals to you. A chart is automatically inserted into the spreadsheet containing all the data you selected. Each column is drawn as a separate line on the chart. The overlapping lines show the different stocks' price moves together in one chart.
Read more ►

How to Add an XML Map to an Excel Spreadsheet


1. Launch Microsoft Excel and open the spreadsheet to which you want to add the XML map.
2. In Excel 2003, click the 'Data' tab and put the cursor over 'XML.' On the drop-down, select 'XML Source.' In Excel 2007, click 'Data,' then click 'From Other Sources' in the drop-down, then click 'From XML Data Import.'
3. Click on the 'XML Maps' button and then click 'Add.'
4. Locate the XML schema you want to map to the spreadsheet and then click 'Open.'
5. Click 'OK' to map the XML schema to the spreadsheet.
Read more ►

Friday, March 15, 2013

How to Learn MS Excel Macros


Learn How to Record a Macro
1. Access the 'Macro' menu from the 'Tools' menu and click on 'Record New Macro.' This will open a dialog box in which you will type a name for the macro. When you click the 'OK' button, the macro will automatically begin to record and a small window with a 'Stop' button will appear.
2. Perform the set of functions that you would like to have in your Macro. If you would like to average a set of numbers, add a dollar sign and put a black border around the cell, carry out all of those tasks. The functions and commands you perform will record in the order in which you complete them.
3. Press the stop button to cease recording. You now have a macro that can average numbers, add a dollar sign and put a black border around the call with just one click.
Learn How to Run a Macro
4. Get to the 'Macro' option through the 'Tools' menu. When you click on 'Macro,' it will bring up a list of all available macros saved in your Excel.
5. Make a button for the macro to add to your toolbar. To create the macro button, go to the 'Tools' menu and select 'Customize' from the list. Go to the 'Commands' tab and click 'Macros' under the 'Categories' section. Drag the custom button of your choice to the toolbar. Go to 'Modify Selection' in the 'Customize' window and click on 'Assign Macro'. Choose the name of your macro from the list of macros that comes up and press the 'OK' button. The button will now stay on your toolbar and with one-click will perform all of the recorded functions.
6. Create your own keyboard shortcut. This will allow you to run the macro by pressing a combination of keys on the keyboard. To make a shortcut, click on 'Macro' under the 'Tools' menu. Choose your macro from the list and go to 'Options'. A window will come up with a place for a 'Shortcut key'. Pick a key to use as the shortcut for your macro, keeping in mind that some keys are already shortcut keys in Excel, such as Ctrl P for paste and Ctrl X for cut. After you have entered your key, click 'OK.' Your macro will now run automatically when you press the Ctrl key and the key that you assigned for your macro.
Read more ►

How to Insert a Comment Box in Microsoft Excel


Microsoft Excel 2007
1. Open your spreadsheet in Microsoft Excel.
2. Click on the cell where you want the comment to appear. Click on the 'Review' menu, and then 'New Comment' in the 'Comments' section. You can also right-click on the cell and click 'Insert Comment.' A text box will appear with your user name in it.
3. Type your comment. When you are finished, click anywhere in the spreadsheet outside of the text box. The comment box will disappear, but will reappear when you roll the mouse pointer over the cell.
4. Click on the cell, and then the 'Edit Comment' button to edit the comment or 'Delete Comment' to delete it. Use the 'Previous' and 'Next' buttons to jump from comment to comment, the 'Show/Hide Comment' button to display that cell’s comment without having to keep your mouse on it and the 'Show All Comments' button to show all of the comments on the sheet. Click it again to hide them.
Microsoft Excel 1997-2003
5. Open your spreadsheet in Microsoft Excel.
6. Click on the cell where you want the comment to appear. Click on the 'Insert' menu, and then 'Comment.' You can also right-click on the cell and click 'Insert Comment.' A text box will appear with your user name in it.
7. Type your comment. When you are finished, click anywhere in the spreadsheet outside of the text box. The comment box will disappear, but will reappear when you roll the mouse pointer over the cell.
8. Click on the cell and then the 'Insert' menu and 'Edit Comment' to edit the comment. You can also right-click on the cell and click 'Edit Comment' to edit it, or 'Delete Comment' to delete it or 'Show/Hide Comment' to display the comment without rolling your mouse over it. Click it again to hide the comment.
Read more ►

How to Embed Flash Game in Excel Spreadsheet


1. Download free flash game online or use one you already have
2. Open Excel and go to the top left option button. Choose excel options in the bottom right hand corner.
3. Click show developer tab in the ribbon.
4. Go to the developers tab and click insert. Choose insert shockwave object.
5. Create an area on the spreadsheet as large as the window you are working on.
6. Right click the area you just created and choose properties.
1. Make the embed movies option 'True'
2. Find the file you want on your computer and paste the path into the movie option. (exit properties)
7. Click design mode and you now have an active game.
8. Right click the game area on the screen and choose play.
9. Save normally and send it to yourself at work. Have fun.
10. Tell me if it works, I have a game or two at http://best-roulette-strategy.org/free-casino-games.html
Read more ►

How to Use the Freeze Pane Command to Create Static Headings in Excel 2003


1. Open your Excel worksheet once you have logged on to your computer. 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. Highlight the column to the right of the column to be frozen. Go to 'Window'. Select 'Freeze Panes'. A bold line will appear to the right of the frozen column indicating that those panes are frozen.
3. Freeze rows by highlighting the row below the row to be frozen. Repeat Step 3 as needed.
4. Freeze both by highlighting the cell to the right of the column and below the row and repeating Step 3.
5. Enjoy scrolling through your worksheet while your titles stay in place.
Read more ►

How to Use ActiveCell in Excel Using a VBA


1. Launch Microsoft Office Excel, click the 'Developer' tab, and click 'Visual Basic.'
2. Click the 'Insert' menu and click 'Module' to insert a new code module. Type the following code to start a new sub procedure:Private Sub usingActiveCell()
3. Copy and paste the following to activate 'Sheet1:'Worksheets('Sheet1').Activate
4. Copy and paste the following to add a value to 'A1,' 'A2,' and 'A3:'Range('A1').SelectActiveCell.Value = 3.5Range('A2').SelectActiveCell.Value = 10Range('A3').SelectActiveCell.Value = 20
5. Copy and paste the following to highlight the cells with data:With ActiveCellRange(Cells(.Row, .CurrentRegion.Column), Cells(.Row, .CurrentRegion.Columns.Count .CurrentRegion.Column - 1)).Interior.ColorIndex = 8Range(Cells(.CurrentRegion.Row, .Column), Cells(.CurrentRegion.Rows.Count .CurrentRegion.Row - 1, .Column)).Interior.ColorIndex = 8End WithApplication.ScreenUpdating = True
6. Copy and paste the following to display the values added through the 'Immediate Window:'Range('A1').SelectDebug.Print ActiveCell.ValueRange('A2').SelectDebug.Print ActiveCell.ValueRange('A3').SelectDebug.Print ActiveCell.Value
7. Copy and paste the following to end the sub procedure:End Sub
8. Press 'Ctrl' and 'G' to display the 'Immediate Window' and press 'F5' to run the procedure.
Read more ►

Thursday, March 14, 2013

How to Create a Two X Axis Chart in Excel


1. Create a chart that measures two data series against a set of variables using the Chart Wizard. Click 'Finish' and the chart will appear in your worksheet.
2. Click anywhere on the chart. In the top navigational menu, click the 'Format' tab. Click the arrow in the 'Chart Elements' box, and then select the data series you wish to be the secondary plot.
3. Click on 'Format Selection' in the 'Current Selection' section of the 'Format' tab.
4. Click on the 'Series Options' tab in the pop-up window, and then select 'Secondary Axis.' Click 'Close'. You will see a secondary vertical axis appear in the chart.
5. Click anywhere in the chart, then click the 'Layout' tab in the top navigational menu. Click on 'Axes'.
6. Click 'Secondary Horizontal Axis' and then choose your desired layout from the display options. Your secondary plot will change to a horizontal one.
Read more ►

How to Insert an Excel Drop Down Menu Box Into a Word Document


1. Select the Excel cell with the drop-down box by left-clicking it with your mouse.
2. Click 'Ctrl' and 'C' to copy the contents of the box to the clipboard.
3. In Microsoft Word, click on the 'Home' tab.
4. Click the down arrow beneath 'Paste' at the far left of the ribbon (the toolbar). Select 'Paste Special' from the options list.
5. Choose 'Microsoft Office Excel Worksheet Object.' This inserts the object into Word.
Read more ►

Wednesday, March 13, 2013

How to Insert a Calendar Into an Excel Spreadsheet


1. Download a calendar template from Microsoft Office Online. Search through the available templates and, after you find one you like, click the calendar link and select 'Download.'
2. Click 'Accept' to agree to the service agreement and click 'Save' to save the template to your computer.
3. Open the Excel workbook that you want to insert a calendar into. Click the 'Insert' button at the top of the page and select 'Object' from the menu that drops down.
4. Select 'Create from file' in the Object box that opens and click 'Browse' to search for the calendar template. When you find it, select the template and click 'Insert.' The calendar will then appear in your spreadsheet.
Read more ►

How to Convert XLXS to XLS in Microsoft


Convert With Excel
1. Launch Microsoft Excel 2007 or Excel 2010. Open the '.xlxs' file that you want to convert to '.xls'.
2. Click 'File' from the main program menu. Select 'Save As' from the drop-down menu.
3. Select 'Excel 97-2003 Workbook' from the 'Save As' context menu. This converts and saves the '.xlxs' file to an '.xls' file.
Convert With Office Compatibility Pack
4. Launch your Web browser. Navigate to the Microsoft Office Compatibility Pack download page.
5. Click the 'Download' link toward the top of the page. Select 'Save' from the on-screen download prompt to save the 'FileFormatConverters' installation file to your computer's hard drive. Wait for the download to finish.
6. Locate the file in your computer's 'Downloads' or 'My Downloads' folder. Double-click the file to install the Microsoft Office Compatibility Pack. If prompted, restart your computer during the installation process.
7. Open Microsoft Excel. Click 'File' followed by 'Open' to open the '.xlxs' Excel file that you want to edit or view. Excel now converts the workbook document into a format that is compatible with the older version of Excel.
Read more ►

How to Add Hours in Microsoft Excel


1. Create or open an Excel workbook that has hours that need to be totaled. The hours are formatted as h:mm.
2.
In the example at the left, the sum of the column results in an inaccurate number since Excel ignores hours that exceed 24. By reformatting the cell that holds the sum formula, we can correct this situation.
3. Right click in the cell that holds the sum formula, and then click on Format Cells.
4. On the Format Cells dialog box, click on the Number tab if it's not already displaying.
5.
Edit the custom setting, placing brackets around the 'h' as: [h]:mm .
6.
Click OK and you will see that the revised formatting has corrected the display value.
Read more ►

How to Hide Password Protect a Sheet Within Excel


1. Open the Excel worksheet you want to password protect and hide.
2. Place your cursor on the worksheet tab at the bottom of your spreadsheet.
3. Right click over the tab and choose 'Protect Sheet' from the pop-up menu. The “Protect Sheet” dialog box will open.
4. Add a check mark to 'Protect worksheet and contents of locked cells.' Insert the password you want to use into the 'Password to unprotect sheet' text box.
5. Choose the options you want to allow and press 'OK.' Re-enter your password in the “Confirm Password” dialog box and press “OK.”
6. Right click on the worksheet tab again and select 'Hide' from the options. The worksheet will be hidden from view.
Read more ►

How to Use Excel to Find Duplicates in a Long List


1. Open Microsoft Excel and the file that contains your list with duplicates.
2. Highlight the entire column (or columns) that contain the list(s) you want to examine for duplicates by clicking on the column letter(s) ('A,' 'B,' etc.) at the top of your data.
3. Click the 'Conditional Formatting' command in the 'Styles' group under the 'Home' tab, choose 'Highlight Cells Rules' and then choose 'Duplicate Values.'
4. Choose the color scheme you want the duplicate values to be highlighted with using the drop-down menu on the right of the 'Duplicate Values' dialog box that opens, or just click 'OK' to accept the default color scheme and highlight all duplicates.
Read more ►

Monday, March 11, 2013

How to Copy Excel Row Numbers Into Word


Copying a Picture of Excel
1. Click on the 'Page Layout' tab at the top of the screen. Look for the 'Sheet Options' area and place a check mark next to 'Print' under 'Headings.' This will make the row numbers and column letters show up in a printed document.
2. Select the top, left cell from the area that you want to copy. Navigate to the bottom, right cell. Hold 'Shift' and select this cell, highlighting the entire range of cells.
3. Click on the 'Home' tab at the top of the screen. Locate the 'Clipboard' area and select the drop-down arrow next to the 'Copy' button. Select 'Copy as Picture' from the menu, which will open up a small window.
4. Select 'As shown when printed' from the window. This will copy the cells as they would look if you were to print the selected area, including the row numbers and column letters.
5. Open the Word document to which you want to paste the Excel information. Place your cursor where you want to add the cells and press 'Ctrl' 'V' to paste the information.
Read more ►

How Do I Hyperlink to a Hidden Worksheet?


Insert the Hyperlink
1. Open the Microsoft Office document.
2. Click and drag the cursor over the text or image where you wish to insert the embedded hyperlink.
3. Right-click the selected text or image to show a list of commands, including 'Hyperlink.'
4. Click 'Hyperlink.' The 'Insert Hyperlink' dialog window opens. You can also click the 'Insert' tab on the command ribbon and click the 'Hyperlink' button in the 'Links' group.
5. Click the 'Existing File or Web Page' button in the 'Link to' list.
6. Click the 'Recent Files' button to the left of the text box.
7. Click the Excel file from the list.
8. Click 'OK.' The hyperlink appears on the document.
Unhide the Excel Worksheet
9. Point the cursor over the hyperlink. The ScreenTip will display instructions for following the link.
10. Press the 'Ctrl' key and click the hyperlink. The Excel workbook opens.
11. Right-click any sheet tab near the bottom of the screen. For example, 'Sheet 1' or a named worksheet tab. A list of commands appears.
12. Click 'Unhide.' A small dialog box opens with a list of hidden worksheets.
13. Click to select the worksheet in the 'Unhide sheet' text box.
14. Click 'OK' to unhide the worksheet. The dialog window closes. The Excel worksheet appears on the screen.
Read more ►

How to Learn the Basics of Microsoft Excel Free Without a Class


1. Open a new Excel 2010 spreadsheet window. Then open a Web browser window. Click and hold on the top of the Excel window and drag it to the left side of your Windows 7 desktop. The window will automatically adjust its size to fill exactly half the screen. Do the same thing with your browser on the right side of your desktop.
2. Direct your browser to the 'Get to know Excel 2010: Create Your First Spreadsheet' course at the Microsoft Office website (http://office.Microsoft.com/en-us/excel-help/get-to-know-excel-2010-create-your-first-spreadsheet-RZ101773335.aspx). Click the 'Start this course' button.
3. Watch the video that plays in your browser. During the video, click the 'Pause' button in the lower-left corner of the video player to stop the video and test out what you have learned in your spreadsheet window. After the six-minute introductory video is done, select another video from the list on the left side of the browser window. Each of the next six videos will give you information about one basic aspect of Excel 2010.
4. Select 'Practice' from the left side to bring up a practice spreadsheet that will walk you through a few practice routines. Once you feel comfortable, click 'Test yourself' on the left side to bring up a multiple-choice test regarding basic Excel commands. Finally, select 'Quick Reference Card' to open up a printable page that contains a number of basic Excel tasks and instructions to complete them.
5. Visit the Microsoft Excel 2010 Help and How-to page at the Microsoft Office website (http://office.Microsoft.com/en-us/excel-help/CL010253675.aspx?CTT=97). This page gives you a long list of selectable Excel commands and concepts. Select your desired entry to go to a help page surrounding that topic. You can also use the search box at the top of the screen to search the Microsoft Office website for a specific item. Be sure to include 'Excel 2010' in your search query, as the Office website holds articles for all Office products dating back to Office 2000.
6. Use the built-in help system in Microsoft Excel 2010 to address specific areas where you need assistance. Click the blue question mark at the top-right corner of the screen to open up the help window. Select the item from the list on the left, or enter in a search query into the box at the top of the window and press 'Enter,' then select the article you want to look at.
Read more ►

Blogger news