ERASING/DELETING CELL CONTENTS
To erase the entry made in a cell, activate it and press Delete.
You can also delete cell contents in the following way.
PROCEDURE
1. Select the required cell.
2. Select the Edit, Clear, content menu option.
3. Select Delete.
REPLACING CELL CONTENTS
To replace the contents of a cell with something else just activate the cell and make your new entry. It replaces the previous entry. Formatting however, is not removed.
UNDO AND REPEAT
If you make an error during or after an entry and wish to change your entry you can use the Undo feature to reverse it before proceeding.
PROCEDURE
1. To reverse your last action Select the Edit menu
2. Select the Undo command.
On the other hand if you would like to repeat the last action you performed, you can use the Edit, Repeat command.
PROCEDURE
1. Select the Edit menu
2. Select the Repeat option.
3. Select F4 or Click on the Redo button on the Standard toolbar
USING AUTOFILL
SAVING A WORKBOOK
To keep your workbook on disk for future use, you must save it by giving it a unique file name.
SAVE AND SAVE AS
PROCEDURE
Select the File, Save menu option.
Press Ctrl+S, or click on the Save button on the Standard toolbar.
Excel will display the Save As dialogue box.
Enter the workbook file name into the File name text box.
You can set other options like the drive, the folder to save to the right location.
Once all save options have been selected, click OK.
If the directory you require is not currently selected, move to the correct directory (folder) by double clicking on the directory name shown in the Directories list box.
If the directory you are looking for is not in the list, double click on the root directory c:\ to move to the top of the directory tree. Then scroll through and double click on the required directory name(s).
• Enter a password into the Protection Password text box if you would like to prevent anyone from opening the worksheet unless they know this password.
• Enter a password into the Write Reservation Password text box if you would like to prevent anyone from saving changes to the worksheet unless they know this password.
WORKING WITH WORKBOOKS
OPENING EXISTING WORKBOOKS
To perform any operation on an existing workbook i.e. one that has been previously saved to disk you must first open it.
• You can open an existing workbook by clicking on the Open button on the Standard toolbar
PROCEDURE
1. Select the File menu.
2. Select the Open command. This opens the Open dialog box
3. Select the file you want to open.
4. Click OK.
The open dialog box gives you many options most of which deal with the location of files.
You can also open your most recently used workbooks by selecting the file names displayed at the bottom of the File menu.
USING WORKBOOKS
MULTIPLE WORKBOOKS/ WINDOWS
Excel allows you to have multiple workbooks open at the same time. This is useful if you want to work with or view data in several workbooks simultaneously.
Excel also allows you to open more than one copy of a workbook at the same time. This is useful when you want to simultaneously view different sets of data residing in one workbook
If you have multiple workbooks or more than one copy of a workbook open each workbook or copy of a workbook resides in an Excel window.
As with other Windows applications, Excel windows can appear on the screen in the following ways:
Maximized - only one workbook is displayed at a time.
Minimized - a small window displaying on the title bar appears
restored to a non maximized size
To practice navigating workbooks, first create some empty workbooks after starting Excel.
PROCEDURE
1. Click once on the New button to create Book 1
2. Click twice more on the New button to create Book 2 and Book 3.
THE ACTIVE WORKBOOK
When you wish to work with any open workbook you must select it first and make it the Active Workbook. You can do this by selecting the desired workbook from the Window menu, which lists the names of all open workbooks at the bottom.
PROCEDURE
1. Select the Window menu
2. Click on the name of Book 1, Book 2 or Book 3 to make it the active workbook.
If more than one workbook is visible on the screen clicking anywhere in the desired workbook will make it the active workbook.
This procedure is used to move between windows of a workbook.