Microsoft Office Tutorials and References
In Depth Information
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
• Release the mouse button to
change the width of columns B
• 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.
• Click cell A19 to ﬁ 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.
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
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 ﬁ rst two chapters
used the ﬁ 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 ﬁ 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 Ofﬁ ce
Clipboard , a reserved place in the computer’s memory that allows you to collect text and
graphic items from an Ofﬁ ce document and then paste them into any Ofﬁ 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 Ofﬁ 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 ﬁ t the current width
of the column. To shrink
to ﬁ t, click Format Cells:
Alignment Dialog Box
Button Launcher on the
Ribbon, and click Shrink to
ﬁ t in the Text control area.
After shrinking entries to
ﬁ t in a cell, consider using
the Zoom slider on the
status bar to make the
entries more readable.