How to Compare Sheets in Excel 2007

Compare Worksheets in the Same Workbook
1. 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 Workbooks
5. 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 Side by Side' button from the 'Window' group.
8. Click the tabs at the bottom of each worksheet to display the worksheets you want to compare.
9. Click the 'Synchronous Scrolling' button from the 'Window' group to scroll both worksheets at the same time.

Read more ►

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 the box.
3. Enter the desired email address or hyperlink. Enter the desired email address or hyperlink into the address field. Make sure that you properly code the hyperlink with the “http://” format or the link will be invalid.
4. Insert the email address or hyperlink into the cell. To insert the email address or the hyperlink into the spreadsheet all you have to do is click on the “Okay” button.

Read more ►

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 cells.

Read more ►

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 from the “Display” list, including black dots and transparent squares. Select the 'Standard Deviation' option from the list below the “Error amount” field.
5. Click on the “Custom” option if you want to insert specific amounts for the standard deviation equation. Click on the “OK” button and the changes will be made to your chart.

Read more ►

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 Basic' button to open the VBA editor window.
4. Click the 'Modules' link at the left side of the window to bring up a list of VBA modules saved on the workbook. Scroll through the code until you find the opening 'Sub' command at the top of the Macro. For instance, if the Macro is titled 'Macro1,' the line of code should read 'Sub Macro1().'
5. Click behind the opening 'Sub' command and type the word 'Private.' Add a space between the 'Private' and 'Sub' commands so your line of code reads 'Private Sub Macro1().'
6. Click 'File' and choose 'Save' to save the changes and hide your macro.

Read more ►

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 it by 50 (number of students). These instructions cause Excel to automatically perform the calculation.
5. Point the mouse cursor to the bottom-right corner of cell C2. The cursor will turn to sign. Then click and drag the mouse cursor vertically down until you reach cell C11. Excel automatically calculates all the values using the formula used in the previous step while replacing B2 with B3, B4 and so on and then fills the corresponding cells.
6. Type 'Total Absent' in cell A13, type '=SUM(B2:B11)' in cell B13, and then press 'Enter.' Type 'Total Possible' in cell A14, type '=10*50' in cell B14, and then press 'Enter.' SUM is an built-in Excel function that, as instructed here, automatically calculates the sum of numbers in cells B2 to B11 and then displays the sum in cell B13. In this case, 10 is multiplied with 50 using the multiplication operator * and then the result is displayed in cell B14. Here, 10 is the number of classes and 50 is the number of students.
7. Click in cell 'A1,' click 'Insert' menu and then 'Chart.' Click 'Standard Types' tab on the Chart Wizard.
8. Click 'Line' below 'Chart type,' select the chart type that is described as 'Line with markers displayed at each data value' on the right pane and then click 'Next.' Click 'Columns' radio button on the Data Range tab and then click 'Next.'
9. Click 'Titles' tab. Type 'Samples' in the Category (X) axis box and 'p' in Value (Y) axis box. Then click 'Next.' Click the 'Finish' button. P chart will be displayed on the Excel spreadsheet.

Read more ►

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 other.

Read more ►

How to Show Numbered Columns

Microsoft Excel 2003
1. 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 2007
5. 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, click the 'R1C1 reference style' check box.
9. In the lower right-hand corner of the window, click the 'OK' button.

Read more ►

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 the icon labeled 'Table' that appears directly underneath the 'Insert' tab.
4. Click the empty box next to the text that reads 'My table has headers' in the window that opens and click 'OK' to continue. Excel 2007 will take the information that you have entered and create a table in the spreadsheet.

Read more ►

How to Use Excel As a Database

