1. Open Excel 2010 and show the Developer tab if it isn't already showing. Click on 'File' and then 'Options.' Click on 'Customize Ribbon' on the Categories pane. Select 'Developer' from the list of main tabs and then click on 'OK.'2. Click on the 'Developer' tab that now should be showing in the Ribbon. Click on 'Visual Basic' to open the Visual Basic editor.3. Double-click on the worksheet in which you want to embed the chart from the Project pain. All of the worksheets that are currently in your project is listed in the pane. The code for the worksheet will open in the Code window. If...
Browse » Home » All posts
Thursday, November 28, 2013
How to Capitalize Everything in a Row in Microsoft Excel 2003
Capitalizing a Row of Cells1. Start Microsoft Excel 2003, and open your spreadsheet.2. Click the row number, not the cell, of the row immediately beneath the one you want to capitalize.3. Right-click and select 'Insert' to insert an empty new row.4. Click the cell in the new row that is directly beneath the left-most cell of the row you want to capitalize.5. Type '=UPPER(name of cell immediately above the one you are typing in)'. Press 'Enter.'6. Click the cell you just typed in to select it, and then hold the cursor in the lower-right corner of the cell until a black plus sign appears.7....
How to Add Buttons to an Excel Spreadsheet
1. Access the Button tool. In Excel 2003 and earlier versions, do this by clicking 'View,' 'Toolbars,' 'Forms' and then clicking the Button tool on the Forms toolbar. In Excel 2007 and later, select the 'Developer' tab, then click 'Insert' and select the Button tool.2. Click where you want the top-left corner of your button to be, and drag to create a rectangular outline. Let go and your button will appear.3. Right-click the button and click 'Assign Macro.' This will bring up a dialog box listing all of Excel's saved macros. (The box may appear as soon as you've created the button, without...
How to Use Data Analysis for Random Number Generation in Excel
Activate the Data Analysis Tool Pack1. Launch Excel from the 'Start' menu or shortcut icon.2. Click on the Microsoft Office orb to open the menu.3. Click the 'Excel Options' option at the bottom.4. Click 'Add-Ins' in the left pane.5. Verify that the 'Manage' field at the bottom is set to 'Excel Add-Ins' and click the 'Go' button.6. Click the check box beside 'Analysis ToolPak' and click 'OK' to install the add-in.Random Number Generation7. Click the 'Data' tab and select the 'Data Analysis Tools' icon.8. Select 'Random Number Generation' from the list and click 'OK.'9. Enter...
Wednesday, November 27, 2013
How to Convert Office 2007 to Excel 2003
1. Open your Web browser, then go to the Microsoft Office Compatibility Pack download page.2. Click the blue 'Download' button at the top of the page.3. Click 'Save' in the download confirmation pop-up box. This downloads the installation file to your computer. Note the save location to help you find the file when you come to install it. The default save location is usually the 'Downloads' library folder.4. Wait for the file to download. Windows displays a progress bar during the download process.5. Find the downloaded installation file -- named 'FileFormatConverters' -- on your computer.6....
How to Scroll on Microsoft Excel
Turning on Scroll Bars in Excel 20101. Open Microsoft Excel 2010.2. Select 'Open' from the 'File' menu.3. Navigate to and double-click the spreadsheet in which you want to scroll.4. Click on 'File' again, then select 'Options.' Click 'Advanced.'5. Locate 'Display options for this workbook' in the right column. Check the boxes next to 'Show horizontal scroll bar' and 'Show vertical scroll bar.' Click 'OK.'Turning on Scroll Bars in Excel 20076. Open Microsoft Excel 2007.7. Click on the Microsoft Office button in the upper-left corner of Excel. Click 'Open.'8. Navigate to and double-click...
Tuesday, November 26, 2013
How to Convert Corel Quattro Pro to Microsoft Excel
1. Click 'File,' then 'Open' in Microsoft Excel 2003 or earlier. In Microsoft Excel 2007, click the 'Office' button, then 'Open.' The 'Open' dialog box appears.2. Locate the Corel Quattro Pro file. Click it once and click 'Open' or double-click the file to open it.3. Save the file as Microsoft Excel spreadsheet. Click on 'File,' then 'Save as' in Excel 2003 or earlier version. In Excel 2007, click the 'Office' button, then 'Save as.' Choose a file location. Leave the name the same or rename the file by typing in the new name in the 'Filename' box. Click 'Sav...
How to Merge Center in Excel
1. Open Outlook by double-clicking on an Excel file. Alternatively, click 'Start,' then 'All Programs,' then 'Microsoft Office' then select 'Microsoft Excel' from the list.2. Click on the 'Home' tab on the menu screen.3. Select the cells you want to merge and center by left clicking on a cell and dragging the mouse until all the desired cells are highlighted. You can tell they are selected by the black line surrounding the cells.4. Click on 'Merge Center' located in the middle of the 'Home' tab menu (it will be under the 'Wrap Text' optio...
How to Make Negative Numbers Red in Excel
1. Highlight the cells containing your data. Note that Excel allows you to apply special formatting for different types of numerical data, such as percentages and currency values. If your data contains numbers formatted as different types, for example, both percentages and currencies, make sure the cells you highlight contain numbers formatted as the same type. If all your numbers are formatted the same way, you can highlight all the cells on a worksheet with one command: press and hold the 'Ctrl' key on Windows (or the 'Command' key on a Mac), and then press the 'A' key.2. Right-click a highlighted...
How to Create a Fillable Order Form
Microsoft Excel 20101. Open Excel 2010 and select the 'File' tab. Click 'New' and type 'order form' in the search box. Hit the 'Enter' key on your keyboard. Excel displays the available templates.2. Preview a template by clicking on one. The preview is displayed in the right task pane. Download the template by clicking it and selecting the 'Download' button. The template downloads to your computer.3. Add your products, sales staff and logo to the form template. Add your name, address and date. Save your template by clicking the 'Save' icon on the Quick Access Toolbar.Google Documents4....
How to Take the Label 'Sum of' Out of a Pivot Table
1. Click on a cell in the PivotTable in the column from which you want to remove 'Sum of.'2. Click the 'Options' tab on the toolbar, then click the 'Field Settings' button under the 'Active Field' area of the toolbar. A small window will pop up.3. Place your cursor in the 'Custom Name' field and erase the 'Sum of' from the name.4. Move your cursor to the end of what is left and add a space to the name. This is because once you remove the 'Sum of,' the remaining name is that same as a recognized field in the field list, and if you try to make a second field, Excel will give you an error....
Monday, November 25, 2013
How to Use Excel's VARP Function
1. Learn the syntax of VARP. It is VARP(number1,number2,...) where number1, number2,... are up to 30 arguments which evaluate to numbers and comprise a complete population. VARP requires at least one argument.2. Use arrays, names or references that contain numbers as arguments for VARP, in addition to pure numbers. Only numbers in an array or reference will be counted. Empty cells, error values, logical values or text in an array or reference will be ignored.3. Enter logical values and text that represents numbers directly into the argument list. Error values or text that does not evaluate...
Sunday, November 24, 2013
How to Extract Tables From Multiple Word Documents Import Them to Excel
1. Use Windows Explorer to copy a Word file containing at least one table to the folder 'C:\.' Rename the file as 'table.docx.' You'll write an introductory program that will read a table cell from this file.2. Click the 'Developer' tab, then click the 'Visual Basic' button to enter the Visual Basic programming environment. Paste the following program into VB code window. This program creates a link to Word, which allows excel to use Word's virtual objects just as though the program were running inside a Word document. This process is called 'Automation.'Public Sub LoadWordTablebak()Dim pgmWord...
How to Create a Form in Microsoft Excel 2007
1. Launch Excel from the start menu or from the desktop. Click the small drop-down arrow at the very top of the screen, to the right of the Save, Undo, and Re-do buttons. In the menu that appears, choose 'More commands.' The Excel Options screen should appear.2. In Excel Options, click the drop-down at the top of the left-hand list of commands, labeled 'Choose commands from.' In the list that drops down, choose 'All commands,' which is the third item down from the top. In the list box below the drop-down, a long list of commands will appear, sorted alphabetically. Locate the command named...
How to Paste Special HTML in Microsoft Excel 2003
1. Create the desired HTML that you wish to paste special into Excel with.2. Copy the HTML code. You can easily copy the HTML by highlighting it all and pressing the hotkeys “CTRL-A” and then by pressing the hotkeys “CTRL-C.”3. Access the 'Paste special' menu. To access this menu, you will need to scroll to the “Edit” tab and select “Paste Special.”4. Set the paste special options. Under the paste special properties menu, in the “As” box, you should left-click on “HTML” to select the format.5. Paste special the HTML into Excel. Now click on the “OK” button to paste special HTML into...
Subscribe to:
Posts (Atom)