| Fill |
► |
 This option provides 7 sub-menu options
(Shown left), all
work from the position of your current
selection. You may also want to use the 'fill
handle', which is the small square in the
bottom right of a selected cell or range of
cells.
 Tip:
If you hold down the ctrl key while dragging the
fill handle Excel will automatically switch to
the opposite fill mode, for example, type 12345
in a cell and drag the fill handle down is the
same as Fill>Down, it simply fills the cells
with 12345. Now do the same but hold the
Ctrl key down. You should notice that the cursor
has a small '+' by it and now Excel increments
the number by one, 12345, 12346, etc. This is
the same as Fill>Series, with the default
setting of '1'. If you then give Excel some
clues, for example type a date for a Monday,
then the date for the Monday of next week below and
select both
-
Down - Takes the data or formula in the
top-most selected cell and copies it down to
the bottom of you selected range of cells.
For example, if you have a selection of
A1:A10 with a formula =B1 in cell A1, then
Edit>Fill>Down will 'copy' all the formulas
down to A10, with A10, as we have used a
'relative' formula, having a formula of =B10
in it. The 'direction' settings can also be
used to copy constants as well as formula.a.
-
Right - Acts identically to 'down'
except to the right across a worksheet.
-
Up - As 'down' but in an upward
direction
-
Left - As 'right' but across a worksheet
from the right to left.
-
Across Worksheets... Operates with
'grouped' sheets. (To do this highlight any
sheet tab while holding down either the
shift key, (contiguous sheets) or the ctrl
key (non-contiguous sheets)), allows you to
fill 'values', 'formats' or 'all' across
selected sheets. (If you group all sheets,
just right-click on any tab to select
un-group)
-
Series... Allows you to specify an
incrementing value or trend from the
resultant dialogue (above). For example you could
type a 1 in a cell and highlight it, select
this menu option and select a step value of
5 and a stop value of 100 and click on
'columns' this will place 20 cells below the
1, incrementing by 5 each time with a 'stop
value' of 96 (4 less than 100, but another 5
would take it over!)
-
Justify Takes the selection and attempts
to place it in one cell until the cell is
'full' without expanding the column width.
If you expand the column width and run this
again, more of the data will be placed into
the one cell at top left.
|