How to Set Up an Excel Spreadsheet as a Database
1. 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 the entire row. Add your formatting, such as bold, center and a gray background.
4. Freeze the heading row. Use the freeze pane feature so that your headings will always appear at the top of the database.
In Excel 2007, click on the number two next to Row 2 to highlight the first row under the headings. Click the View tab. Click Freeze Panes and then Freeze Top Row.
In Excel 2003, click on the number two next to Row 2 to highlight the first row under the headings. From the menu bar, click Window>Freeze Panes.
5. Type in the data. Use one row for each database entry, keying in the information to match the heading information.
6. Sort the data in the database. After you enter the information into the database, you can view the data in a variety of ways. See the next section for instructions on how to sort the data in an Excel database.
How to Sort the Data in Excel 2007
7. Decide how you want to sort the information. For example, you might want the data listed alphabetically by last name, or you might want to sort the data by zip code.
8. Highlight the data in the database. Click on the upper left cell that is left of A and above 1. This highlights the entire spreadsheet.
9. Open the Sort window. Click the Data tab. Then, click the Sort button in the Sort Filter section. This opens the Sort window.
10. Select the data you want to filter. Under Column, select the data you want to sort beside Sort By. If you want to include a secondary sort (such as first name in case you have more than one person with the same last name), then select the heading for a secondary sort next to 'Then by.'
11. Choose sort order. The default (A to Z) is to sort alphabetically or lowest to highest number. To do the opposite, select Z to A under Order.
12. Click OK. The data in the database sorts in the way you instructed.
How to Sort the Data in Excel 2003
13. Decide how you want to sort the information. For example, you might want the data listed alphabetically by last name, or you might want to sort the data by zip code.
14. Highlight the data in the database. Click on the number 2 next to Row 2 to highlight the entire row. While pressing the Shift key, click on the number next to the last row with data to highlight all data without including the heading.
15. Open the Sort window. From the menu bar, click Data>Sort.
16. Select the data you want to filter. Under Sort By, select the data want to sort. If you want to include a secondary sort (such as first name in case you have more than one person with the same last name), then select the heading under 'Then by' for a secondary sort.
17. Choose sort order. The default (Ascending) is to sort alphabetically or lowest to highest number. To do the opposite, click the radio button to select Descending.
18. Click OK. The data in the database sorts in the way you instructed.

Read more ►

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 array.

Read more ►

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 over the area in the worksheet where you want the form to appear, to create the form. You can edit and move the form after creation.
6. Right-click the form, and select 'Format Control.' The 'Format Control' dialog box will appear.
7. Edit the form using the options in the 'Format Control' dialog box. You can change the size, color, text and protection settings for the form.
8. Add macros to the forms by right-clicking the form and selecting 'Assign Macro.' The 'Assign Macro' dialog box will appear. Macros control the functions of the form.
9. Select a pre-created macro from the list of macros, and click 'OK' to use the macro or 'Edit' to open the Microsoft Visual Basic Editor so that you can write the code for the macro.

Read more ►

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. Turn off this 'Add to Selection' feature by pressing 'Shift' 'F8' a second time, and Excel will revert to the default cell selection technique.

Read more ►

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 name drop-down, located to the left of the formula bar in Excel. Repeat this process for cell D1, naming the cell 'LonA,' for cell B2, naming it 'LatB' and cell D2, naming it 'LonB.'
3. Enter 'Bearing' into cell A3, and copy and paste the following formula into cell B3:=MOD(ATAN2(SIN(LonB-LonA)*COS(LatB),COS(LatA*SIN(LatB)-SIN(LatA)*COS(LonB-LonA))),6.30318)This formula returns the angle to the east of North between the coordinates in row 1 and the coordinates in row 2, in degrees. The last term, '6.30318,' is two times pi.
4. Enter 'Distance' in cell A4, and copy and paste the following formula into cell B4:=ACOS(COS(RADIANS(90-LatA)) *COS(RADIANS(90-LatB)) SIN(RADIANS(90-LatA)) *SIN(RADIANS(90-LatB)) *COS(RADIANS(LonA-LonB))) *3959This formula returns the distance between the coordinates in row 1 and the coordinates in row 2, in miles. The last term, '3949,' is the radius of the Earth, in miles. To convert the distance to kilometers, change the last term to '6371.'
5. Enter the latitude and longitude pair of your first map coordinate into cells B1 and D1 respectively. Enter the latitude and longitude pair of your second map coordinate into cells B2 and D2. The bearing between the two points will appear in cell B3, in degrees, and the distance between the two coordinate pairs will appear in cell B4.

