How to Create Named Ranges in Excel 2007

1. Launch the Microsoft Excel program by double-clicking the program's shortcut on the desktop or by selecting 'Microsoft Excel' from the 'Start', 'Programs' or 'All Programs' menu.
2. Click the 'Office Button' in the upper left corner of the program window and select 'Open.' Click the down arrow to the right of the 'Look in' text box to browse to the folder that contains the file you want to work with. Select the file, and click 'Open.' If you are creating a new spreadsheet, Click the 'Office Button' and select 'New.' Select 'Workbook' and click 'OK.' A blank spreadsheet should be displayed. Enter your data.
3. Select the cells you are interested in using in the named range. Click the 'Formulas' menu on the menu bar. Click the 'Define Name' button on the ribbon to open the 'New Name' dialog box. Click in the 'Name' text box and type a name of your choice. Click 'OK' to define the name and return to your spreadsheet. The name of your range should appear in the 'Name Box' in the upper left corner of the program window.
4. Click somewhere outside the named range to deselect it. Look at the 'Name Box.' The name you created has been replaced by the location of the cell you are in.
5. Click the down arrow to the right of the 'Name Box' and select the name you created. The name reappears in the 'Name Box,' and the name range becomes selected.
6. Click the 'Name Manager' button on the ribbon to view all of the names in your Workbook. Select a name to view the cells it references. Notice that the range of cells that the name refers to can be changed here. Click 'OK.'
7. Click the 'Office Button' and select 'Save' to save the spreadsheet. If you are prompted with the 'Save As' dialog box, navigate to the location you want to save the file in, enter a name for the file in the 'File Name' text box, and click 'Save.'

Read more ►

How to Make a Striped Line on a Bar Graph in Excel on a Mac

1. Double-click the Excel icon on the Dock or find the program in your Applications folder and double-click it. Open the Excel graph through the File menu. Alternatively, find the graph on your hard drive and double-click it.
2. Click on the a bar in your graph and click the 'Format' tab on your toolbar.
3. Click the down arrow on the 'Shape Fill' button. Click 'Texture' and then 'More Textures.' Click the circle by the label 'Picture or texture fill.' Click the 'ClipArt' button. In the search box type 'lines' (without quotes). Press 'Enter.' A selection of graphic lines will appear on your menu. Double-click one and hit the 'Close' button. Your bar graph will appear striped.

Read more ►

How to Print or Page Setup in Excel 2007

1. Click the Office Button at the top left-hand corner. Select 'Print' from the options available and then select 'Print Preview.' In the Print Preview view you will see how the printed copy will look, as well as view and adjust the margins and view page setup options.
2. Select 'Page Setup.' In the dialog box that appears you can set the spreadsheet to print in Landscape mode instead of Portrait. Click the 'Margins' tab to adjust the margins of your spreadsheet as well as vertical and horizontal alignment.
3. Click the 'Header/Footer' tab. Enter any information you want to appear in the header or footer. Click on the drop-down menus below to insert special fields, such as 'Page x of y.'
4. Click on the rightmost tab, labeled 'Sheet.' You can select whether to print gridlines and/or row and column headings here. Click 'OK' after making changes to the page setup.
5. Click the Office Button at the top left-hand corner, then click 'Print,' and 'Print' again. There are several Print options you can choose from.
6. Choose the printer you want to print to by clicking the arrow beside the printer name to view a drop-down list of printer options. Select the printer you want to use.
7. Select the number of copies you want to print. You can also choose whether to print all of your workbook or just part of it under 'Print what.' Define which pages you want to print under 'Print range.' For example, you can choose to print pages 2 to 7 by entering '2-7'. After you make any necessary changes to print options, click 'OK' and your workbook will begin printing.

Read more ►

How to Make Drop Down Fields in Microsoft Excel

