You can use the Alignment tabbed page on the Format Cells dialog box to change the alignment of the data in a cell.
To verify the alignment, you must check the fields on the Alignment tabbed page on the Format Cells dialog box.
Centering Text Across Cells
Most worksheets have a title. You can format your title so that it is centred at the top of your worksheet data.
You can use one of two methods to merge cells and center data in a cell. You may use the Center Across Selection Option or the Merge Cells and Center Alignment options. You can also use these options to ensure that lengthy data fits in a cell, thereby displaying properly.
Before you center the title across your data, you must determine the number of columns your worksheet data spans. Next, select the cells that you want to merge. Finally, choose the Center option in the Horizontal combo box and check the Merge Cells check box.
Removing Cell Formatting
Formatting is associated with a cell. If you want to remove the attributes you added to a cell, use the Clear Formats command. When you remove the formatting, Excel uses the general attributes as defined by the template.
The Formats command appears on the Clear sub-menu. Choose the Clear command on the Edit menu to open the Clear sub-menu.
Inserting Rows, Columns, and Cells
You can use the Cells, Rows, or Columns command on the Insert menu to insert a blank row, column, or cell.
When you insert a new cell, row, or column, Excel shifts the cells in the worksheet to accommodate the new cells.
Excel also updates all formulas so that the cell references are accurate, including absolute cell references.
Deleting Rows, Columns, and Cells
You can use the Delete command on the Edit menu to remove a selected cell, a row, or column.
Excel automatically updates formulas to reflect their new locations. However, a formula that refers to a deleted cell displays an error.
Exercise 9.
Open the Format.xls file and try to find out the layout of the information which are in the workbook. Then modify data according to the following instructions.
a) Change the format for cell A1 using the Font tabbed page on the Format Cell format dialog box. Change the font to Century Gothic, font style to regular, font size to twelve, add single underlining. Finally verify the format using the Format Cells dialog box.
b) Change the format of cells A6, ..., A8 to bold and the format of cells B5, ..., E5 to underlined. Finally verify the format using the Format Cells dialog box.
c) Format the word "Corporate" in the cell A3 to italic.
d) Apply the Currency style Dollar with two decimal places to a range of cells B7 through F9 and B12 through F14.
e) Apply the Percentage style with zero decimal places to cell B16.
f) Adjust the width of the column A according the width of cell A18.
g) Set cells B5 through F5 to center alignment.
h) Use the Merge Cells for cells A1 through F1 and then center the worksheet title in cell A1. Verify that the title appears centred over the cells in column A through F.
i) Remove the formatting changes you made to cells B5 through F5.
j) Insert a blank row at row 18 and shift the cells in row 18 down to row 19. Insert a blank cell at A19 and shift the remaining cells in row 19 to the right.
k) Delete row 2 from the worksheet.
A
B
C
D
E
F
1
Pampered Piggies Pedicure Products
2
3
1997 Budget Report - Corporate
4
5
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Year
6
Revenue
7
Sales
46000
49680
53654,4
57946,752
207281,152
8
Service
55000
59400
64152
69284,16
247836,16
9
Total
101000
109080
117806,4
127230,912
455117,312
10
11
Expenses
12
Wages
62000
63240
64504,8
65794,896
255539,696
13
Supplies
22500
22950
23409
23877,18
92736,18
14
Total
84500
86190
87913,8
89672,076
348275,876
15
16
Tax Rate
0,17
17
Taxes Due
$2 805,00
$3 891,30
$5 081,74
$6 385,00
$18 163,04
18
Date Completed
Table 3.5: Format.xls workbook.
Managing Workbooks
Switching among Multiple Open Workbooks
You can have several workbooks open at the same time. You can switch among open workbooks using the Window menu or the keyboard shortcut Ctrl-F6.
Exercise 10.
Open the workbooks BUDGET98.XLS, COMPANY.XLS, and EXPENSES.XLS all at once and try to switch among them using the Window menu and using the keyboard shortcuts.
Switching among Multiple Open Worksheets
A workbook may contain up to 256 worksheets. New workbooks only have three worksheets, however.
You can switch among the worksheets by pressing Ctrl-Page Down to move to the next worksheet or press Ctrl-Page Up to return to the previous worksheet. JFW reads the worksheet name when you switch to a new worksheet.
Exercise 11.
Open the YEAR98.XLS workbook and switch among the worksheets it contains.
Renaming a Worksheet
You can use the Rename command to assign a name to a worksheet. The Rename Sheet command appears on the Sheet sub-menu. Choose the Sheet command on the Format menu to open the Sheet sub-menu.
Worksheet names can be up to thirty-two characters, and you may use any character on the alpha-numeric keyboard.
Exercise 12.
Assign names to the three worksheets in the YEAR98.XLS workbook: Sheet1 - Representative Sales, Sheet2 - Product Sales, Sheet3 - Store Sales.
Inserting a Worksheet
You can insert a new worksheet into your workbook using Worksheet command on the Insert menu. Excel inserts the worksheet before the active worksheet. Excel assigns all new worksheets the name "Sheet" followed by a number.
Exercise 13.
Insert a new worksheet between the second and third worksheets in the YEAR98.XLS workbook.
Moving a Worksheet
You can use the Move or Copy Sheet command on the Edit menu to rearrange the order of your worksheets. Excel will move the active worksheet to the position you choose in the Move or Copy dialog box. You can also use the Move or Copy Sheet command to move a worksheet to another workbook.
Exercise 14.
Move the Representative Sales worksheet to the end of the YEAR98.XLS workbook.
Deleting a Worksheet
You can use the Delete Sheet command on the Edit menu to remove worksheets you no longer need. When you activate the Delete Sheet command, all of the data on the worksheet is deleted as well. Be sure you want to remove the data and that other worksheets in the workbook are not using the data on the worksheet you want to delete.
Exercise 15.
Delete Sheet1 from the YEAR98.XLS workbook.
Preparing A Workbook For Printing
Determining Page Breaks