Excel
Pages - Menu
(Move to ...)
Home
▼
Saturday, December 28, 2013
How to Set Excel 2003 as Your Default if You Have 2007 Installed
›
1. Close any open Excel windows. 2. Click 'Start' and then click 'Run' from Windows XP; click the 'Microsoft' bu...
How to Calculate the P
›
Calculate Correlation 1. Open the workbook that contains your data in Excel 2007. 2. Determine the cell addresses that contain the two r...
How to Send a Microsoft Excel 2007 Worksheet As an Email
›
Sending an Excel File Via E-mail 1. Power on your computer and open your e-mail server or log in to your online e-mail. 2. Click the but...
How to Insert a Row in Microsoft Excel 2003
›
How to Add a Single Row 1. Open an Excel Worksheet or create a new one. 2. Highlight the row header immediately below where the new row ...
Friday, December 27, 2013
How to Use Correlation on Excel 2007
›
1. Open Microsoft Excel 2007. Click on the 'File' option, then select 'Open.' 2. Locate the Excel file that contains ...
How to Use Microsoft Excel to Draw Control Charts and Graphs
›
Excel 2007 1. Open a new file by clicking on the “Office” button and choosing “New.” 2. Type “control chart” into the ‘Search Microsoft ...
How to Insert a Watermarked Picture in Excel 2007
›
1. Open your Excel document. Select the 'Insert' tab. 2. Click the 'Picture' icon on the ribbons bar. Search for the fil...
Thursday, December 26, 2013
How to Get Microsoft Excel Cells to Shade Gray When Highlighted
›
1. Open the Microsoft Excel program on your computer. It is usually found in the 'Start' menu under 'Microsoft Office' in ...
How to Use the Paste Special Command in Excel
›
Switching Rows of Cells to Columns or Columns to Rows 1. Select the cells that you want to switch. 2. Open the Edit menu and select Copy...
How to Copy an Array to a Range in Excel 2007
›
1. Open Excel and load the worksheet with the data sets you want to use to feed an array formula. 2. Select a cell and enter the array f...
How to Create Named Ranges in Excel 2007
›
1. Launch the Microsoft Excel program by double-clicking the program's shortcut on the desktop or by selecting 'Microsoft Excel...
Wednesday, December 25, 2013
How to Make a Striped Line on a Bar Graph in Excel on a Mac
›
1. Double-click the Excel icon on the Dock or find the program in your Applications folder and double-click it. Open the Excel graph throu...
How to Print or Page Setup in Excel 2007
›
1. Click the Office Button at the top left-hand corner. Select 'Print' from the options available and then select 'Print Prev...
How to Make Drop Down Fields in Microsoft Excel
›
1. Start Microsoft Excel. Open a new blank spreadsheet, or open the spreadsheet to which you want to add a drop down list. 2. Select the...
Tuesday, December 24, 2013
How to Find Duplicate Entries on Excel
›
1. Launch Microsoft Office Excel 2007 on your computer. 2. Select the rows or columns where you want to find the duplicate entries. Poin...
›
Home
View web version