How to Make a Parabola on Excel

1. Enter a series of x values into the cells in a column, entering multiple values on either side of the vertex. If you are unsure of the vertex, enter a wide range of x values.
2. Enter an equal sign followed by the formula being graphed into a cell next to the top x value, then click on the lower right corner of the cell and drag down to the cell next to the bottom x value to copy the formula automatically. Excel will not display the formula in the cells, it will show the results.
3. Highlight the values entered in both columns. If you were not sure of the vertex, find the point where the change in y reversed direction then choose cells on either side of that point. For example, if y was getting larger for five cells, then smaller for the remaining cells, the vertex is between the fifth and sixth values. The more cells chosen, the more accurate your graph will be.
4. Click 'Insert' from the menu, then select 'Chart' to launch the chart creation wizard.
5. Select 'XY Scatterplot' from the wizard.
6. Adjust the look of your graph to meet your desires by following through the wizard. You will be given the option to customize the labels, the colors and the grid lines of the graph, among other options.
7. Click finish to create the graph.
8. Click on a corner of the graph and move your mouse to adjust the size of the graph.

Read more ►

How to Convert a Mac Date System to Excel

1. Open the Excel file that contains the cells with incorrect dates.
2. Click on any empty cell. Type '1462' into this cell, as this signifies the number of days between the two date systems. Right-click the cell and choose 'Copy.'
3. Select the cells that contain the incorrect dates. To select multiple cells, click and hold on the top left cell in a range and then drag your mouse to the bottom right cell. Hold the 'Ctrl' button to select ranges that aren't adjacent to each other.
4. Right-click on any of the selected cells. Move your mouse over 'Paste Special' in the first pop-up menu that appears, and then click on 'Paste Special' that appears at the bottom of the second pop-up menu. This brings up the 'Paste Special' window.
5. Click the radio button next to 'Add' in the 'Operation' area of the window and click 'OK.' The selected dates will shift up by 4 years and a day.

Read more ►

How to Insert a PDF Into Excel

1. Open Excel 2007 and select the 'Insert' tab. Select 'Object' from the 'Text' group. The Object dialog box appears. Click the 'Create from File' tab. Select the 'Browse' button. Search your files to locate the PDF that you plan to insert. Click the file and select 'Insert.' Click 'OK.' Excel inserts the PDF into your document as an image.
2. Review the image of the PDF in your workbook. Open the PDF by right-clicking the image and select 'Adobe Document Object.' Select 'Open.' The PDF opens with Adobe in a separate Adobe window.
3. Save your changes by clicking the 'Save' icon the Quick Access Toolbar. The newly attached PDF is inserted as an attached image in your Excel workbook.

Read more ►

How to Subtract Cells in Excel

Create a Formula
1. Enter your data. For the purpose of this example, type the number 34 in cell A1 and the number 15 in B1.
2. Choose the cell where you want your results to appear. Use C1, for instance.
3. Place an equal sign (=) in C1. The equal sign always precedes formulas in Excel and goes into the cell where your results will be displayed.
4. Click on cell A1. Clicking on this cell automatically places 'A1' in cell C1.
5. Type a minus sign (-) in cell C1.
6. Click on cell B1. Clicking on this cell automatically places 'B1' in cell C1.
7. Press the 'Enter' key on your keyboard, or click on the check mark on the tool bar, to see the result of your calculation. Excel performs the calculation instantly and cell C1 displays the answer, 19. Notice that the formula appears in the formula bar when you click on cell C1.
Subtract Numbers using the SUM Function and the Autosum Button
8. Type a number into A1. For instance, type the number 10.
9. Type a number into B1, preceded by the minus sign. For instance, -8.
10. Click on the cell where you want the answer displayed, like C1.
11. Use the SUM function. Type =SUM(A1, B1) into cell C1. Click the check mark on the tool bar or press the 'Enter button' to display the answer in C1.
12. Use the 'Autosum' button, which automates the SUM function. Enter your data and then click cell C1. Click the 'Autosum' button on the toolbar to display the answer, 2, in cell C1.

Read more ►

How to Convert Excel 2007 to Excel 2002

Instructions
1. Complete your spreadsheet. Save as usual by clicking on the 'Office' button and selecting 'Save' from the drop-down menu. This will open a pop-up window. Type your file name in the 'File Name' box and click 'Save.' This will save your spreadsheet as an Excel 2007 file with the extension '.xlxs' and ensure that you have access to the original document.
2. Use the 'Save As' option to convert your Excel 2007 file to one that is compatible with earlier versions of Excel. Click on the 'Office' button again to reveal the drop-down menu.
3. Select 'Save As' from the drop-down menu. This will reveal a sidebar menu with several format options. From this menu, select 'Excel 97-2003 Workbook.' In the pop-up window that opens, type in your file's name and click 'Save.' This will convert your spreadsheet into an Excel file with the extension '.xls.'