1.
Start Microsoft Excel. Open a new blank spreadsheet, or open the spreadsheet to which you want to add a drop down list.
2.
Select the cell or the range of cells in which you want to make a drop down list.
3.
Open the Data Validation dialog by going to the 'Data' menu in Excel 2003 and selecting 'Validation,' or by clicking the 'Data' tab of the ribbon in Excel 2007 and selecting 'Data Validation.'
4.
Go to the 'Settings' tab. Click the drop down arrow under 'Allow' and select 'List.'
5.
Type each list item into the 'Source' box, placing a comma between each word in the list. Click 'OK' to apply the list.

Read more ►

How to Find Duplicate Entries on Excel

1. Launch Microsoft Office Excel 2007 on your computer.
2. Select the rows or columns where you want to find the duplicate entries. Point your mouse in the first cell and continue to hold down the mouse while you drag over the cells you wish to search.
3. Click the 'Home' tab and then click 'Conditional Formatting' under 'Styles' in the top menu.
4. Select 'Highlight Cells Rules' from the drop-down menu. Click on 'Duplicate Values.'
5. Select 'Duplicate' under 'Format cells that contain:' in the Duplicate Values dialog box.
6. Select a highlighting style from the drop-down menu in the Duplicate Values dialog box. Styles include a variety of fill and text-color options.
7. Click 'OK.' All duplicate values will be highlighted in your Excel spreadsheet.

Read more ►

How to Have Three Secondary Axes on Excel 2007

1. Open the chart you want to work with by clicking the Office button, 'Open,' and selecting the file.
2. Click the chart you want to add the additional axes to. This brings up the 'Chart Tools' tab in the top right corner of Excel.
3. Click the 'Format' tab. Select the arrow under 'Chart Area' (in the 'Current Selection' group on the left side of the toolbar). This brings down a selection box. Choose the series you want to add an additional axis to.
4. Click 'Format Selection.' Format Selection is directly below the 'Chart Area' tab.
5. From the 'Series Options' tab (this should be the first one displayed), click 'Secondary Axis' and then click the 'Close' button.
6. Click the 'Layout' tab and choose 'Axes' from within the Axes group. Click on 'Secondary Vertical Axis' and choose a display option.
7. Repeat Steps 2 to 6 to add another axis.

Read more ►

How to Convert Excel 2003 to PDF

1. Open the Microsoft Excel 2003 spreadsheet that you want to convert to PDF.
2. Click the 'File' option from the top navigation bar.
3. Select 'Print' from the context menu.
4. Select 'Adobe PDF' from the 'Printer Name' drop-down box. A file dialog box will appear.
5. Type a new name for the new PDF file.
6. Specify a new location for the file, if desired, using the drive and folder navigators.
7. Click the 'Save' button. The Excel 2003 file has now been saved as a PDF.
8. Open the new PDF file in Adobe Acrobat or Reader and verify that it has was converted correctly.

Read more ►

How to Create a UserForm in Excel 2007

1. Start Excel 2007 and open a new workbook. Click the Microsoft Office Button (on the upper left corner of your task bar), and select Excel Options. In the new pop-up window, click Popular, and check the box titled 'Show Developer tab in the Ribbon.' In Microsoft Office Excel 2007, click Visual Basic in the Code group on the Developer tab. You should now see the Developer Tab on the top of your screen.
2. Click Visual Basic on the Developer tab. Visual basic can be found under Code group on the Developer tab. Now go the Insert menu and select User Form. You can now customize your User Form according to the task you want it to accomplish. If necessary, draw frame controls and label controls. Labels make data entry easier by naming columns and are often needed for data-driven forms.
3. Type the macro code. Double-click the user form to bring up the code window, where you will insert the macro code.
4. Save the user form. When you are finished with the macro, save it and return to Excel. Now go to the Developer tab and click on Macros. In the new pop-up window, click on Show User Form, and press Run to activate your User Form.

Read more ►

How to Calculate Variance in Excel 2007

1. Enter your data into one row in Microsoft Excel.
2. Type '=VAR(' in a cell that does not have data. For example, if all of your data is in column A, then use cell B1 for the variance function.
3. Highlight your data by clicking on the top of the data and dragging the mouse down to the bottom of the data.
4. Type ')' in the cell with your variance function to close the function and then press Enter. The cell now displays the variance of your data.

