What-If Analysis, Charting, And Working With Large Worksheets Page 58
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 194
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
To Reorder the Sheet Tabs
Change the order sheets in a workbook so that they appear with the most important worksheets fi rst. The
following steps reorder the sheets so that the worksheet precedes the chart sheet in the workbook.
1
•
Drag the Six-Month
Financial Projection
tab to the left in front
of the 3-D Pie Chart
tab to rearrange the
sequence of the sheets
(Figure 3 – 73).
Six-Month Financial
Projection tab
moved to left of
3-D Pie Chart tab
Figure 3 – 73
Other Ways
1. To move sheet, right-
click sheet tab, click
Move or Copy on
shortcut menu
To Check Spelling in Multiple Sheets
By default, the spell checker checks the spelling only in the selected sheets. It will
check all the cells in the selected sheets, unless you select a range of two or more cells.
Before checking the spelling, the following steps select both sheets in the workbook so
that both worksheets in the workbook are checked for spelling errors.
1
+
With the Six-Month Financial Projection sheet active, press
to select cell A1.
Checking Spelling
CTRL
HOME
Unless you fi rst select a
Hold down the
key and then click the 3-D Pie Chart tab to select multiple sheets.
CTRL
range of cells or an object
2
Display the Review tab and then click the Spelling button (Review tab | Proofi ng group)
before starting the spell
checker, Excel checks the
to check spelling in the selected sheets.
entire selected worksheet,
3
Correct any errors and then click the OK button (Spelling dialog box or Microsoft Excel
including all cell values,
cell comments, embedded
dialog box) when the spell check is complete.
charts, text boxes, buttons,
4
Save the workbook.
and headers and footers.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education