Read more ►

How to Copy an Excel Worksheet

1. Open Microsoft Excel and the file you want to change.
2. Open the Edit menu and select Move or Copy Worksheet.
3. Click the Create a Copy option in the dialog box.
4. Select OK to create a copy.
5. Rename your newly copied worksheet by double-clicking its tab at the bottom of the Excel window.

Read more ►

How to Remove Characters in Excel 2007

1. Open your spreadsheet and select all cells from which you want to remove the character string.
2. Click the 'Home' tab and click 'Find Select' in the 'Editing' group. Click 'Replace' to open a Find and Replace dialog box.
3. Type the character or string of characters that you want to eliminate in the 'Find what' field.
4. Type the new characters that you want to insert in place of the removed characters in the 'Replace with' field. If you simply want to delete the characters, then don't type anything in this field.
5. Click the 'Find Next' button if you want to perform the search-and-replace function manually.
6. Click 'Replace All' to remove all instances of the specified characters in the selected cells.

Read more ►

How to Get Started With Excel VBA

Record a Macro
1. If you have ever recorded a macro, you are already using VBA. The Visual Basic editor translates your keystrokes into VBA commands. The resulting code is inefficient, but it can help you get familiar with VBA syntax and commands.
2. In Excel, record a simple macro. In Office XP, select Macro, Record New Macro from the Tools menu. (In Excel 2007, commands are on the Developer tab.) Change the macro name or leave the default, and press OK.
3. With the macro recorder running, type 'Hello World' in cell A1. Apply Bold, Italic, and Underline, and change the font color to red. Double-click on the column separator in the header row, between columns A and B, to resize the cell's width to its contents.
4. Turn off the macro recorder by selecting Tools, Macro, Stop Recording.
5. Test the macro to make sure the message appears.
Examine Recorded Code
6. Right-click on the Sheet1 tab and select View Code, or press Alt-F11, to open the VB editor, and double-click on Module 1. Your macro code will look something like this:Sub Macro1()ActiveCell.FormulaR1C1 = 'Hello World'
Range('A1').Select
Selection.Font.Bold = True
Selection.Font.Italic = True
Selection.Font.Underline = xlUnderlineStyleSingle
Columns('A:A').EntireColumn.AutoFit
Selection.Font.ColorIndex = 3End Sub
7. Note that the macro begins with 'Sub' and ends with 'End Sub.' Every VBA subroutine begins and ends this way.
8. Find familiar keywords. Since you know what this macro does, you can figure out that 'Selection.Font.Bold=True' changes the selection to bold font. You can also recognize the commands to resize the column and change the color.
9. Go back to Excel and try recording a few more simple macros, each time examining the code in the VB editor.
Set Up the VB Editor
10. Launch the VB editor by pressing Alt-F11.
11. Click on each menu item across the top to familiarize yourself with available options.
12. Set up your environment with options from the View menu. At a minimum, add the Properties Window and the Project Explorer. You can dock them to the left side of the screen by right-clicking and selecting 'Dockable.'
13. Try the context-sensitive Help feature at any time by pressing F1.
Design a Form
14. From the Insert menu, select Insert UserForm. The UserForm is your design canvas.
15. If the UserForm doesn't pop up, go to the Project Editor and double-click 'Forms,' then double-click UserForm1.
16. When the UserForm appears, you will also see the Toolbox, which contains controls you will use in creating your forms. For instance, you can include buttons, text boxes, drop-downs and labels. Hover your cursor over each to see the names.
17. Add some controls to your form. To add a text box, find it in the Tool Box, click on it, then move your cursor to the User Form and draw a rectangle on the form. You will see a shape that looks something like a window. This is where the user will enter his input.
18. Place more controls on the form. Experiment with resizing and rearranging. For some controls to work, they need to be programmed. For instance, an 'OK' button needs an associated sequence of actions. Other controls, like labels, usually need little, if any, programming.
Program a Message Box
19. The 'MsgBox' is preset; you will not need to design a form. But you will need some code. You can program 'Yes,' 'No,' 'OK' and 'Cancel' buttons, configure the prompt, and more.
20. This message box will warn the user that the file will close without saving when she clicks 'Yes.' If she clicks 'No,' the file will save before closing. If she selects 'Cancel,' the file will not close.
21. Launch the VB editor. From the Insert menu, insert a module; then, in the Project Explorer, double-click the new module. A code window will open up.
22. Type the following routine. (Do not type the text in the brackets that follow.)
Sub MsgBoxTest() [Subroutines always begin with Sub and end with End Sub]
myTitle = 'Warning' [Assigns a value to 'myTitle.' When you use 'myTitle' later, it's the same as typing 'Warning.']
myMsg = 'Close without saving? All changes will be lost.' [Assigns a value to 'MyMsg.']
Response = MsgBox(myMsg, vbExclamation vbYesNoCancel, myTitle) [Defines the message box. It will contain 'myMsg,' a warning exclamation point, and Yes, No and Cancel buttons, and the title bar will read 'Warning,' because that's the value of 'myTitle.']
Select Case Response [Select Case assigns actions to various options.]
Case Is = vbYes [If the user clicks Yes]
ActiveWorkbook.Close SaveChanges:=False [Close without saving.]
Case Is = vbNo [If the user clicks No]
ActiveWorkbook.Close SaveChanges:=True [Save and close.]
Case Is = vbCancel [If the user clicks Cancel]
Exit Sub [Exit the subroutine. Don't do anything.]
End Select [This ends the Select Case statement.]
End Sub [Ends the subroutine]
23. Select Run, Run Sub/User Form from the menu. Your message box will be displayed; you have now successfully written a functioning VBA routine.

Read more ►

How to Create Multiple Graphs in One Chart

1. Open your spreadsheet program and enter your two data sets into adjacent columns. Type a label for your data sets in the first row of each column. (Note: These instructions are based on Open Office Calc, a free spreadsheet program, but the process will be similar when using Microsoft Excel.)
2. Click and drag to select all of the cells whose data you wish to include in your chart, including the 'label' cells at the top of each column.
3. Click 'Insert' and then 'Chart.' Select 'Line' from the 'Choose a chart type' column. Select 'Lines and Points' from the icons on the right-hand side of the dialog box. Click 'Next.' Make sure the 'First row as label' box is checked and then 'Next' twice.
4. Type in a title for your chart, a subtitle (if desired) and names for the X axis and Y axis. Click 'Finish.'

Read more ►

How to Create a 4 Axis Chart in Excel

1. Create a new spreadsheet in Excel.
2. Type the label names of your axes in each column, for example, Axis 01, Axis 02, Axis 03, and Axis 04 as headers in columns A, B, C, and D respectively.
3. Type the corresponding data for each column and row. The row data will be the “Series” plotted against the actual axis of each column.
4. Highlight the entire set of rows and columns by dragging the mouse cursor across the axis and data fields while holding the left mouse button down.
5. Click “Insert,' 'Charts,' then 'Other Charts' and choose a 'Radar' option from the main menu.

Read more ►

How to Print Odd Even Pages in Excel 2007

1. Click on the 'Developer' tab in Excel 2007.
2. Click on 'Visual Basic' to open the Visual Basic Editor (VBE).
3. Click 'Insert,' then 'Module' to open a blank module window.
4. Copy and paste the following code into the module window:Sub PrintOddEven()Dim TotalPages As LongDim StartPage As LongDim Page As IntegerStartPage = InputBox('Enter starting page number')TotalPages = Application.ExecuteExcel4Macro('GET.DOCUMENT(50)')If StartPage > 0 And StartPage
5. Press 'F5' to run the macro. A pop-up window will appear and you will be returned to the Excel spreadsheet.
6. Type the starting page number in the textbox. If you want to print odd pages, enter an odd number. If you want to print even pages, enter an even number. Excel will print odd or even pages from that starting point. For example, if you type '1,' Excel will print odd pages 1 through the end of your document.

Read more ►

How to Make a 2 Column List in an Excel Spreadsheet

1. Open Microsoft Excel 2007 on your computer. As you can see, several columns and rows already come up in Excel.
2. Place a title at the top of the spreadsheet. This is very important so that you know what is actually listed in the spreadsheet. Place the title at the very top of the page, starting in cell A1.
3. Add titles to the two columns that will compose the list. Place the column titles a few lines down from the title of the spreadsheet. This will help you remember what information is in each column. Center the columns by highlighting both cells and click on the centering icon (showing centered text) in the 'Alignment' section of the 'Home' tab.
4. Bold the title of the spreadsheet and the titles of the columns. Highlight the cells to be bolded and click on the bold icon in the 'Font' section of the 'Home' tab.
5. Skip a line after the column titles and enter your data into columns A and B. You can enter text or numbers, depending on the purpose of the two-column list.
6. Format any numbers that you have entered. If you entered dates, monetary amounts or regular numbers in the columns, you can format them so that all of the numbers look the same. To do this, highlight all of the cells with numbers that you want to format in the same way. Right click and select 'Format Cells.' Use the tools in the 'Number' tab to format the cells according to your purpose.
7. Create totals for columns with numbers, if needed. To do this, click on the cell where you want the total to be, and then click on the sigma symbol (it kind of looks like an E) in the 'Editing' section of the 'Home' tab. The following will appear in the cell: =SUM(). Click on the first cell that you want included in the total, and drag down to highlight the last cell to include in the total. Press 'Enter' and the total will be inserted.

Read more ►

How to Delete a Macro Computer Virus

1. Run the program that the infecting macro was originally opened with, such as Microsoft Word or Excel, by double-clicking on its appropriate desktop icon.
2.
Click on the 'View' tab at the top of the screen. Scroll all the way over to the far right side of the screen and click on the button labeled 'Macros.' Click on 'View Macros' on the drop-down menu that will pop up underneath the Macro button.
3.
Wait for the new window to pop up and then scroll through the list of macros installed until you find the one that infected your computer. Click on the name of the macro and then click on the button that is labeled 'Delete.'
4. Close the 'View Macro' window and then click on the large, circular Microsoft icon at the top left of the screen. Click on the option that says the name of the program followed by 'Options,' such as 'Excel Options.' Click on 'Trust Center' and then click the button that says 'Trust Center Options.' Click the option marked as 'Macro' settings and then click the radio button next to the option that says 'Disable all macros.'
5. Open your web browser and navigate to a website that offers a virus scanning program such as AVG Free (see Resources below). Download the installation file and then open the folder where you saved the file. Double-click on it and follow the on-screen instructions to install the program. Open the software by double-clicking on its desktop icon and then click on the option to run a full system scan. Wait for the scan to finish and then click on the option to delete any virus threats found.

Read more ►

How to Format Rows and Columns in Excel 2003

1. Open your Excel worksheet and select the rows or columns you want to format. To select, hold down the left mouse button and drag.
2. Click 'Format' on the top menu bar to summon a list of options for formatting your worksheet.
3. Click either 'Row' or 'Column.' The rows are horizontal, the columns are vertical.
4. If you click 'Row,' a box will appear. Enter the row height. If you pick 'Column,' enter the column's width in the designated box.
5. When you've finished formatting, click 'OK' and save your work.

Read more ►

How to Restore Microsoft Excel to Its Default Spreadsheet

Excel 2003 or Earlier
1. Go to \'C:\\Documents and Settings\\
\\Application Data\\Microsoft\\Templates.\' Open \'My Computer\' and open the \'Documents and Settings\' folder. Open your username, then \'Application Data,\' \'Microsoft\' and finally find the \'Templates\' folder.
2. Rename the Book.xlt and Sheet.xlt files to something that you will remember. This step is optional, but allows you to save the settings for later use. Either move these files, or delete them if you don't want to use the template again. If there are no XLT files in this folder, continue below.
3. Go to \'C:\\Program Files\\Microsoft Office\\Office11\\XLStart.\' Navigate to \'Program Files,\' and open the \'Microsoft Office\' directory. Select \'Office11\' and then \'XLStart.\'
4. Look for any template files inside this folder--these are any files with a \'.xlt\' extension. If there are any, delete them. If there are none, continue below.
5. Open Microsoft Excel, and locate the \'Options\' settings under the \'Tools\' menu.
6. Click the \'General\' tab and note which folder is listed \'At Startup, open all files in.\' Minimize or close Excel and navigate to the folder listed in that box.
7. Delete any existing XLT files in that folder. If you want to save them for later use, rename the template using a name you will remember.
8. Open, or close and reopen Microsoft Excel to verify the settings returned to default.
Excel 2007 or Later
9. Open Microsoft Excel.
10. Navigate to the Help menu and open the \'Detect and Repair\' function. The Detect and Repair dialog will appear. If you want to restore your shortcuts at this time, check the appropriate icon.
11. Click \'Start.\' Wait for a short period while Office deletes all of the settings on all of the programs in the suite and restores it to its original installed state. This will apply the settings to Word, PowerPoint and Excel, and any other Office programs you have installed.

Read more ►