Auto fill

  • Thread starter Thread starter mackem
  • Start date Start date
M

mackem

I'm running excel in office 2003pro
I have a problem which happens occasionally and cannot find an answer.
Let's say I have a simple spreadsheet with ten columns of data. Column A is
the date which is incremented daily in rows down the page. In column B, I
manually input a number each day.
The next eight columns C to J each have a different formula which is
dependent on the data entered in column B.
Normally when I enter the daily number in column B the numbers in the next
eight columns will fill in automatically.
However in some spreadsheets this does not happen and perhaps one number in
one column will not fill in automatically. I then have to manually drag the
formula down from the cell above.
Is there a solution to this?
tia
 
Hi ..... mackem...,
I think you are depending on Tools, Options, Edit (tab)
Extend List Formats and Formulas

if you click on the [?] from the upper right corner and then
click on the option you will see an explanation.
In fact that help is better than in the main Excel Help.

Select to automatically format new items added to
the end of a list to match the fomat of the rest of the
list. Formulas that are repeated in every row are also
copied. To be extended, formats and formulas must
appear in at least threee of the ive last rows
preceding the new row.

I use this option, but I also use macros described on
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
My stuff doesn't usually fit the extend formats and formulas
becase if some cells are blank like in a bank balance where
you put a value into either the Debit or Credit column it
looks different to Excel.
 
Thanks David,
That option is already ticked, so I still have the problem.
Thanks for the macro info too but that's a little beyond my current
expertise.
Best wishes.

David McRitchie said:
Hi ..... mackem...,
I think you are depending on Tools, Options, Edit (tab)
Extend List Formats and Formulas

if you click on the [?] from the upper right corner and then
click on the option you will see an explanation.
In fact that help is better than in the main Excel Help.

Select to automatically format new items added to
the end of a list to match the fomat of the rest of the
list. Formulas that are repeated in every row are also
copied. To be extended, formats and formulas must
appear in at least threee of the ive last rows
preceding the new row.

I use this option, but I also use macros described on
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
My stuff doesn't usually fit the extend formats and formulas
becase if some cells are blank like in a bank balance where
you put a value into either the Debit or Credit column it
looks different to Excel.


mackem said:
I'm running excel in office 2003pro
I have a problem which happens occasionally and cannot find an answer.
Let's say I have a simple spreadsheet with ten columns of data. Column A
is
the date which is incremented daily in rows down the page. In column B, I
manually input a number each day.
The next eight columns C to J each have a different formula which is
dependent on the data entered in column B.
Normally when I enter the daily number in column B the numbers in the
next
eight columns will fill in automatically.
However in some spreadsheets this does not happen and perhaps one number
in
one column will not fill in automatically. I then have to manually drag
the
formula down from the cell above.
Is there a solution to this?
tia
Click to expand...
Click to expand...
 
I had little doubt that the option was on, reread the
help for that item, it is very restrictive. I corrected a couple
of words from the posting


mackem said:
Thanks David,
That option is already ticked, so I still have the problem.
Thanks for the macro info too but that's a little beyond my current
expertise.
Best wishes.

David McRitchie said:
Hi ..... mackem...,
I think you are depending on Tools, Options, Edit (tab)
Extend List Formats and Formulas

if you click on the [?] from the upper right corner and then
click on the option you will see an explanation.
In fact that help is better than in the main Excel Help.

Select to automatically format new items added to
the end of a list to match the fomat of the rest of the
list. Formulas that are repeated in every row are also
copied. To be extended, formats and formulas must
appear in at least three of the five last rows
preceding the new row.

I use this option, but I also use macros described on
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
My stuff doesn't usually fit the extend formats and formulas
becase if some cells are blank like in a bank balance where
you put a value into either the Debit or Credit column it
looks different to Excel.


mackem said:
I'm running excel in office 2003pro
I have a problem which happens occasionally and cannot find an answer.
Let's say I have a simple spreadsheet with ten columns of data. Column A
is
the date which is incremented daily in rows down the page. In column B, I
manually input a number each day.
The next eight columns C to J each have a different formula which is
dependent on the data entered in column B.
Normally when I enter the daily number in column B the numbers in the
next
eight columns will fill in automatically.
However in some spreadsheets this does not happen and perhaps one number
in
one column will not fill in automatically. I then have to manually drag
the
formula down from the cell above.
Is there a solution to this?
tia
Click to expand...
Click to expand...
Click to expand...
 
Back
Top