What-If Analysis, Charting, And Working With Large Worksheets Page 21
ADVERTISEMENT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87What-If Analysis, Charting, and Working with Large Worksheets
Excel Chapter 3
EX 157
Table 3 – 5 Numbers Entered with Format Symbols
Format Symbol
Typed in Formula Bar
Displays in Cell
Comparable Format
.
374, 149
374, 149
Comma(0)
5,833.6
5,833.60
Comma(2)
$
$58917
$58,917
Currency(0)
$842.51
$842.51
Currency(2)
$63,574.9
$63,574.90
Currency(2)
%
85%
85%
Percent(0)
12.80%
12.80%
Percent(2)
68.4222%
68.2242%
Percent(4)
The following step enters the numbers in the What-If Assumptions table with format symbols.
1
200,000.00
•
Enter
in
5.75%
cell B2,
in cell B3,
57.50%
15.00%
in cell B4,
7.50%
in cell B5,
in cell B6,
3,500,000.00
in cell B7, and
18.75%
in cell B8 to display
the entries using formats based
comma and decimal
entered with number
decimal and percent sign
on the format symbols entered
instructs Excel
entered with number
to format cell to
instructs Excel to format
with the numbers (Figure 3– 17).
Comma style with
cell to Percent style with
two decimal places
two decimal places
Figure 3 –17
Other Ways
1. Right-click range, click
list, [select desired
dialog box), click category
Format Cells on shortcut
format], click OK button
in Category list, [select
menu, click Number tab
(Format Cells dialog box)
desired format], click
(Format Cells dialog box),
OK button (Format Cells
+
2. Press
1, click
CTRL
click category in Category
dialog box)
Number tab (Format Cells
To Freeze Column and Row Titles
Freezing worksheet titles is a useful technique for viewing large worksheets that extend beyond the window.
Normally, when you scroll down or to the right, the column titles in row 12 and the row titles in column A that
defi ne the numbers no longer appear on the screen. This makes it diffi cult to remember what the numbers in these
rows and columns represent. To alleviate this problem, Excel allows you to freeze the titles, so that Excel displays
the titles on the screen, no matter how far down or to the right you scroll.
The steps on the following page use the Freeze Panes button (View tab | Window group) to freeze the work-
sheet title and column titles in rows 10, 11, and 12, and the row titles in column A.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education