ARRANGING WINDOWS
You can arrange open workbooks on the screen in multiple windows so that you can view them. The Arrange option on the Windows menu allows you several different ways of doing this.
PROCEDURE
1. Select the Windows menu from the menu bar
2. Select the Arrange option. The Arrange Windows dialog box with four different options of how windows can be displayed appears.
3. Select any option to see how the windows are arranged under it.
MOVING & RESIZING WINDOWS
Discussion
To move a workbook window,
PROCEDURE
1. Click on the Title bar of the workbook you want to move and drag it.
2. Once you have the workbook window in the desired position release the mouse button
To resize a workbook window use the mouse as follows. The mouse pointer changes shape to a double head arrow when pointed at the window borders indicating that you can click and drag to resize.
PROCEDURE
1. To resize a window click and drag on any of its borders.
2. To resize a window both horizontally and vertically at the same time, click and drag on any corner.
CLOSING WINDOWS
When you have finished working with a workbook you can close it to free memory it uses.
You can close a workbook from the Menu bar.
PROCEDURE
1. Select the File menu
2. Select the Close command
Enter numbers, text, a date, or a time
• Click the cell where you want to enter data.
• Type the data and press ENTER or TAB.
• Use a slash or a hyphen to separate the parts of a date; for example, type 9/5/96 or Jun-96.
• To enter a time based on the 12-hour clock, type a space and then a or p after the time; for example, 9:00 p
Otherwise, Microsoft Excel enters the time as AM.
• To enter today's date, press CTRL+; (semicolon).
• To enter the current time, press CTRL+SHIFT+: (colon).
]Enter a formula
For information about how formulas calculate values, the following are the rules.
1. Click the cell in which you want to enter the formula.
2. Type = (an equal sign).
If you click Edit Formula or Paste Function, Microsoft Excel inserts an equal sign for you.
3. Enter the formula.
4. Press ENTER.
Note:
You can enter the same formula into a range of cells by selecting the range first, typing the formula, and then pressing CTRL+ENTER.
You can also enter a formula into a range of cells by copying a formula from another cell. For more information about copying a formula, the following are the rules.
Enter the same data into several cells at once
• Select the cells where you want to enter data.
• The cells can be adjacent or nonadjacent.
• Type the data and press CTRL+ENTER.
• Enter or edit the same data on multiple worksheets
• When you select a group of sheets, changes you make to a selection on the active sheet are reflected in the corresponding cells on all other selected sheets. Data on the other sheets may be replaced.
• Select the worksheets where you want to enter data.
• How?
• Select the cell or cell ranges where you want to enter data.
• Type or edit the data in the first selected cell.
• Press ENTER or TAB.
Microsoft Excel automatically enters the data on all selected sheets.
Note: If you've already entered data on one worksheet, you can quickly copy the data to the corresponding cells on other sheets. Select the sheet that contains the data and the sheets to which you want to copy the data. Then select the cells that contain the data you want to copy. On the Edit menu, point to Fill, and then click Across Worksheets.
Select sheets in a workbook
If you select more than one sheet, Microsoft Excel repeats the changes you make to the active sheet on all other selected sheets. These changes may replace data on other sheets.
To select Do this
A single sheet Click the sheet tab.
Two or more adjacent
Sheets Click the tab for the first sheet, and then hold down SHIFT and click the tab for the last sheet.
Two or more
Nonadjacent sheets Click the tab for the first sheet, and then hold down CTRL and click the tabs for the other sheets.
• All sheets in a workbook
• Right-click a sheet tab, and then click Select All Sheets on the shortcut menu.
Quickly fill in repeated entries in a column
If the first few character you type in a cell match an existing entry in that column, Microsoft Excel fills in the remaining characters for you. Microsoft Excel completes only those entries that contain text or a combination of text and numbers; entries that contain only numbers, dates, or times are not completed.
To accept the proposed entry, Press ENTER.
The completed entry exactly matches the pattern of uppercase and lowercase letters of the existing entries.