Excel
Pages - Menu
(Move to ...)
Home
▼
Friday, January 28, 2011
How to Number in Order With Excel 2007
›
1. Launch Excel to open a blank worksheet or load an existing worksheet. 2. Click on an empty cell where you want the number series to b...
How to Disable Excel 2003 From Automatically Changing Cells to Scientific
›
1. Click the Windows 'Start' button. Type 'excel' in the search text box and press 'Enter.' This is the shortcut c...
How to Have Excel Update Upon Data Entry
›
1. Open the saved Excel worksheet. 2. Click the 'Formula' tab on the command ribbon. 3. Click the down arrow for the 'Calc...
Thursday, January 27, 2011
How to Save a CSV File in Excel 2007
›
1. Open in Microsoft Excel 2007 the spreadsheet you want to save in CSV format. 2. Click the 'Office' button located at the top-...
How to Use Text to Speech in Excel
›
Adding the Text-to-Speech Button 1. Click the 'Down' arrow to the right of the 'Quick Access' toolbar in the top left of y...
How to Make an Interactive Chart
›
Create the Chart 1. Open the saved Excel worksheet. 2. Click and drag the cells for the chart. 3. Click the “Insert” tab on the comman...
How to Use Page Setup in Microsoft Excel 2003
›
1. Access the page setup menu. To access the page setup menu scroll to the “File” tab on the command bar and select “Page Setup.” 2. Set...
How to Calculate Coloured Cells in Excel 2003
›
1. Access Visual Basic Editor by clicking the 'Tools' button on the top of your screen, navigating to the 'Macro' option a...
Wednesday, January 26, 2011
How to Draw a Hexagon on Excel
›
1. Open the Excel 2010 spreadsheet where you want to add your hexagon. 2. Click the 'Insert' tab at the top of the screen. Then ...
How to Autofit Columns in Excel 2007
›
Mouse Method 1. Click on the Excel spreadsheet column that you want to autofit by selecting the letter at the top of the column. If you wa...
How to Create a List Box in Excel 2003
›
1. Launch Excel 2003 and access the 'Forms' toolbar. Click the 'View' menu, highlight the 'Toolbars' option and se...
Tuesday, January 25, 2011
How to Create a Clustered Stacked Chart in Excel
›
1. Start Excel, with the data you want to graph in a set of adjacent cells. For example, if you're comparing production yields of fou...
How to Use MS Query in Excel
›
1. Open a new document in Excel. Go to the 'Data' tab and click on 'From Other Sources.' Select the option 'From Micro...
How to Calculate Coefficient of Variation in Microsoft Excel 2007
›
1. Open your workbook in the Excel 2007 application. 2. Determine the cell addresses of your data array. For example, if your data is co...
How to Remove Duplicate Words in Excel
›
1. Open the worksheet. 2. Click the 'Home' tab on the command ribbon. 3. Click the 'Find Select' down arrow button in...
‹
›
Home
View web version