Read more ►

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 to your file. Once you have access you can add a new password of your choice. The software supports VBA projects up to and including Office 2010.
3. Purchase a copy of Softpedia's Remove VBA Password. Remove VBA Password instantly unlocks your VBA project in any Office application, including Excel, Word, PowerPoint, Publisher, Outlook, FrontPage and Project. Passwords of any length or character set can be removed in seconds, allowing you to gain access to your file.

Read more ►

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. Select the buttons to insert the desired header or footer for that section.
6. Enter additional information if desired in the respective box (left, center, right), start a new line in respective section by pressing 'Enter' or delete a section of the header or footer by highlighting information in the section box and pressing backspace.

Read more ►

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 on 'Insert Function,' type 'Median' and press 'OK.'

Read more ►

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 2007 file with an XLSX extension. You will see a window saying 'File conversion in progress.' After a few seconds, the file will open.

Read more ►

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. Click 'OK.'

Read more ►

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 'OK.'

Read more ►

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 to the first student. To highlight, click the first assignment cell and drag the mouse to the last assignment cell, making sure to select only one row of data. Press 'Enter.' This should display the total number of points this student received from all the assignments, in the Total column.
7. Highlight the 'Total' cell you just created, by clicking on it.
8. Copy the cell by pressing 'Ctrl' and 'C' at the same time.
9. Highlight the cells for each student in the Total column by clicking on the cell directly below the cell you just copied, and dragging the mouse to the very last row that contains a student name. Make sure you select cells only in the Total column.
10. Paste the Total formula by pressing 'Ctrl' and 'V' at the same time. You should see the totals for each student appear in the appropriate row in the Totals column.

Read more ►

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' dialog box. For Excel 2003, click on 'Format' in the main menu. Then, select 'Cells.' Opening this dialog box gives your more options for formatting your text. Select the options you wish to apply and click the 'OK' button to close the dialog box.
5. Select the cell or cells to which you want to apply cell borders.
6. Click on the arrow next to the square (partitioned into four equal parts) graphic located next to the 'U' in the 'Font' section (Excel 2007) or formatting toolbar (Excel 2003). A drop-down will appear. This drop-down shows the various ways to apply borders to your selection. Select 'Bottom Border' to apply a bottom border to all of your selected cells. There are a variety of ways to apply borders: top, left, right, all, thick, and many more. Play around with the options to become more familiar. You can always select the 'No Border' option to remove all borders from a selection.

Read more ►

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 existing macro where needed.
4.
Always save your work to avoid redoing it.
Select 'File' > 'Save.' You can either run the macro manually from 'Tools' > 'Macro' > 'Macros,' or use the Forms toolbar to create a button on your worksheet and assign the macro to it.

Read more ►

How to Create a Four Axis Chart in Excel 2007

Add a Secondary Vertical Axis
1. 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, under 'Plot Series On,' select 'Secondary Axis.' Click 'Close.' The new axis will display in the chart.
4. On the 'Layout' tab in 'Chart Tools,' in the 'Axes' group, click 'Axes.' Click 'Secondary Vertical Axis' to change the display options for the axis. To change the axis options, right click the secondary axis and select 'Format Axis.' Make options changes under 'Axis Options.'
5. Repeat these steps for each data series to which you want to add a secondary vertical axis.
Add a Secondary Horizontal Axis
6. Click the chart that displays a secondary vertical axis. You cannot display a secondary horizontal axis without a secondary vertical axis.
7. On the 'Layout' tab in 'Chart Tools,' in the 'Axes' group, select 'Axes.'
8. Click 'Secondary Horizontal Axis.' Make changes to the display options that you want.

Read more ►

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 cells.

Read more ►

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: '=(A2/14)*365' if you entered your bi-weekly gross pay in the previous cell. Change '365' to '366' if you are calculating for a leap year. If you entered your yearly pay into the cell, just enter in '=A2.'
5. Click in cell 'B1' and repeat the process for the next source of income. Continue until you have each source of income in its own column.
6. Click in cell 'A4.' Enter the following formula, without quotes: '=sum(3:3).' When you press 'Enter,' the number that appears will be your total gross pay for the year.

Read more ►

