Compare Worksheets in the Same Workbook1. Click the 'View' tab and click 'New Window' from the 'Window' group.2. Click the 'View Side by Side' button from the 'Window' group.3. Click the tabs at the bottom of each worksheet to display the worksheets you want to compare.4. Click the 'Synchronous Scrolling' button from the 'Window' group to scroll both worksheets at the same time.Compare Worksheets from Different Workbooks5. Open both workbooks that contain the worksheets that you want to compare.6. Click the 'View' tab and click 'New Window' from the 'Window' group.7. Click the 'View...
Browse » Home » Archives for August 2013
Wednesday, August 28, 2013
How to Insert Hyperlinks and Email Addresses in Microsoft Excel 2003
1. Select the cell that you wish to insert an email address or a hyperlink. You will first need to select a cell where you would like to insert the hyperlink or the email address. You can do this by hovering the mouse cursor over the desired cell and left-clicking to activate that cell.2. Access the insert hyperlink/email address menu. Scroll to the “Insert” tab on the command bar and select “Insert Hyperlink.” An insert hyperlink properties menu will open. If you are wanting to insert an email address instead of a hyperlink, left-click on the “Email Address” icon in the lower left side of...
How to Put White Space in Cells in Excel 2003
1. Click a cell that you wish to add white space.2. Click the formula bar at the top of the screen.3. Type the following in the formula bar: =' 'Substitute the exact number of spaces that you wish to add to the cell between the quotation marks.4. Right-click the cell and click 'Copy' in the menu.5. Highlight all cells that you wish to add white space.6. Right-click the selection and click 'Paste' to add the blank spaces to all selected cel...
How to Make Standard Deviation Charts in Excel 2003
1. Open the Microsoft Excel 2003 application on your computer. Click on the “File” option from the top toolbar menu and then click on the “Open” option.2. Locate the Excel 2003 file that contains the chart you want to work with from your desktop or folder where you store your Excel files. Select the file so it’s highlighted, and click on the “Open” button.3. Click on the line, bar or dots of your graph, which represent your data. Click on the “Format” option from the top toolbar menu and then click on the “Selected Data Series” option.4. Select the shape or color of error bar you want...
How to Hide Macros in an Excel Workbook
1. Open Microsoft Excel and navigate to the 'Menus' tab at the top, left corner of the screen. Click the 'Files' drop-down menu and select 'Open.' Double-click the name of the Excel workbook that has the macro you want to hide.2. Navigate to the 'Developer' tab, which is located at the top, right corner of the window. Click the 'Macros' button, which is positioned at the left side of the navigation ribbon and to the right of the 'Visual Basic' button.3. Scroll through the list of macros and locate the name of the macro you want to hide. Click 'Cancel' to close the window and click the 'Visual...
How to Create a P Chart Using Samples
1. Click 'Start' then 'All Programs' and select 'Microsoft Excel' to open the program.2. Type 'Class' in cell A1 of the Excel worksheet and type the numbers 1 to 10 in chronological order in cells A2 to A11.3. Type 'Absent' in the cell B1 and then type the following values (according to the introductory example), one below the other as shown below (B2 to B11):4131263230Value '4' should be entered in cell B2, '1' in B3 and so on.4. Type 'Proportion' in the cell C1, type '=B2/50' in cell C2 and then press 'Enter.' Proportion is calculated using the value in cell B2 (i.e., 4) and dividing...
Tuesday, August 27, 2013
How to Sort a Name List by Same Names in MS Excel
1. Select the column of names that you would like to sort.2. Open the 'Data' tab.3. Under the 'Sort Filter' group, click the 'Sort A to Z' button. This button features the letter 'A' on top of the letter 'Z' on the left side, and an arrow pointing down on the right side. All of the names are now sorted alphanumerically, and cells containing the same names are right next to each oth...
How to Show Numbered Columns
Microsoft Excel 20031. Click on the 'Tools' menu, and select 'Options.'2. At the top of the window that appears, click the 'General' tab.3. Under 'Settings,' click the 'R1C1 reference style' check box.4. In the lower right-hand corner of the window, click the 'OK' button.Microsoft Excel 20075. At the top left of the screen, click the round button that features the Microsoft Office logo.6. Toward the bottom right of the information box that appears, click 'Excel Options.'7. At the top of the window that appears, click the 'Formulas' tab.8. In the 'Working with formulas' section,...
How to Make Tables in Excel 2007
1. Launch Excel 2007 from your desktop. Type the information you would like to use as each column's 'header' in side-by-side cells within the same row.2. Enter the data that you would like to be displayed in the rows directly under each of the 'headers' that you have typed out. Verify that you have entered the information correctly into the cells and that data is sorted as you would like it to be displayed in the table.3. Click and drag your mouse over the cells that make up the table you are creating to highlight them. Click the 'Insert' tab towards the top of the Excel 2007 window. Click...
How to Use Excel As a Database
How to Set Up an Excel Spreadsheet as a Database1. Identify the data you want to include in the database. Before you can set up a spreadsheet as a database, you need to know what information you will be tracking.2. Use Row 1 as headings for each item that you plan to track. For example, if you plan to use Excel as a database for contact information, you would include name, address, phone number and other headings across Row 1.3. Format Row 1. Change the formatting of Row 1 to separate the headings from the data in your database. To do this, click the number one next to Row 1, which highlights...
Monday, August 26, 2013
How to Count Multiple Criteria in Excel 2003
1. Open your Excel spreadsheet.2. Locate the formula bar at the top of the spreadsheet. It will have an 'fx' symbol on the left.3. Type the following syntax in the formula bar (without the quotes):'=countif(range,criteria)'Replace 'range' with the range of cells that you want the Excel to include (e.g. 'A1:A20') and replace 'criteria' with the criteria you wish to use for the formula (e.g. '>20' where ALL values greater than 20 will be taken into account).4. Press 'Ctrl Shift Enter' to enter the arr...
How to Create a Worksheet Form in Excel 2003
1. Launch Microsoft Excel 2003. Start a new worksheet, or open the worksheet that you wish to add forms to.2. Click 'Tools,' and select 'Customize.' The 'Customize' menu will appear.3. Click the 'Toolbars' tab, and scroll down to 'Forms.' Place a checkmark next to 'Forms,' and click 'Close.' The 'Forms' toolbar will appear on your Excel spreadsheet.4. Click on the type of form that you want to add to your Excel 2003 worksheet from the 'Forms' toolbar. You can add labels, group boxes, buttons, checkboxes, option buttons, list boxes, combo boxes, scroll bars and spinners.5. Drag your cursor...
How to Select a Cell Without Deselecting
1. Add one cell at a time to previously selected cells, without deselecting any of these previously selected cells, by pressing and holding 'Ctrl' while you use the left mouse button to add new cells.2. Add a range of cells to previously selected cells without deselecting any of these previously selected cells by pressing and holding 'Shift' while you drag the left mouse button to add a new range of cells.3. Add more cells to an existing selection of cells by turning on the 'Add to Selection' feature by pressing 'Shift' 'F8,' and then using your mouse to select any nonadjacent cells.4. ...
Sunday, August 25, 2013
How to Use Excel 2003 With Map Coordinates
1. Start Excel and enter the following text into the following cells:'LatA' in cell A1'LonA' in cell C1'LatB' in cell A2'LonB' in cell C2These will be the labels that appear to the left of the cells in which you'll be entering the latitude and longitude pairs of your map coordinates.2. Now you will name the contents of cells B1, D1, B2 and D2 with names corresponding to the labels you entered in Step 1. These names will be used in two complex formulas rather than direct cell references, to make them easier to understand. Name cell B1 as 'LatA' by clicking B1 and entering 'LatA' into the cell...
Saturday, August 24, 2013
How to Recover a Password for VBA Projects in Excel
1. Download and install Rixler's VBA Password Recovery Master. The software can unlock any length VBA password automatically. Point the software to the location of your password protected VBA file and the software will work to recover the password. When your password has been recovered, a single mouse click will copy the password to the Office Clipboard.2. Order the Pro Edition of Dombajsoft's Remove VBA Password Program. The software instantly removes any VBA password, unlocking the file so you can get into your project. The software doesn't recover the password, but it does gain you access...
How to Add Headers and Footers to Documents in Excel 2003
1. Open your Excel worksheet after logging 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. Go to 'View'. From the displayed menu, select 'Header and Footer'. Choose your desired header or footer from the appearing options. Drag your mouse across the icons to view their descriptions. Click on 'Insert Auto Text' for more options.3. Create a custom header or footer by selecting 'Custom Header' or 'Custom Footer'.4. Choose either 'Left Section', 'Center Section' or 'Right Section'.5....
Friday, August 23, 2013
How to Calculate Median in Excel
1. Enter a list of numbers down a column that you would like to calculate the median for. Make sure the numbers are in ascending order.2. Click on a cell where you would like the median to appear. This can be the cell after the last number or any other area in the spreadsheet where you want the median to appear.3. Type =MEDIAN(range) in the cell, with the range specified as the range of cells containing the data. For example, if you have data in cells A1 through A6, the range would be A1:A6. Alternatively, in Microsoft Excel 2007, you can click on the 'Formulas' tab in the toolbar. Click...
How to Open an Excel 2007 File in Excel 2003
1. Go to the download page for the Microsoft Office Compatibility pack using the link in the References section of this article.2. Click the 'Download' button, and save the file to the location of your choice. The name of the download is 'FileFormatConverters.exe.'3. Launch the program. You may have to click a 'Run' button to confirm that you want to run it. Read the license agreement for the software. If you agree, put a check in the box and click 'Continue.' The installation will proceed automatically. Click 'OK' when it is finished.4. Restart your computer.5. Double click the Excel...
How to Merge Multiple Workbooks in Excel 2003
1. Open Excel on your computer. Make sure that each workbook to be merged has a unique name and is located in the same folder on your hard drive.2. Open the workbook that you want to merge all changes into.3. Go to the 'Tools' menu and select 'Compare and Merge Workbooks.'4. Save the workbook, if prompted by Excel to do so.5. Select the workbooks to be merged into the currently open workbook, by clicking on the name(s) in the 'Select Files to Merge into Current Workbook' dialog box. To select more than one file name, hold down the 'Control' key while clicking on multiple file names....
Thursday, August 22, 2013
How to Add a Line to an Excel Stacked Chart
1. Right-click on your chart, and click the 'Select Data' option.2. Click 'Add' in the 'Select Data Series' dialog box under 'Legend Entries.'3. Enter the data range you want to use for the line graph in the 'Edit Series' dialog box under 'Series values.' Click 'OK,' and close out of the dialog boxes.4. Click once on your new data series in the chart, regardless of the format the series defaulted to.5. Right-click on your highlighted data series, and click 'Change Series Chart Type.'6. Select the 'Line' option in the dialog box, and click 'O...
How to Use Excel 2007 for Student Grades
1. Type 'Student Name' in cell A1.2. Type the names of each assignment in Row 1, starting with the first one in cell B1, directly to the right of the Student Name text.3. Type 'Total' in Row 1, in the column directly to the right of the last assignment.4. Type each student's name into column A, starting directly below the 'Student Name' text.5. Type the number of points each student earned on a given assignment in the appropriate cell.6. Type '=SUM(' in the first cell directly underneath the 'Total' text, then highlight each cell in the row that corresponds to an assignment going back...
How to Apply Text Attributes Cell Borders in Microsoft Excel
1. Click on the 'Home' tab to display the 'Home' ribbon. For Excel 2003, skip this step.2. Select the cell or cells to which you want to apply your text attributes.3. Click on the 'B' button located in the 'Font' section of the ribbon (Excel 2007) or in the formatting toolbar (Excel 2003). This will make your text bold. Click on the 'I' to italicize the text. Click on the 'U' to underline the text. To remove a text attribute, click on the same button you used to apply the attribute.4. Click on the diagonal arrow in the bottom right corner of the 'Font' section to display the 'Format Cells'...
How to Allow Value Changes to Excel Protected Cells Using Macros
1. Select 'Edit' > 'Find' > 'Options' > 'Format' > 'Select Locked' > 'OK' > 'Find All.' This will identify which cells are actually locked. On an unmodified sheet, you can skip this step since all cells are marked as Locked by default.2. Select 'Tools' > 'Visual Basic Editor' and type 'Sub unlockit.' Press 'Enter.' On the next line, type 'End Sub' (minus quotes). In between these two lines is where you will enter the macro.3. Type in 'Range('A1..A20').Locked = False.' The range can be any range of data you want to unlock. This line can also be entered in an already...
Wednesday, August 21, 2013
How to Create a Four Axis Chart in Excel 2007
Add a Secondary Vertical Axis1. In a chart, select the data series you want to put on a second vertical axis. Either select the data series from the chart itself or select it from a list in 'Chart Tools.' To select it from a list, click the chart. In 'Chart Tools,' click the 'Format' tab. In the 'Current Selection' group, click the arrow in 'Chart Elements.' Select the data series to which you want to add a secondary vertical axis.2. On the 'Format' tab, in the 'Current Selection' group, select 'Format Selection.' The 'Format Data Series' box will display.3. On the 'Series Options' tab,...
How to Merge and Center Headers in Microsoft Excel 2007
1. Select the cells you would like centered above the table in the worksheet.2. Click on the 'Merge and Center' icon located in the Home Tab on the Ribbon. The Ribbon is the group of icons and tools located directly above the work area.3. Click on the 'Merge and Center' option from the drop-down menu.4. Click on the 'Unmerge Cells' option to un-merge the cel...
How to Compute Annual Gross Pay in Excel
1. Open a new Microsoft Excel 2010 spreadsheet.2. Click in cell 'A1.' Type in the name of the first company from which you received money for the year in question. Press 'Enter' to move to the cell directly beneath this cell.3. Enter your yearly gross pay for this company, if you know it, or your bi-weekly gross pay if you don't. Ensure that you are entering your gross pay, which is the amount before any taxes are taken out, and not your net pay, which is what you actually take home. Press 'Enter' to move to the next cell underneath this one.4. Enter the following formula, without quotes:...
How to Format Equations in Multiple Cells in MS Excel
Simple Equations1. Launch Microsoft Excel 2010.2. Click 'File' and 'Save As.' Navigate to a saved document location if necessary and type a name for the new spreadsheet into the 'File Name' box. Click 'Save' to save the new spreadsheet.3. Click in the cell that is going to contain the results of the equation.4. Press the 'Equal' sign ('=') on the keyboard to begin creating the formula for the equation.5. Click on the first cell that contains data for the equation. Press the 'Plus' key (' ') on the keyboard to begin an addition formula with the current cell as the first item to be added....
Tuesday, August 20, 2013
How to Do Standard Error Bars on Excel Charts
1. Open a new workbook in Microsoft Excel. Enter data points in cells down two columns. For example, if we want to plot the number of students that earned a certain average exam grade, we would list the number of students down column A and the average grade in column B.2. Highlight the data in both columns. Go to the 'Insert' tab and choose a chart type. For example, we can choose a scatter chart to plot the data.3. Click on a data point to select all of the data points in the chart, or click twice on a data point to only select that data point. You can have standard error bars for one data...
How to Create an Excel Spreadsheet Online to Share
1. Collect the email addresses of those individuals with whom you will share the information. You will be able to link them and notify them of any changes via their email address.2. Create the Excel spreadsheet you intend to share if you have the information handy. Otherwise, you can create your spreadsheet in any one of the office suite programs.3. Create an account, if necessary, to access any one of the above office suite programs. If you already have a Windows Live or Google account, then you will sign into either program using that account. With Zoho Sheet, you can sign in using your...
How to Change the Default Email in Excel 2003
1. Start Internet Explorer by double-clicking on the icon on the desktop or by clicking 'Start' and choosing the 'Internet Explorer' icon on the Start menu.2. Select the 'Tools' menu option, and then click on 'Internet Options.'3. Click on the 'Programs' tab on the 'Internet Options' dialog box.4. Click on your desired email program from the 'Email' combo box.5. Click 'Apply' and then 'OK' to save changes. Now you can use your desired email program as your default email for Excel 20...
How to Unlock the Secrets of Microsoft Excel 2007 Macros
1. Open the Excel workbook that needs a new macro. Click the 'Microsoft Office' button at the top-left end of the window. Scroll to the bottom of the menu and click 'Excel Options.'2. Navigate to the 'Popular' tab and click the 'Show Developer Tab in the Ribbon' box underneath the 'Top Options' heading. Choose 'OK.'3. Click the 'Developer' tab at the top of the workbook. Click the 'Macro Security' button in the 'Code' heading.4. Choose 'Enable all macros (not recommended, potentially dangerous code can run)' if you want all macros to be able to run automatically. Choose 'Disable all macros...
Sunday, August 18, 2013
How to Delete Blank Pages in Excel
1. Click on the tab of the worksheet that you want to delete to select that sheet. The worksheet tabs are located at the bottom of the Excel workbook.2. Click the 'Home' tab in the upper-left corner of the Office ribbon.3. Click the drop-down menu next to the 'Delete' button in the 'Cells' section of the ribbon bar.4. Select 'Delete Sheet' in the drop-down me...
How to Set Up a Memo Format
1. Create a memo using Microsoft Word 2010 by selecting from several template designs. Click 'File,' 'New.' Select 'Memos' under Office.com Templates, and double-click on the memo style you want to use. You can edit the format, if necessary, and add information to it.2. Create a memo using Microsoft Excel 2010. Click 'File,' 'New.' Select 'Memos' under Office.com Templates. Double-click on the memo style you want to use. Edit the memo format by deleting rows and columns or renaming the headings for the table.3. An email may also serve as a memo and there is less formatting involved. Many...
How to Use Autofill in Excel 2007
1. Position the cursor in the first cell of the series and type in the data. For our example using days of the week, type 'Monday' into the first cell and press 'Enter' on your keyboard.2. Click on the cell and move your mouse so that the pointer is positioned over the small black box in the lower right corner of the cell. The pointer will change from a white cross to a black cross when you have it positioned correctly.3. Use your mouse to drag the black cross, known as the AutoFill handle, across the range of cells which you wish to fill with the rest of the series.4. Release your mouse...
Saturday, August 17, 2013
How to Change the Author of an Excel Spreadsheet
1. Open the Excel document that you want to change the author.2. Click on the 'File' tab in the top-left corner of the Excel window. Then select 'Info' from the list of options on the left side of the 'File' screen.3. Select 'Properties' on the right side of the 'Info' screen. Then select 'Show Document Panel' from the drop-down menu. You will automatically taken back to the 'Home' tab and your Excel worksheet will appear on the screen, with the document panel positioned just above it.4. Select the text box next to 'Author.' Delete the data in that box and enter your desired author name....
How to Make a Multiple Baseline Graph in Excel
1. Type in your data into an Excel worksheet in which each column represents a separate baseline condition.2. Label the first row of each column with the condition name.3. Highlight the data you wish to include in the graph. Click on the 'Chart Wizard' icon in the toolbar and select the standard line graph. Press 'Next'.4. Click on the vertical axis , then select the 'Scale' tab to change the scaling on the y axis so that vertical axis hangs over the horizontal axis.5. Input the same minimum value for the 'x' and 'y' axes. Click 'OK.'6. Draw phase changes using the line tool in the...
How to Combine Columns of Data in MS Excel
Combining Values Through Arithmetic1. Launch Excel on your computer and open the spreadsheet for which you want to combine columns of data through arithmetic.2. Click on the first row of an empty column and type the following formula into the cell:=$A1 $B1.Replace 'A' with the column holding the first value to be combined and 'B' with the column holding the second value to be combined. Replace the ' ' (sum) operator with whatever Excel operator you need to compute the combination.3. Press 'Ctrl-C' to copy the formula. Select all entries in the column that you want defined. Excel will display...
How to Enable Macros in Excel 2003
The XLStart Folder1. Open the folder that contains the workbook file with the macros you want to enable.2. Right-click on that file and click \'Cut\' from the drop-down menu that appears.3. Open the folder \'C:\\Documents and Settings\\[User Name]\\Application Data\\Microsoft\\Excel.\' Note: in this example, \'[User Name]\' is a generic placeholder for your actual user name on your computer. So, if you're logged on as \'JohnSmith\', the folder you would open is \'C:\\Documents and Settings\\JohnSmith\\Application Data\\Microsoft\\Excel.\'4. Look for a folder titled \'XLStart.\' If you...
How to Apply Shading to the Whole Page
Apply Shading to a Word Document1. Open the Word document.2. Click the 'Page Layout' tab on the command ribbon.3. Click the 'Page Color' button in the 'Page Background' group. A gallery of color samples appears.4. Hover over a color sample to preview the effect on the document.5. Click the color sample. The page color converts to the selected color.Apply Shading to an Excel Worksheet6. Open the Excel workbook.7. Click the 'Select All' button in the upper left corner of the worksheet. The rectangular 'Select All' button displays a triangle adjacent to the 'A' and '1' headers. This...
Friday, August 16, 2013
How to Use Autofit in Excel
Autofit a Single Column in Excel1. Start Microsoft Excel and open up an existing spreadsheet that contains one column that you would like to apply autofit to. You can also start a new spreadsheet so you can practice using Excel's autofit.2. Position your mouse over the right border of the column that you would like to autofit the contents. Your mouse pointer will change into a double-headed arrow when you are directly over the border.3. Double-click with your mouse on top of the border, only when you see the double-headed arrow.4. Notice that your longest entry will now fit within the...
How to Make Labels Through Microsoft Excel
1. Open a blank worksheet in Microsoft Excel.2. Begin by entering column headers for each field of data in your list of addresses. Click in cell A1 and type 'First Name.' Press 'Tab' to go to the next column. Enter 'Last Name.' Continue tabbing over and entering the column headers for street address 1, street address 2, city, state and ZIP code.3. Click cell A2. Enter the first name of the first person in your address list. Tab over to add the rest of their address information in the corresponding column. Each row will be one individual address record.4. Press 'Enter' to move to the next...
How to Make a Pipe Delimited File in Excel
1. Click the Windows 'Start' button in the computer's taskbar, and then click 'Control Panel' in the resulting menu. This opens a window.2. Click 'Region and Language' in the window that appears. The Region and Language window opens.3. Click the 'Additional Settings' button in the Region and Language window. The Customize Format window appears.4. Highlight the comma in the 'List separator' field. Press the 'Shift' key and the backslash key simultaneously on your keyboard. This will create a pipe (|).5. Press the 'Apply' button, then 'OK' to close the Customize Format window. Press 'OK'...
How to Add Borders to Cells in Microsoft Excel
1. Launch Excel by double clicking the icon on the Desktop or by finding the application under the 'Start' menu.2. Choose the file you wish to work with and open it.3. Highlight the cells in the spreadsheet that you want to have a border. Place the mouse in the cell you wish the border to start, press and hold down the left mouse button and drag the mouse over the cells you wish to change. Release the left button. The area you want to manipulate should be shaded.4. Right click in the shaded area. A window of options appears, select 'Format Cells.' Choose the 'Border' tab. There are several...
Thursday, August 15, 2013
How to Download Data From the Web to Excel
Download Data from the Web to Excel 20031. Open Microsoft Excel 2003.2. Select the 'Data' option from the toolbar at the top of the screen, select 'Import External Data,' and then select 'New Web Query.'3. Type the URL of your desired Web page into the text field next to 'Address' at the top of the window, then click the 'Go' button.4. Click the yellow arrow(s) located next to the information that you wish to download into Excel.5. Select the 'Import' button at the bottom of the window once all your required data has been downloaded.6. Select the location on your worksheet into which...
How to Insert an Attachment Into an Excel Spreadsheet
1. Open your Excel spreadsheet. Choose the cell where you want to insert your attachment. Click inside this cell. Select 'Insert' from the menu bar, then click 'Object.'2. Select 'Create New' if you will create a new file to attach to the spreadsheet. Select 'Create from File' if you will attach a file that you have already saved on your computer.3. If you will create a new file to insert, select the type of file you will make. Check the 'Display as icon' box if you want to display the attachment as a representative icon rather than a full file display. Click 'OK.' Create the new file. The...
How to Make a Line Chart in Excel 2007
1. Enter data that will be charted into the spreadsheet. Line charts allow you the flexibility to present the information in rows or columns. Include text headers to identify what data is in the row or column.2. Highlight the information that you want to chart. Click the first cell in the series that you want to highlight. While holding down the mouse button, drag the cursor highlighting all the data that will be inserted in chart.3. Choose the type of chart you want to create. Click the Line button. This button is located under the Insert tab on the top ribbon. Choose the first option...
Wednesday, August 14, 2013
How to Work With Pivot Tables in PPT Excel 2003
1. Launch Excel 2003 and open a blank spreadsheet. Enter the source data that you want to use for the pivot table. The list should be organized in to columns or rows with original headers that correspond with the data that follows. For example, headers for a list of families who live on specific streets would be stored in the spreadsheet using the street names as column headers and the family surnames in the corresponding cells in the appropriate columns.2. Click the “Data” menu and select the “PivotTable and PivotChart Wizard” option, which will open a separate window. Click the “Microsoft...
How to Program Excel Interfaces
1. Start Microsoft Excel, then open any worksheet or workbook.2. Click on the 'Developer' tab. If you don't have this tab, click on the 'Microsoft Office' tab, then click on 'Excel Options.' Click on 'Popular' in the categories pane, and then select 'Show Developer tab in the Ribbon.' Click on 'OK' to close the dialog box. The 'Developer' tab will now be added to the toolbar.3. Click on the 'Visual Basic' button. This will open the Visual Basic Editor (VBE).4. Click on the 'Insert' tab and then click on 'New Module.' This opens a blank window where you can write your VBA code.5. Write...
How to Use Microsoft Excel to Make a Bar Graph
Make a Bar Graph in Excel 20031. Enter the data you want to use into columns or rows in the Excel worksheet with a column or row of labels and a column or row of data.2. Select the cells containing the data you entered. Click and hold the left mouse button and drag over the cells, or press and hold the 'Ctrl' key and click on each cell you want to select.3. Click the 'Chart Wizard' button on the standard toolbar. Select 'Bar' under 'Chart Type.' Select a bar graph subtype in the 'Chart Subtype' box. Click 'Next.'4. Select any other settings desired. Click 'Finish' to complete the wizard...
How to Learn Macros in Excel 2007
1. Click on the 'Developer' tab to bring up the ribbon.2. Click the 'Record Macro' button in the Code frame of the Developer ribbon.3. Type your desired macro name into the 'Macro Name' text box, then type the shortcut key you want to use to access your macro in the 'Shortcut Key' text box. Click 'OK.' For example, you might name your macro 'AddEmphasis' and set the shortcut key to 'E.'4. Format your spreadsheet in whatever way you want. Whatever you do now will be repeated when you run the macro in the future. For example, you might italicize the text in a cell and change the background...
Tuesday, August 13, 2013
How to Exit From a Sub in VBA
1. Open the VBA editor. Double-click on one of the Microsoft Office programs that you want work with. Click on the 'Developer' tab and then click on 'Visual Basic.' If you don't see the 'Developer' tab, click on the 'File' tab and then 'Options.' Click on the 'Customize Ribbon' tab in the 'Options' dialog box. Click on 'Main tabs,' and then click on the 'Developer' check box. Click 'OK' to close the 'Options' dialog box.2. Navigate to the sub procedure that you want to work with in the Visual Basic Editor. Double-click on the page in the right pane to open it. To work on a new procedure, click...
How to Create a Venn Diagram in Excel or Word
1. Open a document in Microsoft Word or Excel.2. Click the 'Insert' tab. In the 'Illustrations' group, click 'SmartArt.' Click the 'Relationship' tab. Scroll down and select the icon for 'Basic Venn.' Click 'OK' to insert the Venn diagram.3. Click 'Text' in the Text pane on the left. Type the text you want to place inside the first circle, which should be the name of the thing you are comparing. Click the next item down to enter text for the next circle. You also can click a circle in the graphic and type the text there.4. Add or remove circles from the Venn diagram if you have more or...
How to Fit an Excel Sheet on One Page
1. Open the Excel spreadsheet that you want to print. Click on 'File' in the Excel toolbar, or use the keyboard shortcut 'Alt' and 'F.'2. From the 'File' menu, select 'Page Setup.'3. In the 'Page Setup' dialog box, click the 'Page' tab.4. Under 'Scaling,' click the radio button to the left of 'Fit To.'5. Enter your desired number of pages in the 'Pages Wide' and 'Pages Tall' drop-down menus. For example, you may want to change only the width of your page so that the last columns do not print onto a separate page. In this case, you would enter '1' into 'Pages Wide' and delete the number...
How to Modify a Worksheet in Excel 2007
1. Determine what you need to modify. You have just received correspondence from some of your friends that have changed their address. You now need to update their information in your workbook.2. Open your worksheet and find the information that needs to be modified.3. Click on 'Edit' and 'Find and Replace'. When the box appears type in the first or last name of the person you need to locate in the 'Find' box and click ok.4. Let Excel find and take you to the information.5. Select the columns that need to be updated. Fill in the new street, city, state and zip code with the new information.6....
How to Print on One Page in Excel 2003
1. Click 'Start' from the bottom-left of the screen. Click 'All Programs' and then click 'Microsoft Excel 2003.'2. Click 'File' and then 'Open.' Click the Excel file of choice and click 'Open.'3. Click and drag the mouse over the group of cells of the worksheet you wish to print. If you do not choose the group of cells when you print, Excel will print both cells with data as well as cells that are blank.4. Click 'File,' then click 'Print Area' and then 'Set Print Area.'5. Click 'File' and then click 'Page Setup.'6. Click the option 'Fit to' in the 'Page' tab. Enter the value of '1'...
How to Add Data to a Pivot Table
1. Double-click the Excel file that contains your PivotTable to open it with Excel 2010.2. Navigate to the source data for the PivotTable. This may be in a separate area of the worksheet, or on a separate worksheet. If your data is on a separate worksheet, you can chance worksheets by clicking on the correct worksheet tab at the bottom of the window.3. Add your desired row or column of data. You can also modify the existing data, if you need to.4. Navigate to your PivotTable and select any cell in the table. Click the 'Options' tab at the top of the screen, and then click the 'Change Data...
Monday, August 12, 2013
How to Use the Color of an Active Cell in Excel
1. Highlight the range of data you want to sort.2. Select the Home tab at the top of the page, then click on 'Sort Filter' in the Editing group and then click 'Custom Sort...' to open the Sort dialog box.3. Check the box labeled 'My data has headers' if you highlighted data header rows when selecting your data.4. Choose the column by which you want to sort your data under 'Sort by' and then select Cell Color under 'Sort On.'5. Choose the color by which you want to sort under 'Order.' All colors present in your data range, including 'No Cell Color,' will be available as options. Choose...
How to Link Word 2007 Excel 2007 Documents
1. Open the Microsoft Word 2007 file on your computer that you want to link an Excel 2007 file into. Click on the area in your document where you want the link to appear.2. Click on the 'Insert' tab and then click on the arrow next to the 'Object' field.3. Click on the 'Text from File...' option from the drop-down menu and then the Insert File dialog box will appear.4. Select the Excel 2007 file on your computer that you want to link into your document.5. Click on the 'Insert as Link' option and then the Excel 2007 will appear as a clickable link within your docume...
How to Calculate Range in Excel
1. Open a new worksheet in Microsoft Excel. For the purposes of this article, type a series of numbers into column A, beginning with '1' in cell A1 and ending with '10' in cell A10.2. Click on cell B1, which should be blank, and type '=MAX(A1:A10)' to find the highest number in the data sample you entered. In this case, it will be 10.3. Click on cell B2, which is also blank, and type '=MIN(A1:A10)' to find the lowest number in the data sample. In this example, it will be 1.4. Click on the blank cell B3 and type '=B1-B2' to calculate the range by subtracting the minimum value of your data...
Sunday, August 11, 2013
How to Hide Formulas in an Excel Spreadsheet
1. Locate the cells with the formulas you want to hide.2. Select those cells by clicking and dragging with your mouse.3. Right-click on your selection, and select 'Format cells' from the resulting menu. In the window that appears, select the tab titled 'Protection' and check the check box labeled 'Hidden.' Click 'OK' to finish.4. Finally, select the 'Review' tab in Excel's main window, and select the 'Protect Sheet' option. This final step will ultimately hide your formulas. If you want to view them again, disable the protection on the sheet. You can also password-protect the sheet if...
How to Sort in Microsoft Excel 2007
1. Open your data file in the Excel 2007 program. Place your mouse over the first letter that represents your first column (usually column A). A down-pointing arrow will appear. Left-click your mouse and hold, then drag the mouse across to select all of your columns. Let go of the mouse and look through the file to assure that all of your columns are highlighted (selected).2. Click the 'Data' tab on the Excel 2007 main menu. Go to the 'Sort Filter' section. Click 'Sort'---a dialog box will appear.3. Choose the column letter by which you want to sort your list under the 'Sort by' box. For...
How to Make All Excel Rows the Same Height
1. Open Microsoft Excel.2. Hold the 'Ctrl' key and press 'A' to select all cells.3. Right-click any row number and select 'Row Height...' from the pop-up menu.4. Enter a point size for the cell in the 'Row Height' window and click 'OK' to set all rows to that size. Alternatively, you can click and drag the line between row numbers to change them visually. When you release your mouse button, all rows will appear at the selected heig...
How to Calculate the Percent Change in Excel
1. Open Microsoft Excel.2. Click the cell where you want the calculation to be performed.3. Type '=(B-A)/A' and press 'Enter' to calculate the decimal change from 'A' to 'B.' Replace 'A' with the original number, and 'B' with the new number. As an example, to calculate the decimal change on a sale which reduced the original price of $120 to the sale price of $80, you would enter '=(80-120)/120' and press 'Enter.' This produces 0.3333. You can also use cell references, such as '=(A2-A1)/A1' where 'A1' references the first row of the 'A' column.4. Right-click the cell, and select 'Format...
How to Create Check Boxes
Set Up Word or Excel1. Click 'Start' > 'All Programs' > 'Microsoft Office' and then either 'Microsoft Word 2010' or 'Microsoft Excel 2010.'2. Select 'Options' from the 'File' tab in Microsoft Office or Microsoft Excel's ribbon. Select 'Customize Ribbon.'3. Select the 'Developer' check box under 'Main Tabs.' Click 'OK.'Check Boxes in Word4. Select 'Design Mode' from the 'Developer' tab of the ribbon.5. Click the place on the document where you want to insert the check box.6. Click the 'Check Box Content Control' icon in the 'Controls' group of the Developer tab.7. Select 'Properties'...
Subscribe to:
Posts (Atom)