Microsoft Office Tutorials and References
In Depth Information
Inserting and Deleting Cells in a Worksheet
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 in
cell B2, 5.75% in cell B3,
57.50% in cell B4, 15.00%
in cell B5, 7.50% in cell B6,
3,500,000.00 in cell B7, and
18.75% in cell B8 to display
the entries using formats based
on the format symbols entered
with the numbers (Figure 3 – 17).
Enter
comma and decimal
entered with number
instructs Excel
to format cell to
Comma style with
two decimal places
decimal and percent sign
entered with number
instructs Excel to format
cell to Percent style with
two decimal places
Figure 3 –17
Other Ways
1. Right-click range, click
Format Cells on shortcut
(Format Cells dialog box),
click category in Category
list, [select desired
format], click OK button
(Format Cells dialog box)
2. Press CTRL + 1, click
Number tab (Format Cells
dialog box), click category
in Category list, [select
desired format], click
OK button (Format Cells
dialog box)
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
dei ne the numbers no longer appear on the screen. This makes it difi 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.

Search JabSto ::

Custom Search