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.'...
Browse » Home » All posts
Tuesday, June 28, 2011
How to Merge Workbooks in Excel
Preparing a Workbook to Be Shared1. 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...
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 workbo...
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...
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 heig...
Monday, June 27, 2011
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...
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'...
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...
Sunday, June 26, 2011
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'...
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 b...
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 Sub4. Press 'F5' to run the macro on your workshe...
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...
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...
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...
Saturday, June 25, 2011
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 sheetActiveSheet.Hyperlinks.DeleteEnd Sub5. 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”...
Subscribe to:
Posts (Atom)