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 » All posts
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...
Subscribe to:
Posts (Atom)