What-If Analysis, Charting, And Working With Large Worksheets Page 62
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
87EX 198
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
3
•
Click the Zoom
In button on the
status bar until
the worksheet is
displayed at 100%
(Figure 3 – 77).
worksheet
Zoom In
displays at
button
100%
Figure 3 –77
To Split a Window into Panes
When working with a large worksheet, you can split the window into two or four panes to view different parts
of the worksheet at the same time. Splitting the Excel window into four panes at cell D13 allows you to view all four
corners of the worksheet easily. The following steps split the Excel window into four panes.
1
View tab
•
Select cell D13, the
intersection of the
four proposed panes,
to select the cell at
which to split the
window.
•
If necessary, display
the View tab
(Figure 3 – 78).
panes will be
divided above
and to the left
of active cell
Figure 3 –78
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education