How to Format Equations in Multiple Cells in MS Excel

Simple Equations
1. 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. Alternately use a different operator, such as the 'Minus' sign ('-'), 'Asterisk' key ('*') or the 'Slash' key ('/') to subtract, multiply or divide, respectively.
6. Click on the next cell in the equation and press 'Enter' if the equation ends with this cell or press another mathematical operator and click on an additional cell to continue the formula. Repeat as necessary until the formula is complete.
Complex Formulas
7. Launch Excel 2010 and open every workbook that contains information that will be used in the complex formula.
8. Click the cell where the answer to the complex formula will be displayed.
9. Click 'Insert Function' from the 'Formulas' tab on the toolbar.
10. Type the name of the function or operation into the 'Search for a Function' dialog box and click 'Go' or select a category of function from the pull-down menu to see a list of functions. Click on the function name and click 'OK' to launch the function wizard.
11. Click in the first box in the 'Function Arguments' box and then click once on the cell that contains the information requested by the dialog box. Repeat for each requested input and click 'OK' to create the formula. Click 'Help on This Function' for a more detailed explanation of the function and what is needed to complete it properly.

Read more ►

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 point or all of the data points.
4. Go to the 'Layout' tab under Chart Tools and click on 'Error Bars.' Select 'Error Bars with Standard Error.'
5. Click on the 'Error Bars' menu and select 'More Error Bar Options.' You can change the direction of the error bars, the end style, and the error amount. The line color, style and shadow can also be customized.

Read more ►

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 Google, Yahoo or Facebook account. While Microsoft Office Live and Google Docs offer valuable preloaded templates (whereas Zoho Sheet requires you to find or create your own templates), using Microsoft Live does require that you download a plug-in. This makes it an excellent option for home or office use, but with a shared computer such as in a computer lab or library, it may not be a viable option for you, since many of these facilities don’t allow software to be installed by public users.
4. Upload an existing spreadsheet or create a new spreadsheet as you would in Microsoft Excel, as the user interface on all three programs is nearly identical. Then save the spreadsheet. To share it, you will need to title and save the document.
5. Share the document by entering the email addresses of those you wish to view or manipulate the document. As you select a user, you can designate their privilege, such as to 'read only' or 'edit.' With Google Docs, you also have the ability to assign additional editors who will then have the added permissions to invite others. Once you’ve given an email address, the recipient will receive an email and her designated privilege and she can begin accessing or editing the shared documents.

Read more ►

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 2003.

Read more ►

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 except digitally signed macros' if you only want macros from trusted sources to be able to run.
5. Select the 'Record Macro' icon in the 'Code' heading when you are ready to record your new macro. Type a name to identify the new macro in the text box and click 'OK.'
6. Perform whatever functions needs to be repeated by the macro, such as deleting or adding rows, changing font or background colors, centering text or summing together the values of cells. Click the 'Stop Recording' icon in the 'Code' heading to finish recording the new macro.
7. Click the 'Macros' button in the 'Code' heading. Click the name of the macro you created. Choose 'Run' to run the macro and perform the recorded operations or 'Delete' to delete the selected macro.

Read more ►

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 menu.

Read more ►

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 fields correspond to the headings on a memo, including 'To,' 'From,' 'Date' and 'Subject.' The email message field contains the memo's body content.

Read more ►

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 button and AutoFill will complete the rest of the data entry in the series. In our example, if you were to drag the AutoFill handle across 6 more cells, it would fill in the days of the week - Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday.
5. Make your own custom AutoFill series by clicking the Office button, clicking on 'Excel Options,' and then selecting the 'Popular' tab. Click on the 'Edit Custom Lists' button, then 'Add.' Type your custom list into the 'List Entries' text box. Click 'OK' twice to finish.

Read more ►

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. Click the 'X' in the upper-right corner of the document panel to close it.

Read more ►

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 toolbar. Add text boxes as well to label each condition.
7. Click on one of the axes and modify the font size to make room for your additional baseline graphs.
8. Input the data for the second graph on the same data sheet you used for your first graph.
9. Highlight only the data you would like to include in the second graph.
10. Open the chart wizard. Save the new graph as an object in your first graph.
11. Repeat steps 1 through 6.

