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 begin.3. Enter the starting number you want, such as '1.'4. Click on an adjacent cell. If you want the number series to run across columns, click on the cell to the right of the one you just numbered. If you want the number series to run down, click below the first cell.5. Type the next number in the series, for example, '2.'6. Select the two cells by clicking and dragging from the first cell to the second cell. Your selection should have a black outline...
Browse » Home » All posts
Friday, January 28, 2011
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 command to open the Excel software. When Excel opens, it automatically loads a default, new spreadsheet. You can use this default spreadsheet to create your book.xlt file.2. Click the 'Format' menu item. From the menu, click 'Style.' This opens a 'Style' window where you edit the format of your cells. Check the 'Number' format.3. Select the number format you want to use in the drop-down box. You can also customize the number format by clicking 'Modify.' Most necessary number formats...
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 'Calculation Options' button in the 'Calculation' group. A list appears.4. Click 'Automatic.' A check mark appears. Excel will calculate as you type the new da...
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-left corner of the program window and select 'Save As.'3. Select in the resulting dialog box the folder where you want the file saved.4. Enter a name for the file in the 'File name' field.5. Click the 'Save as type' drop-down menu and select the 'CSV (Comma delimited)' option.6. Click 'Save.'7. Click 'OK,' followed by 'Yes,' to confirm your choice and save the selected spreadsheet in CSV form...
How to Use Text to Speech in Excel
Adding the Text-to-Speech Button1. Click the 'Down' arrow to the right of the 'Quick Access' toolbar in the top left of your Excel window, right next to the 'Office' button. Click 'More Commands.'2. Select 'All Commands' from the 'Choose Commands From' drop-down list.3. Select 'Speak Cells' in the list box below the drop-down. Click 'Add>>' to add the command to the 'Quick Launch' toolbar.4. Click 'OK' to finish adding the command.Using the Command5. Open the worksheet containing the data you want Excel to read.6. Select the range of data you want Excel to read to you by left-clicking...
How to Make an Interactive Chart
Create the Chart1. Open the saved Excel worksheet.2. Click and drag the cells for the chart.3. Click the “Insert” tab on the command ribbon.4. Click the lower-right arrow for the “Charts” dialog box launcher. The “Insert Chart” dialog box opens with a gallery of chart types.5. Click the preferred chart style in the left pane. Examples include “Column”, “Pie”, and “Area.”6. Click the preferred chart sample in the right pane.7. Click “OK,” then the embedded chart appears on the worksheet with the source data.8. Click in the chart area to activate the “Chart Tools” ribbon. Customize...
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 the “Page” tab preferences. You can set the printing options to either portrait or landscape under this tab, which will print the sheet either vertically or horizontally. You can also set the scaling so the sheet will shrink to print on a single page under the “Scaling” section. Finally, you can set the paper medium and the print quality using the corresponding drop-down menus.3. Set the “Margins” tab preferences. Under this tab, you can specify the width...
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 and then clicking on 'Visual Basic Editor.'2. Copy and paste the following Visual Basic programming module into Visual Basic Editor, and then save it:Function ColorFunction(rColor As Range, rRange As Range, Optional SUM As Boolean)Dim rCell As RangeDim lCol As LongDim vResultlCol = rColor.Interior.ColorIndexIf SUM = True ThenFor Each rCell In rRangeIf rCell.Interior.ColorIndex = lCol ThenvResult = WorksheetFunction.SUM(rCell,vResult)End IfNext rCellElseFor Each rCell In...
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 click the 'Shapes' button under the 'Illustrations' heading. A standard hexagon is the ninth shape listed under the 'Basic Shapes' heading in the menu that appears. Click the hexagon icon.3. Click anywhere on the spreadsheet and hold down the mouse button. Drag your mouse down and to the right. You will see the hexagon appear on your screen and grow as you move your mouse. Continue to drag your mouse until the hexagon is as large as you desire, then release the mouse...
How to Autofit Columns in Excel 2007
Mouse Method1. Click on the Excel spreadsheet column that you want to autofit by selecting the letter at the top of the column. If you want to select multiple columns, hold the mouse button down and drag the mouse to the last column, then release it. If you need to select nonsequential columns, select the first column, then hold 'Ctrl' and select additional columns.2. Move your mouse to the right edge of one of the selected columns. Your mouse still has to be above the columns themselves, up where the column letters are. The mouse pointer changes to a line with two arrows coming off of it...
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 select the 'Forms' listing.2. Type the responses that you want to appear in the list box into individual, sequential cells. For example, type 'Spring,' 'Summer,' 'Fall' and 'Winter' into separate cells 'A:1' though 'A:4.' Put this information on a separate worksheet within the workbook if you do not want users to see them outside of the list box.3. Click the 'List Box' button on the Forms toolbar. Click once in the area of the worksheet to which you want to add the list box. Drag...
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 four different types of component over eight calendar quarters, you'd have a grid that had the four types of components listed in cells A2 through A5, and the eight calendar quarters listed from cells B1 through I1. The numerical values of what components were made in which quarter would be entered in cells C2 through I5.2. Insert two blank rows between each row of data in the table in step one.3. Select cells F2 through I2. Right-click on the range of selected...
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 Microsoft Query.'2. Double-click on the option 'New Data Source' in the Databases tab. Type a name you would like to give the data source. Select a driver for the type of database that you are using for the data source. Click on the 'Connect' button.3. Provide the necessary information when prompted, and click 'OK.' This will depend on the type of driver that was selected. For example, if your data source is an Excel file, you will be asked to select a workbook.4. Click on the...
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 contained in the first 20 rows of column A, your cell addresses are A1:A20.3. Click a blank cell and type the following formula: =(STDEV(A1:A20)/AVERAGE(A1:A20))Substitute the address of your data array in place of A1:A20 in the above example.4. Press 'Enter.' Excel divides the standard deviation of the array by the average value of the array. The result of this calculation is the array's coefficient of variation, which is displayed in the ce...
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 the 'Editing' group.4. Click the 'Replace' command. A 'Find and Replace' dialog box will appear.5. Click the 'Replace' tab. This tab includes two text boxes: 'Find what' and 'Replace with.'6. Enter the word in the 'Find what' text box.7. Leave a blank in the 'Replace with' box.8. Click the 'Find All' button. A list of the repeated word(s) and cell references will appear.9. Click on the row that contains the repeated word.10. Click the 'Replace' button. The repeated...
Subscribe to:
Posts (Atom)