Read more ►

How to Use Microsoft Excel COUNTIF

1. Open or create a Microsoft Excel worksheet with columns or rows of text in which you want to tally the number of cells containing a single word and nothing else. For example, you could have a column labeled 'Trip Date' and another column labeled 'City.' Let's say you want to find out how many times you went to Detroit in a month.
2. Click the cell at the bottom of the City column. Although you can place the Countif formula in any location, for this example, we will be placing it beneath the City column to count the occurrences of the word Detroit.
3. Type '=COUNTIF(range,criteria),' where the range equals the cell range in which you want to count and the criteria equals the word. For example, you could type the following to count the number of times Detroit appears between cells B2 and B12:=COUNTIF(B2:B12,'Detroit')
4. Press 'Enter' to get your result.

Read more ►

How to Format Excel Margins

1. Click the 'Page Layout' button on the menu ribbon at the top of the screen.
2. Click the 'Margins' button.
3. Click 'Custom Margins' at the bottom of the menu.
4. Click in each text box, and enter the amount you want the margins to be. Do the same for the header and footer.
5. Check the two 'Center on Page' boxes to center the image horizontally and vertically, then click 'OK' to finalize the formatting.

Read more ►

How to Adjust the Right Margin in Excel

1. Open Microsoft Excel.
2. Click the 'Page Layout' tab.
3. Click 'Margins' and select 'Custom Margins.'
4. Change the value of the right margin to whatever you need.
5. Click 'OK' to close the 'Custom Margins' box.

Read more ►

How to Make a Line Graph From a Data Table

1. Open the Excel worksheet.
2. Click and drag to select the data and categories on the worksheet. A dark outline appears around the range of cells.
3. Click the 'Insert' tab on the command Ribbon.
4. Click the 'Line' arrow in the 'Charts' group. A list of chart thumbnails appears, such as '2-D Line' and '3-D Line.'
5. Click the 'Line' button from the 'Line' section. The data converts to an embedded line graph that hovers over the worksheet. The 'Chart Tools' ribbon appears.
6. Edit the chart using the buttons in the 'Design,' 'Layout' or 'Format' tabs, if preferred. The 'Design' commands affect the line colors. The 'Layout' commands can insert picture files, text and titles. The 'Format' commands change the chart's outline and text formats.

Read more ►

How to Use Ticks in Excel

1. Open the Excel file.
2. Click 'Developer Tools' on the command ribbon.
3. Click the down arrow on the 'Insert' button in the 'Controls' group. A list of controls appears.
4. Click the 'Check Box' button. This button displays a check mark inside of a square. The pointer changes to a ' ' symbol.
5. Click on the cell to place the check box. A square and the text 'Check Box 1' display on the worksheet.
6. Edit the text if desired. For example, delete 'Check Box 1' and type an item or a step to compile a list.
7. Click the text to insert a check or tick in the check box. To remove the check, click again on the text.
8. Press 'Ctrl' and 'S' simultaneously to save the file.

Read more ►

How to Plot a Secondary Axis on Microsoft Excel

Secondary Vertical Axis
1. Open the spreadsheet in Excel that contains the chart to which you want to add a secondary axis. Click the 'Microsoft Office' button, then click 'Open' and then locate the file on your computer. Click 'Open' to open the file. Your existing chart should pop up on the screen when you open the spreadsheet. Depending on the type of graph you created, it could be a bar chart, line graph or other graph type.
2. Click the data series in the chart you want to plot on a secondary axis.
3. Click the 'Format' tab, then click 'Format Selection' in the 'Current Selection' group.
4. Click the 'Series Options' tab, then click 'Secondary Axis' below 'Plot Series On.' The secondary axis will be display in the chart.
Secondary Horizontal Axis
5. Click anywhere on the chart to display Chart Tools.
6. Click the 'Layout' tab, then click on 'Axes' from the 'Axes' group.
7. Click 'Secondary Horizontal Axis,' then click the type of display you want. For example, if you want an unlabeled axis, click 'Show Axis Without Labeling.'

Read more ►