Read more ►

How to Combine Columns of Data in MS Excel

Combining Values Through Arithmetic
1. 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 the cells in a darker shade to indicate that they are selected.
4. Press 'Ctrl-V' to paste the formula into all selected cells. Excel will compute the remaining entries of the column. The entries in the corresponding rows of pre-existing columns are combined.
Concatenating Cell Values
5. Launch Excel on your computer and open the spreadsheet for which you want to concatenate columns of data.
6. 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.
7. Press 'Ctrl-C' to copy the formula. Select all entries in the column that you want defined. Excel will display the cells in a darker shade to indicate that they are selected.
8. Press 'Ctrl-C' to copy the formula. Select all entries in the column that you want defined. Excel will display the cells in a darker shade to indicate that they are selected.

Read more ►

How to Enable Macros in Excel 2003

The XLStart Folder
1. 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 can't find that folder here, search for it in \'C:\\Program Files\\Microsoft Office\\Office11.\'
5. Open the XLStart folder. Right-click on the folder's window and click \'Paste\' from the drop-down menu. This will cause the workbook file from Step 2 to move into this folder.
6. Run Excel 2003. This will cause the workbook file you moved in Step 5 to automatically open. Its macros are now enabled.
Adjusting Security Settings
7. Run Excel 2003 and open the workbook file.
8. Click on \'Tools\' in the main toolbar, causing a drop-down menu to appear.
9. Select \'Macros\' from this menu and then click \'Security.\' This will cause a new window to appear.
10. Click on the \'Trusted Publishers\' tab in the window and check the box next to \'Trust all installed add-ins and templates.\'
11. Click \'OK.\' The macros within your workbook file are now enabled.

Read more ►

How to Apply Shading to the Whole Page

Apply Shading to a Word Document
1. 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 Worksheet
6. 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 button selects and highlights the whole worksheet.
8. Click the 'Home' tab on the command ribbon.
9. Click the arrow next to the 'Fill Color' button in the 'Font' group. This button displays a paint can tipped at an angle. A gallery of color samples appears.
10. Point over a color sample to preview the effect on the worksheet.
11. Click the preferred color sample. The worksheet converts to the selected color when you click in the worksheet.

Read more ►

How to Use Autofit in Excel

Autofit a Single Column in Excel
1. 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 column in which you have applied the autofit setting.
Autofit Multiple Columns in Excel
5. Open Microsoft Excel. Start a new spreadsheet or open an existing one that contains multiple columns that you would like to apply autofit to so the contents will fit inside of the columns without being cut off.
6. Press the CTRL key down on your keyboard. Hold it down.
7. Click on the columns which you want to apply autofit.
8. Release the CTRL button. The columns that you selected will now be highlighted.
9. Hover your mouse over the right border of the first column you have selected until you see a double-headed arrow.
10. Double-click with your mouse on top of the border. Once you do this, all of the columns you have selected will now apply autofit to their contents.

Read more ►

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 row down. Continue adding address information in each cell until you have completed the address list.
5. Save the document. Give it a file name and location you will remember, as you'll need to use the document later.
6. Open a blank document in Microsoft Word.
7. Click the 'Mailings' tab. Click 'Start Mail Merge,' then 'Labels.'
8. Choose the type of printer you'll be using to print the labels. Select the vendor for the label sheets you're going to use. Select the product number listed on the packaging of the label sheets. Click 'OK.' The labels will be set up as a table in your Word document.
9. Click 'Select Recipients' on the 'Mailings' tab. Click 'Use Existing List.' Select the Excel file you just saved to connect to it.
10. Click 'Edit Recipient List' on the 'Mailings' tab if you only want to create labels for some of the addresses in your list. In the dialog box, choose individual records by checking the ones you want to include. Uncheck the ones you don't want to include.
11. Set up the mail merge fields, which serve as placeholders on the labels. Each label will connect to an address record in your address list, including all of the address elements you need. Click 'Match Fields' in the 'Write Insert Fields' group on the 'Mailings' tab. This will bring up a new dialog box, showing elements of an address on the left and the column headers from your address list on the right side.
12. Click a drop-down menu on the right to properly match the correct address field you want to use for each element. Only select the elements you want to include on your labels. For instance, don't match 'Courtesy Title' if you don't have a column for title in your address list.
13. Click the first label on the Word document. If you want to include any content that you want to display on each label, insert it now. For example, you could add a company logo to each label. To do so, click the 'Insert' tab and choose 'Picture' to insert the image file.
14. Click the same label where you want to insert the placeholder mail merge field. Click 'Address Block' in the 'Write Insert Fields' group. Select the address elements you want to include and click 'OK.'
15. Click 'Update Labels' in the 'Write Insert Fields' group. This will apply the content of the first label to all the labels on the page.
16. Preview the mail merge after you've finished setting up the first label. This will allow to see the results of the mail merge before completing it. Click 'Preview Results' in the 'Preview Results' group.
17. Connect your printer to the computer and feed it with the sheets of labels before finishing the merge.
18. Click 'Finish Merge' in the 'Finish' group on the 'Mailings' tab. Click 'Print Documents' to print the labels.

