Tutorials Home

Introduction By the end of this lesson, you should be able to: Move and copy cell contents using: Cut, copy, and paste Drag and drop Moving and copying cell contents If you're not happy with the location of your data, you don't have to delete it and start entering data all over again. Instead, you can move it around in the worksheet. Basic moving and copying techniques can be reviewed in our Office 2000 tutorial. Copying and pasting cells The Office 2000 Clipboard is helpful if you want to transfer information within a worksheet. In fact, the Clipboard allows you to store up to 12 items and paste them one at a time or all of them at once. To turn on the  Clipboard  toolbar, choose  View Toolbars Clipboard  from the menu bar. To cut, copy, and paste: Select a cell or cells to be duplicated. Click the  Copy  button. Marching ants appear around the selected cells. If you want to move the information from one cell to another, click ...

Introduction By the end of this lesson, you should be able to: Insert cells Delete cells Inserting cells When working in an Excel worksheet, you may need to insert or delete cells without inserting or deleting entire rows or columns. To insert cells: Select the range where new cells should be inserted. Right-click  and select  Insert . The  Insert  dialog box opens and presents the following four choices: Shift cells right : The cells in the same row are shifted right. Shift cells down : Selected cells and all cells below them in the same column are shifted. Entire row : This inserts an entire row of cells. Entire column : This inserts an entire column. Choose an option, then click  OK . Your result displays in the spreadsheet. You can also use the  Insert  and  Delete  dialog boxes to insert and delete columns and rows. Deleting cells To delete cells: Select one or more cells. To delete cell contents...

Introduction By the end of this lesson, you should be able to: Adjust column width and row height Adjusting column widths By default, Excel's columns are 8.43 characters wide, but each individual column can be enlarged to 240 characters wide. If the data you are entering in your worksheet is wider or narrower than the default column width, you can adjust the width so it is wide enough to contain the data. You can adjust column width  manually  or use  AutoFit . Adjusting column width two ways Manually: Place your mouse pointer to the  right side  of the column header. The mouse pointer changes to  the adjustment tool  (double-headed arrow). Drag  the edge of the column header to the desired width and release the button. AutoFit: Place your mouse pointer to the  right side  of the column header. The mouse pointer changes to  the adjustment tool  (double-headed arrow). Double-click  the col...

Introduction By the end of this lesson, you should be able to: Insert rows and columns Delete rows and columns Inserting columns In Excel, you can insert a column anywhere you need it. Excel moves the existing columns to make room for the new one. To insert a column: Click anywhere in the column where you want to insert a new column. Choose  Insert Columns  from the menu bar. A new column is inserted to the  left  of the existing column. OR Click anywhere in the column where you want to insert a new column. Right-click  and choose Insert from the shortcut menu. The Insert dialog box opens. Click  Entire Column  in the  Insert dialog box. A new column is inserted to the  left  of the existing column. To insert multiple columns: Select  more than one  column. Choose a method (menu or shortcut menu) to insert a new column. The number of columns you  originally selected  are inserted into...

Using functions Important terms: A  function  is a  predefined formula that helps perform common mathematical functions. Each function has a specific order, called  syntax . Syntax must be followed for the function to work correctly. To use syntax order: All functions begin with the equals sign. After the equals sign is the  function name . One or more  arguments  are enclosed in parentheses. If there is more than one argument, they are separated by commas. An example of a function with  one argument : An example of a function with  more than one argument : Excel has hundreds of  functions or predefined formulas  to assist you with your calculations. As you know, building individual formulas can be difficult and time consuming. Using Excel's functions can save you a lot of time and headaches. Excel's different functions There are many functions in  Excel . For our purposes in Excel 2000, we wil...

Formatting numbers By default,  values  are formatted as general numbers. This means Excel doesn't display zeroes that don't affect the actual numeric value of the number. For example, Excel will display 250 but not $250.00 unless you format the number. Values can be formatted as  currency ,  percentages ,  fractions ,  dates , and many other formats. Remember, when you format a number, you're  not  changing the numeric value. You can format selected cells using the  Formatting toolbar , the  Format dialog box , or the  shortcut menu . To format cells using the Formatting toolbar: Select the cell or range you want to format. On the  Formatting  toolbar, click one of the buttons explained in the table below. Your number is now formatted. Click anywhere  outside the cell  to turn off the formatting. Currency Displays and aligns dollar signs, comma separators, and decimal points. Ex: 89.5 as $89.50...

Complex formulas Simple formulas have one mathematical operation. Complex formulas involve more than one mathematical operation. The order of mathematical operations is important. If you enter a formula that contains several operations—like adding, subtracting, and dividing—Excel knows to work those operations in a specific order. The order of operations is: 1. Operations enclosed in parentheses 2. Exponential calculations (to the power of) 3. Multiplication and division, whichever comes first 4. Addition and subtraction, whichever comes first Relative to the order, you will also calculate from left to right. Let's look at an example:  2*(6-4) =? Is the answer 8 or 4? If you calculated in the order in which the numbers appear, ignoring the parentheses, 2*6-4, you'd get the wrong answer, 8. You must follow the order of operations to get the correct answer. To calculate the correct answer: 1. Calculate the operation in parentheses: 6-4=2. 2. Multiply 2*2=4. ...