Tutorial for Solving a System of Linear Equations With Excel

1. Type the equation into a cell, substituting another cell's reference for the equation's variable. For instance, if the equation is '6x 33 = -1,' type '=A2 * 6 33' into cell A1.
2. Click on 'Data' from the menu bar. Click 'Solver' from the 'Analysis' tab.
3. Type the formula's cell reference into the 'Set Objective:' box. With this example, type 'A1.'
4. Enter the equation's target value in the 'Value Of:' box. With this example, type '-1.'
5. Type the cell reference that you substituted in Step 1 into the 'By Changing Variable Cells:' box. With this example, type 'A2.'
6. Click 'Solve.' Excel will change the cells' values to solve the equation. With this example, cell A1 will become '33,' and cell A2 will become '-5.667.'
7. Repeat the process for all your linear equations.

Read more ►

How to Merge Workbooks in Excel

Preparing a Workbook to Be Shared
1. Open the workbook you want to distribute.
2. Open the Tools menu and click Share Workbook, and then click the Editing tab.
3. Select the 'Allow changes by more than one user at the same time' box.
4. Click the Advanced tab.
5. Under 'Track changes,' click 'Keep change history for.'
6. In the Days box, type a few days longer than the number of days reviewers will spend making changes and comments in the shared workbook.
7. Click OK.
8. Save the workbook.
9. Make copies of the workbook to distribute by using the Save As command in the File menu. Give each copy a different name, such as 'Budget - Sulhi copy' and 'Budget - Marina copy.'
Merging the Shared Workbooks Back Together
10. Open your base copy of the workbook you distributed.
11. Open the Tools menu and select Merge Workbooks.
12. Save the shared workbook if you are prompted.
13. In the box that appears, select one of the copies you made of the workbook.
14. Click OK.
15. Repeats steps 2 through 4 until all copies of the shared workbooks are merged.

Read more ►

How to Protect Macros in Excel 2003

1. Access the Excel 2003 workbook that contains the macro you need to protect. Click the 'Tools' menu and select 'Macros.'
2. Click 'Visual Basic Editor.' Click the 'Tools' option and then select 'VBAProject Properties.'
3. Navigate to the 'Protection' tab. Click the check box labeled 'Lock project from viewing.'
4. Type the password you want to use for the macro in the text box. Press 'Tab' and then type the password again in the second text box.
5. Click 'OK' and then save your Excel workbook.

Read more ►

How to Do an Outline in Excel

1. Open the Excel 2010 file that holds the data that you want to outline.
2. Insert summary columns into your data. These are the columns that will summarize the hidden numerical data when you outline is compressed. Right-click the column letter where you want to place the column and select 'Insert.' Select the cell next to the cells that you want to subtotal and enter in '=subtotal(9,X:Y)', where 'X' is the first cell in the range and 'Y' is the last.
3. Click the letter where you want to start your outline. Hold 'Shift' and select the letter where you want end your outline. If you have a summary column at the end of your data, do not include it in your selection.
4. Select the 'Data' tab from the top of the screen. Find the 'Outline' area and click the 'Group' button. A line will appear above the cells, with a '-' on one end. You can click the '-' to close the outline. Just click the ' ' button to open it again. Because your summary column was not included in your selection, it will remain visible when you close the outline.
5. Select additional columns within the overall outline selection. Click the 'Group' button again to group these columns together. Another line will appear, this time just below the first one.
6. Continue to group columns in the same manner until your outline is finished. Your outline can grow up to eight levels deep.

Read more ►

How to Copy Paste Row Height in Excel 2007

1. Open an Excel spreadsheet with data.
2. Hover your mouse on the line between two row numbers until you see two black arrows facing in opposite directions appear. Click and drag up or down to adjust the row height.
3. Hover your mouse over the row number you just adjusted until the black arrow pointing to the right appears. Click that row to highlight it.
4. Click the 'Home' tab, and then click the little paintbrush icon in the Clipboard group. Your highlighted row should now have a moving, dashed line around it.
5. Click on a row number to paste the row height.

Read more ►

How to Make Line Graphs in Excel

1. Enter the values you wish to graph in a single column with no spaces.
2. If you wish to attach a descriptor to each value, enter the descriptor to the left of each number in the column. For example, if you want to see how much weight you've lost over time, list the date on the left and the value on the right for each time you've stepped on a scale.
3. Click and drag to highlight all the information you've just entered, including your descriptors. That should cause a blinking box to surround the data you wish to graph.
4. From the top menu, select 'Insert' and then 'Chart.' Choose 'Line graph' from the list of chart types, then select your preferred style from the thumbnails.
5. Follow the prompts to enter a title for your graph and label the X (horizontal) and Y (vertical) axes. Your descriptors should already appear along the X axis. You will then be allowed to choose whether to create your graph within your spreadsheet or on a new sheet.

Read more ►

How to Import a Macro to Excel 2007

1. Open the Microsoft Excel 2007 file that you want to import the macro code into and then click on the 'Developer' tab.
2. Click on the 'Macro Security' option from the 'Code' group. Click on the 'Macro Settings' option from the 'Macro Settings' category.
3. Click on the 'Enable all macros' option and then click on the 'OK' button. Minimize your workbook.
4. Open the Excel file that contains the macro that you want to copy. Click on the 'Developer' tab and then click on the 'Visual Basic' option from the 'Code' group.
5. Click on the 'View' menu option and then click on the 'Project Explorer' option. Click on the macros module you want to import and drag into the other workbook that you want it copied to. The macro will then be fully added to your workbook.

Read more ►

How to Consolidate Worksheets in Excel