Read more ►

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' to close the Region and Language window.
6. Double-click the Excel spreadsheet file you want to change to pipe delimited. This will open the file in Excel.
7. Click the 'File' tab and then click 'Save As' if you're using Word 2010. Click the 'Office' button and then click 'Save As' if you're using Word 2007. Click 'File' and then 'Save As' in the resulting window if you're using Word 2003. This opens the Save As window.
8. Type a name for your file in the 'File name' field, and then select 'CSV (comma delimited)' in the 'Save as type' drop-down menu. Click the 'Save' button when done. Since you set the machine's default to a pipe, it will save the delimited file with pipes instead of commas.

Read more ►

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 options on this new window.
5. Change the color of your borders by selecting the color you want from the 'Color' drop down menu.
6. Choose the border design by clicking the line type you like in the 'Style' box. Play with the 'Border' buttons to see what suits your needs. Different borders can be placed in different areas of the spreadsheet. To keep information uniform among worksheets, try to use the same color for the same data.

Read more ►

How to Download Data From the Web to Excel

Download Data from the Web to Excel 2003
1. 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 the data will be downloaded, then click the 'OK' button.
Download Data from the Web to Excel 2007
7. Open Microsoft Excel 2007.
8. Click the 'Data' tab at the top of the screen, then select the 'From Web' button in the 'External Data' section.
9. 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.
10. Click the yellow arrow(s) located next to the information that you wish to download into Excel, then select the 'Import' button at the bottom of the window once all your required data has been downloaded.
11. Select the location on your worksheet into which the data will be downloaded, then click the 'OK' button.

Read more ►

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 appropriate program will open in a new window.If you want to attach a file you have already created, browse for the file on your computer. Check the 'Link to file' box to include a link to your source document in the spreadsheet. Check the 'Display as icon' box if appropriate. Click 'Insert.' Click 'OK' to auto inject the file.
4. Save the Excel spreadsheet as normal.

Read more ►

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 labeled 2D line.
4. Format the chart by adding a chart title, axis titles and legend. These labels assist the reader with identifying the data being represented. These options can be found under the Layout tab. The Design tab contains an option to switch the data on the X and Y axes and to select additional data cells. Another way to accomplish this is by right-clicking on the chart and selecting change data.
5. Enhance the visual appearance of your chart by using the Design and Format tabs. The Design tab has chart layouts for quick customization. You can also manually personalize your chart. The line color can be changed under the Design tab. The Format tab has options to apply text effects, shape effects and colored borders.
6. Move the chart to a separate worksheet. The chart will be embedded in the worksheet that contains the data upon creation. Select the chart and click on the Design tab. Click the last button named Move Chart. You will then have the option of moving the selected chart to a new worksheet.

