Maharishi University of Management

Editing

Editing Formulas

You can change, move, and copy formulas.

• To change a formula, either double-click it to edit it in the cell or click it once to edit it in the formula bar.
• To move a formula, click the cell. Then point to it and click and drag it to the new location.
• To copy a formula to an adjacent cell or cells, click the cell. Then point to the fill handle at the bottom right corner of the cell and click and drag to the nexts cell or cells.
• To copy a formula to other cells that are not adjacent, click the cell and choose Copy on the Standard toolbar. Select the cell or cells where you want to place the formula and choose Paste on the Standard toolbar.

Moving and Copying Text by Dragging

Move and copy text by dragging when you can see by the start and goal locations at one time on the screen.

1. Select the text.
2. Place the mouse cursor over the selected text.
3. Press and hold down the left mouse button as you move the mouse to the desired cell. This is called dragging.
4. Release the mouse when the cell where you want the text to appear is active (has a border around it). Excel moves the text.

To copy the text, following the same procedure except press the Ctrl key (PC)/Option key (Mac) as you drag.

Filling in a Series of Numbers

Excel can quickly create a series of numbers for you, for example 1 to 10 or January to December. It can even extend "1st qtr" through "4th qtr". Follow these steps:

1. Type the first number or expression in the series and press Enter/Return.
2. Click the cell you just completed.
3. Point to the cell's fill handle (the bottom right corner of the cell).
4. Click and drag in the direction you want to create the series (either horizontally along a row or vertically along a column).

Finding Text

To find text, follow these steps:

1. Choose Edit > Find.
2. Type the text you wish to find in the Find What text box.
3. Check Find Whole Words Only if, for example, if you are looking for the word and, but don't want to find sand,. To find HELP but not help, check Match Case.
4. You can choose to search by columns or rows.
5. You can choose to search formulas (the default), values (the results of the formulas only), or comments.
6. Click Find Next. Excel highlights the first match.
7. Continue to click Find Next to find the next time the word appears until you find what you want.
8. Click Close when you're done.

Replacing Text

To find and replace text, follow these steps:

1. Choose Edit > Replace.
2. In the Find What text box, type the text you wish to find and replace.
3. In the Replace With text box , type the text you want to replace the found text with.
4. Check Find Whole Words Only if, for example, if you are looking for the word and, but don't want to find sand. To find HELP but not help, check Match Case.
5. You can choose to search by columns or by rows.
6. Click Find Next. Excel highlights the first match.
7. Click Replace to replace the highlighted text. Click Replace All to replace every occurence of the text.
8. Click Close when you're done.

Undoing and Redoing Actions

To undo an action, click Undo on the Standard toolbar. To undo more than one action at a time, click the down arrow to the right of the Undo button and choose the earliest of the actions that you want to undo. To redo an action that you undid, click Redo.

Using AutoCorrect to Correct Mistakes

Excel automatically corrects hundreds of common typing, spelling, and grammar errors. You can add your own entries to automatically correct words you often mispell.

1. Choose Tools > AutoCorrect.
2. In the Replace text box, type the way you usually mispell the word.
3. In the With text box, type the correct spelling.
4. Click Add
5. Click OK

Tip: You can use AutoCorrect to speed up typing long phrases and difficult words. Let's say you want a shortcut for typing Maharishi University of Management. In the AutoCorrect dialog box, type m.u.m. in the Replace text box and type Maharishi University of Management in the With text box. Click Add, then OK. Just be careful not to use a shortcut that you might use for another purpose.

Locking Cells and Protecting a Worksheet

You can protect cells from being changed. For example, if you have created a worksheet to be used for data entry, you can protect all the cells that contain formulas, so that others who enter data don't change them. To stop cells from being changed, the cells must be locked, then the worksheet must be protected.

1. By default, cells are locked. However, if you want to stop a cell from being changed and it has been unlocked, you need to lock it. Select the cell (or cells) and choose Format > Cells. On the Protection tab, check Locked and click OK.
2. If you want certain cells to be editable, you need to unlock them. Select these cells, choose Format > Cells and on the Protection tab, uncheck Locked. Click OK.
3. Choose Tools > Protection > Protect Sheet. In the Protect Sheet dialog box, you can choose to protect contents (of cells, including chart sheets), objects (graphics, formatting, comments), and scenarios ("what if" alternatives that you have created using Excel's scenarios feature). Uncheck any of these three options if you don't want to protect them. To protect cells from being changed, keep the Contents option checked.
4. If you want to require a password to unprotect the worksheet, add it in the Password text box. Don't forget the password! Passwords are case-sensitive -- to use it you must type it exactly as it was entered.
5. Retype the password when prompted.
6. Click OK.

Once the worksheet is protected, users can tab from unlocked cell to unlocked cell to quickly enter data.

To unprotect a worksheet, choose Tools > Protection > Unprotect Workbook (to unprotect the entire workbook) or Tools > Protection > Unprotect Sheet (to unprotect just the active sheet). If you added a password, you are prompted for it.

To change a password, open the workbook, choose File > Save As and click Options. In the dialog box that opens, double-click the symbols that represent the password and type the new password. Click OK. (To delete the password, press Delete and click OK.) If you changed the password, retype the new password and click OK. Click Save. Confirm. You can use this method to require different passwords to open and to modify a workbook.