Excel
Pages - Menu
(Move to ...)
Home
▼
Tuesday, June 28, 2011
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...
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...
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.'...
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 column...
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...
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 ...
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. Clic...
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...
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 th...
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 ...
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 ...
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 ...
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...
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 giv...
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 Edito...
‹
›
Home
View web version