Read more ►

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 Excel” and “Pivot Table” options and click the “Next” button.
3. Select the data that you entered by clicking the header in the first column and dragging to the last cell in the last column while holding down the mouse button. Click the “Next” button.
4. Click the “New worksheet” option to display the pivot table results in a new worksheet within the Excel workbook. Click the “Existing worksheet” option to display the results in the worksheet that contains the source data. Click the “Finish” button.
5. Select the data that you want to appear in the PPT file. Click the “Copy” button. Launch PowerPoint 2003 and open a blank slide show or a presentation to which you want to add the pivot table information. Click the “Paste” button in PowerPoint to paste the data into the slide.

Read more ►

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 a short piece of VBA code to perform a task. For example, VBA code to bold characters is:Sub boldletter()' boldletter MacroSelection.Font.bold = TrueEnd SubThe macro should start with Sub (for subroutine) or Function, and end with End Sub or End Function. The first line of the code also contains the name of the subroutine followed by an open and closed parentheses, which is in this case is 'boldletter.' An apostrophe at the beginning of a line means that it is a comment.
6. Press the 'F5' key to run the macro.
7. Save the code by saving the workbook. Exit the VBE by pressing the 'alt' and 'F11' keys together. Click on the 'Microsoft Office' button and then click on 'Save.'

Read more ►

How to Use Microsoft Excel to Make a Bar Graph

Make a Bar Graph in Excel 2003
1. 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 and add the bar graph to your Excel worksheet.
Make a Bar Graph in Excel 2007
5. 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.
6. 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.
7. Go to the 'Insert' tab. Click 'Bar' in the 'Charts' group. Select a bar graph subtype to add the chart to the current worksheet.
8. Click on the chart to select it. Go to the 'Design' tab under 'Chart Tools' to select a different layout or move the chart to another sheet.
9. Go to the 'Format' tab under 'Chart Tools' to make formatting changes, such as shape styles and colors. Save the worksheet before closing it.

Read more ►

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 to yellow.
5. Click the 'Stop Recording' button in the Code section of the Developer ribbon.
6. Press 'Ctrl' and the shortcut key you chose in Step 3 at the same time. For the example, if you press 'Ctrl' and 'E' at the same time, the active cell will become italic and the background will turn yellow. You now have a working macro.

Read more ►

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 on 'Insert' and then 'Sub Procedure.'
3. Add the 'Exit Sub' command in the sub procedure where you want to exit a certain block of code. This will be between the Sub and End Sub commands. Usually, the Exit Sub command is added right after the code handler. Here is an example of a code block with an Exit Sub command:'Sub message ()MsgBox 'Hello World!'On Error GoTo Error_Handler:Worksheets('Welcome Message').ActivateExit SubError_Handler:If Err.Number = 9 ThenWorksheets.Add.Name = 'Welcome Message'ResumeEnd IfEnd Sub'The sub procedure shows a message box that says 'Hello World.' If for some reason the program can't display the message, it is directed to the 'Error_Handler' block. To stop the code from continuing to cycle through the same bits of code, the 'Exit Sub' command is given.

Read more ►

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 less than 3 circles you want to compare. To add a circle, select the circle nearest to where you want to add one. Click the 'Design' tab. In the 'Create Graphic' group, click 'Add Shape.' Click either 'Add Shape After' or 'Add Shape Before,' and a circle will be added to overlap the selected circle. If you need to delete a circle, select it and then press 'Delete.'
5. Edit the circles in your diagram by manually moving them around. Click a circle you want to move, then drag it to the proper location. This will change the location and size of the overlapping areas of the circles.
6. Format the diagram by clicking the graphic, then clicking the 'Design' tab. To change the color combination, click 'Change Colors' in the 'SmartArt Styles' group and select a theme. Apply a SmartArt Style to change the look of it. Scroll through the styles in the 'SmartArt Styles' group and click the one you want. To change the look of a particular circle, right-click the border of the circle. Select 'Format Shape.' Here you can edit the line color, line style and fill color.
7. Click the 'File' tab or 'Microsoft Office Button,' then 'Save as' to save your Venn diagram.

Read more ►

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 in the 'Pages Tall' menu.
6. Click OK. Your Excel spreadsheet will now fit the way you want it to.

