Microsoft Office Tutorials and References
In Depth Information
EX 174
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
Release the mouse button to
change the width of columns B
through G.
Increase Indent
Decrease Indent
Use the technique described in
Step 1 to increase the width of
column H to 15.00.
Enter the row titles in the range
A4:A18 as shown in Figure 3–11,
but without the indents.
Click cell A5 and then click the
Increase Indent button on the
Select the range A9:A13 and
then click the Increase Indent
button on the Ribbon.
row titles
Click cell A19 to fi nish entering
the row titles (Figure 3–11).
What happens when I click the
Increase Indent button?
The Increase Indent button indents
the contents of a cell to the right by
three spaces each time you click it.
The Decrease Indent button
decreases the indent by three
spaces each time you click it.
row titles
Figure 3–11
Other Ways
1. To indent, right-click
range, click Format
Cells on shortcut menu,
click Alignment tab,
click Left (Indent) in
Horizontal list, type
number of spaces to
indent in Indent text
box, click OK button
Copying a Range of Cells to a Nonadjacent
Destination Area
As shown in the sketch of the worksheet (Figure 3–3a on page EX 166), the row titles in the
Expenses area are the same as the row titles in the What-If Assumptions table, with the exception
of the two additional entries in cells A21 (Margin) and A24 (Revenue for Bonus). Hence, the
What-If Assumptions table row titles can be created by copying the range A9:A13 to the range
A19:A23 and then inserting two rows for the additional entries in cells A21 and A24. The source
area (range A9:A13) is not adjacent to the destination area (range A19:A23). The fi rst two chapters
used the fi ll handle to copy a source area to an adjacent destination area. To copy a source area to
a nonadjacent destination area, however, you cannot use the fi ll handle.
A more versatile method of copying a source area is to use the Copy button and
Paste button on the Home tab on the Ribbon. You can use these two buttons to copy a
source area to an adjacent or nonadjacent destination area.
The Copy button copies the contents and format of the source area to the Offi ce
Clipboard , a reserved place in the computer’s memory that allows you to collect text and
graphic items from an Offi ce document and then paste them into any Offi ce document.
The Copy command on the Edit menu or shortcut menu works the same as the Copy button.
The Paste button copies the item from the Offi ce Clipboard to the destination area.
Fitting Entries in a Cell
An alternative to
increasing the column
widths or row heights is to
shrink the characters in the
cell to fi t the current width
of the column. To shrink
to fi t, click Format Cells:
Alignment Dialog Box
Button Launcher on the
Ribbon, and click Shrink to
fi t in the Text control area.
After shrinking entries to
fi t in a cell, consider using
the Zoom slider on the
status bar to make the
entries more readable.
Search JabSto ::

Custom Search