Microsoft Office Tutorials and References
In Depth Information
Rotating Text and Using the Fill Handle to Create a Series
Table 3 – 2 Options Available on the Auto Fill Options Menu
Auto Fill Option
Description
Copy Cells
Fill destination area with contents using format of source area. Do not create a series.
Fill Series
Fill destination area with series using format of source area. This option is the default.
Fill Formatting Only
Fill destination area using format of source area. No content is copied unless fill is series.
Fill Without Formatting
Fill destination area with contents, without the formatting of source area.
Fill Months
Fill destination area with series of months using format of source area. Same as Fill Series and shows
as an option only if source area contains the name of a month.
Yo u c a n c r e a t e s e v e r a l d i f f e r e n t t y p e s o f s e r i e s u s i n g t h e l l h a n d l e . Ta b l e 3 – 3
illustrates several examples. Notice in examples 4 through 7, 9, and 11 that, if you use the
fill handle to create a series of numbers or nonsequential months, you must enter the rst
item in the series in one cell and the second item in the series in an adjacent cell. Excel still
creates the series, however, if the rst two items are in a range and the cells between the
items are empty. Next, select both cells and drag the fill handle through the destination area.
BTW
Custom Fill
Sequences
You can create your own
custom fill sequences for
use with the fill handle. For
example, if you often type
the same list of products
or names in Excel, you
can create a custom fill
sequence. You then can
type the rst product or
name and then use the fill
handle automatically to fill
in the remaining products or
names. To create a custom
fill sequence, display the
Excel Options dialog box by
tapping or clicking Options
in the Backstage view. Tap or
click the Advanced tab (Excel
Options dialog box) and then
tap or click the ‘Edit Custom
Lists’ button (Excel Options
dialog box).
Table 3 – 3 Examples of Series Using the Fill Handle
Contents of Cell(s) Copied
Using the Fill Handle
Example
Next Three Values of Extended Series
1
4:00
5:00, 6:00, 7:00
2
Qtr2
Qtr3, Qtr4, Qtr1
3
Quarter 1
Quarter 2, Quarter 3, Quarter 4
4
22-Jul, 22-Sep
22-Nov, 22-Jan, 22-Mar
5
2012, 2013
2014, 2015, 2016
6
1, 2
3, 4, 5
7
625, 600
575, 550, 525
8
Mon
Tue, Wed, Thu
9
Sunday, Tuesday
Thursday, Saturday, Monday
10
4th Section
5th Section, 6th Section, 7th Section
11
2205, 2208
2211, 2214, 2217
1 ENTER HEADINGS & DATA | 2 ENTER FORMULAS & FUNCTIONS | 3 CREATE SPARKLINE CHARTS
4 FORMAT WORKSHEET | 5 CREATE COLUMN CHART | 6 CHANGE VIEWS | 7 ASK WHAT - IF QUESTIONS
To Increase Column Widths
Why? In Chapter 2, you increased column widths after the values were entered into the worksheet. Sometimes, you
may want to increase the column widths before you enter the values and, if necessary, adjust them later . The following
steps increase the column widths.
1
Move the pointer to the boundary
between column heading A and
column heading B so that the
pointer changes to a split double
arrow in preparation of adjusting
the column widths.
Drag the pointer to the right until
the ScreenTip displays the desired
column width, Width: 38.00 (309
pixels) in this case. Do not lift
your nger or release the mouse
button (Figure 3 – 9).
split double
arrow pointer
proposed width
of column A
Figure 3 – 9
 
Search JabSto ::




Custom Search