Read more ►

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. Decide if you need to add more information. If your friends have included their phone number in the new information that they sent you, but you haven't put in a column for phone numbers, you can add this column now.
7. Add the new column. Go to the title row and type in a heading such as phone. You can then go back to the row you were in and add the phone number that you have just received.
8. Continue to add new information, by adding new columns or rows to the information that is already there. This is all it takes to modify your worksheet.

Read more ►

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' page wide by '1' tall.
7. Click the 'Margins' tab. Check the box next to 'Horizontally' under 'Center on page' and click 'OK.' This ensures the worksheet prints in the center of the page for the standard portrait paper layout.
8. Click 'File' and then 'Print.' The Print window launches. Click 'OK' to print your worksheet.

Read more ►

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 Source' button. Excel 2010 will automatically move to your source data and open a 'Move PivotTable' window.
5. Click on the top-left cell in your source data, and hold the mouse button as you drag the mouse to the bottom-right cell. Then release the mouse button and click 'OK' on the 'Move PivotTable' window. The PivotTable will now update to include the added data.

Read more ►

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 whether you want that data placed on top or on the bottom.
6. Add additional sorting levels by clicking 'Add level' and or 'Copy level,' if desired.
7. Click 'OK' to view your sorted data.

Read more ►

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 document.

Read more ►

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 from the maximum value. In the above example, the range is 9.

Read more ►

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 need be.

Read more ►

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 instance, if you have a mailing list containing last name (as column A), first name (as column B), address (as column C) and phone number (as column D), you'll probably want to sort your list by last name (column A), so that you can refer to customers by name quickly. If you plan to call all customers within a certain area code, you'd sort the list by phone number (column D).
4. Select your 'Sort On' attribute. The choices are values, cell color, font color and cell icon. The values choice will be most commonly selected---this looks at the data inside of each cell. The other three options are format-based. For instance, if you have color-coded various cells in your list and want to display them all next to each other on the sheet, you would sort on 'cell color.' The same is the case for cell fonts and icons you have inserted into the cell using 'Conditional Formatting' (see Resources for more information on cell icons).
5. Pick the 'Order' that you want the information to sort by. For values, it is either A to Z or Z to A. For the other sort options (cell color, font, icon), you choose which color or icon you want to appear first or last and the rest will settle in between. Click 'OK' to sort the data.

Read more ►

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 height.

Read more ►

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 Cells...'
5. Click 'Percentage' under the 'Category' list of the 'Number' tab. Select the number of 'Decimal places' and click 'OK' to change the decimal change into percent change. The default number of decimal places is two. In the example, 0.3333 is converted into '33.33%.'

Read more ►

How to Create Check Boxes

Set Up Word or Excel
1. 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 Word
4. 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' in the 'Controls' group of the Developer tab. Enter an optional title or tag. Change any other optional settings pertaining to formatting and click 'OK.' Enter labels and instructions.
8. Add more check boxes if you desire groups. Select the group of check boxes by pressing the Ctrl key and clicking on each you want. Select 'Group' from the 'Controls' group of the Developer tab.
9. Select 'Save' from the 'File' tab.
Check Boxes in Excel
10. Select 'Insert' from the 'Developer' tab of the ribbon bar. Select the check-box icon in the 'Form Controls' group.
11. Select the cell of the Excel worksheet where you want the upper left corner of the check-box control located.
12. Select 'Properties' from the 'Controls' group of the Developer tab.
13. Select one of three initial states for 'Value' for the check box: unchecked (default), checked or mixed (applies for groups of check boxes where one or more values may be checked initially).
14. Enter the cell reference that contains the initial value of the check box under 'Cell link,' e.g., $C$1. You may click the icon and then click the cell in the spreadsheet if you prefer. Click 'OK.'
15. Click to the right of the check box to edit the label text. Select 'Save' from the 'File' tab.
Protect the Word Form for Distribution
16. Select 'Restrict Editing' on the Developer tab in Word.
17. Check the box for 'Allow only this type of editing in the document' in section two of the 'Restrict Formatting and Editing' pane located on the right of your screen. Select 'Filling in forms' from the drop-down list in section two 'Editing restrictions.'
18. Click 'Yes, Start Enforcing Protection' in section three 'Start enforcement.' You may enter a password or leave the password fields blank. Click 'OK.'

Read more ►