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 ►

How to Open Excel 2007 in an Earlier Version of Excel

1. Go to the Microsoft Download Center online.
2. Click on the Microsoft Compatibility Pack. Click 'Download.'
3. Click 'Run' in the box that appears on the screen.
4. Click 'Run' in the next box that appears on the screen.
5. Check the box 'Accept' to accept the terms.
6. Click 'OK' in the next box to appear on the screen. Wait for the loading to finish.
7. Open Excel and double-click on the Excel 2007 file that needs to be opened. Wait for the file conversion to complete.
8. Makes changes and work in the file, saving it when done.

Read more ►

How to Insert a Tab Name in a Cell

1. Open Microsoft Excel. Choose the spreadsheet you want to work with.
2. Click on the cell where you want to insert the tab name.
3. Enter the following formula into the cell:=MID(CELL('filename',A1),FIND(']',CELL('filename',A1)) 1,256)

Read more ►

How to Convert Excel to DAT

1. Double click to open your Microsoft Excel 2010 file.
2. Click the 'File' tab in the upper-left corner, then select 'Save As.'
3. Click the drop-down menu to the right of 'Save As Type' and select 'CSV (Comma Delimited).'
4. Click the 'Save' button, click 'OK' to save the active sheet, then click 'Yes' to keep the worksheet in CSV format.
5. Right click the CSV file you just created, click 'Open With' and select 'Notepad.'
6. Click 'File' at the top of the window, then click 'Save As.'
7. Click the drop-down menu to the right of 'Save As Type' and choose 'All Files.'
8. Click inside the 'File Name' field and add '.dat' to the end. For example, if your filename is 'xxxxxx,' modify it so it reads, 'xxxxxx.dat.'
9. Click the 'Save' button.

Read more ►

How to Change the Macro Security Levels on Excel 2003

1. Open the Microsoft Excel 2003 application on your computer, and then click the 'File' option from the top toolbar menu.
2. Click the 'Open' option, and then select the Excel 2003 document you want to work with. Click the 'Open' button.
3. Click the 'Tools' option from the top Excel toolbar menu, and then click the 'Options' button.
4. Click the 'Security' tab in the new dialog box that appears on the screen. Click the 'Macro Security' option.
5. Select the 'Security Level' tab and then select the 'Very High', 'High', 'Medium' or 'Low' option. Click the 'OK' button and close out of the dialog box.

Read more ►

How to Delete the First Five Characters in Excel 2007

1. Open your spreadsheet in Microsoft Excel 2007.
2. Locate the cell that contains the text you need to truncate.
3. Enter the following text in a new cell, replacing 'old_text' with the cell reference of the text you need to truncate.=REPLACE(old_text,1,5,'')As an example, to delete the first five characters from cell A1, you would enter:=REPLACE(A1,1,5,'')Alternatively, you can replace 'old_text' with the actual text encased in quotes. As an example, to delete the first five characters from the text 'truncate me!,' you would enter:=REPLACE('truncate me!',1,5,'')

Read more ►