Microsoft Office Tutorials and References
In Depth Information
Freezing Worksheet Titles EX 181
To Enter Numbers with Format Symbols
The following step enters the numbers in the What-If Assumptions table with format symbols.
1
Enter 100,000.00 in
cell B19, 3.25% in cell B20,
61.00% in cell B21, 9.00%
in cell B22, 5.75% in
cell B23, 4,750,000.00
in cell B24, and 17.00% in
cell B25 to display the
entries using a format
based on the format
symbols entered with the
numbers (Figure 3–17).
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
menu, click Number tab,
click category in Category
list, [select desired format],
click OK button
2. Press CTRL+1, click Number
tab, click category in
Category list, [select desired
format], click OK button
Freezing Worksheet 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 3 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.
Freezing Titles
If you want to freeze only
column headings, select
the appropriate cell in
column A before you
click the Freeze Panes
button on the View tab
on the Ribbon. If you
only want to freeze
row titles, then select
the appropriate cell in
row 1. To freeze both
column headings and
row titles, select the cell
that is the intersection
of the column and row
titles before you click
the Freeze Panes button
on the View tab on the
Ribbon.
 
Search JabSto ::




Custom Search