1. Turn on your computer and open the Excel spreadsheets that need to be consolidated.
2. Consolidate spreadsheets by position, category, formula or by using a PivotTable. For this how-to we are going to be consolidating by category. Begin by making sure the format is identical in each worksheet. For example, 'Annual Avg.' and 'Annual Average' are seen as different and won't consolidate together.
3. Next go to the worksheet that you want to consolidate and click 'Data,' then choose 'Consolidate.' This will open the Consolidate box.
4. Specify the range by using the Reference box in the window. Click 'Add' to move the range to the 'All References' box. Continue adding ranges until all are defined.
5. Check the 'Create links to source data' box to add links back to the original data. Then click 'Ok' to save and perform the consolidation.

Read more ►

How to Add New Data to Excel 2007 Charts

1. Open the Microsoft Excel 2007 application and the worksheet containing the chart that you want to work with.
2. Click on the chart that you want to add new data for to display the Chart Tools. Make sure you also have the new data stored in the same worksheet where the chart is stored.
3. Click on the 'Design' tab and then click on the 'Select Data' option from the 'Data' group.
4. Click on the 'Add' option from the Select Data Source dialog box. The Edit Series dialog box will then appear.
5. Enter the name for the new series of data into the 'Series name' box. Click in the 'Series values' box and then select the group of cells in your worksheet that contain the new data you want to add. The new data will be added to your chart.

Read more ►

How to Set Excel 2003 Print DPI

1. Launch Microsoft Excel 2003 and open the spreadsheet you want to print.
2. Open the 'File' menu at the top of the window and select 'Page Setup' from the drop-down list.
3. Go to the 'Page' tab at the top of the Page Setup window.
4. Click on the drop-down box next to 'Print Quality' and select the new DPI setting you want to use. The available DPI options will differ based on the type of printer you are using.
5. Click 'OK' to save the settings or press 'Print' to go directly to the main printing dialog box.

Read more ►

How to Select All With Excel VBA Macros

1. Press 'Alt' and 'F11' together on your keyboard from within Microsoft Excel.
2. Open a new module by clicking on 'Open' and then 'Module.'
3. Copy and paste the following code into the blank window:Sub Macro1()'' Macro1 MacroCells.SelectRange('J1').ActivateEnd Sub
4. Press 'F5' to run the macro on your worksheet.

Read more ►

How to Import a Selected Range of Cells Into Access From Excel 2003

1. Open the Excel 2003 spreadsheet that you want to import. Drag your cursor along the record selection buttons to the left of your cells until you encompass the intended records. Press 'Ctrl' and 'C' to copy the records, select another tab in your spreadsheet and press 'Ctrl' and 'V' to paste.
2. Label the second tab with a description so that you can recognize it from Access. Save your Excel spreadsheet after making all of your changes. Close your Excel spreadsheet and open the Access database.
3. Click the 'External Data' tab of the ribbon at the top of the page and select 'Excel.' If you are using Access 2003, click 'File,' then 'Get External Data' and then 'Import.' Locate the Excel spreadsheet saved on your computer and choose whether to add it to a new table or an existing table.
4. Choose the tab with the selected records out of the worksheet options in the import wizard. This option allows you to import single sheets from the same Excel file. Instead of needing to create a new spreadsheet for certain information, you can simply choose a certain sheet.
5. Specify the fields you want to import and the primary key if you're creating a new table. If your records don't have an appropriate field, Access can create a primary key field for you. Name the table and complete the import wizard.

Read more ►

How to Remove Columns in Microsoft Excel 2003

1. Activate the column that you want to remove by left-clicking on the column letter, located at the top of the spreadsheet. When you left-click on the column letter, it will highlight and activate the entire column.
2. Access the remove column properties box. To access this menu, simply right-click on the highlighted column that you wish to remove. A sub-menu will open.
3. Select the remove column attributes. Scroll to “Delete” in the column properties sub-menu. Left-click on it to remove the column.
4. Save the edited spreadsheet. Make sure to save your file after making any changes by accessing the “File” tab on the command bar and left-clicking on “Save.”

Read more ►

How to Organize in Excel 2007

1. Open your Excel 2007 program. Right click the bottom of the program where is says 'Sheet 1.'
2. Click 'Rename' to give the worksheet a specific name. You can also rename the other available sheets or add more sheets by clicking the icon next to 'Sheet 3.' Multiple sheets allows you to organize different sets of data within the same spreadsheet, such as expenses and payments.
3. Type in the headers for your columns or rows to start adding data. For example, you might have separate columns for various types of expenses. You can add each expense to different rows along with the cost to organize the information more effectively.
4. Move your data into a table for even more organization power. Highlight the data you want in the table. Click 'Format as Table' from Styles. Choose a table layout. Your data will then be moved into a table, which makes sorting much easier.
5. Sum up totals for expenses, payments and other information with numbers or money easily. Highlight all the columns or rows you want to add up. Highlight one extra cell. From 'Formulas,' click 'AutoSum' and the numbers you highlighted will add up on the last cell.

Read more ►

How to Remove All Hyperlinks in an Excel Spreadsheet

1. Open the spreadsheet you want to remove all the hyperlinks from.
2. Hit the “Alt' and “F11” keys to get to the Visual Basic Editor.
3. Click “Insert” on the task bar. Click “Module” from the drop-down menu. A box opens.
4. Paste the following command into the module box.Sub RemoveHyperlinks()
'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete
End Sub
5. Click “File” and “Close.” The macro is now ready for use in Excel.
6. Return to the Excel spreadsheet. Click “Tools” on the spreadsheet toolbar. Click “Macros' from the drop-down menu.
7. Click “RemoveAllHyperlinks” and then the “Run” button. The hyperlinks in the document disappear.

Read more ►