Undesired Auto Color Fill of Cells

[Railroader]

I am not new to Excel. However, this is a new computer
running MS Small Business Edition with what I suppose is
Excel 2003.

In loading data in columns I find that once I choose a
fill color near the top of the column, no matter what
data in put in the cells as I go down the column, this
previously chosen color will fill in the background as
soon as I hit enter.

This is happening on all my Excel spreadsheets so I
figure there is a "switch" somewhere I can turn off.
However, no handbook on Excel mentions this problem.
Anyone got any ideas?

 

[David McRitchie]

If by going down the column you mean using the fill handle
and copying down -- both the formulas and formats are copied.

 

[Debra Dalgleish]

In Excel 2003 the option is 'Extend data range formats and formulas'
(Tools>Options, Edit tab)

However, Help refers to it as the 'Extend list formats and formulas
check box'.

 

[Guest]

Thanks David. What I am referring to is when I input new
data in the column. The new data may be three or four
rows down from the cell where the fill color was
initially used. As I type in the new data (again, some
distance away in the column) the background color
automatically fills in. I don't know how to shut this
off.

Any ideas will be appreciated. It doesn't keep me from
using Excel, but it sure is annoying.

Railroader.

-----Original Message-----
If by going down the column you mean using the fill handle
and copying down -- both the formulas and formats are copied.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Railroader" <[email protected]> wrote

in message news:[email protected]...

 

[David McRitchie]

Did you note Debra's reply.

Leaves me at a loss since you say it is all worksheets, but
check the following anyway who knows, could be template.
1) right click on sheet tab, view code, is there more than
one line present. -- Worksheet Event macros
2) with the colored cell selected, format, Conditional Formatting
do you seen anything there like the background color of the cell.
3) Right click on the logo to the left of the menu and choose
"thisworkbook" is there any code there -- workbook Event macros.

I don't have Excel 2003, but you also have not acknowledge Debra's
reply about
Tools, Options, Extend Formulas and Formats,
did you try turning if off. I have it on in my Excel 2000, no such
problems at least not if I understand your problem.

Another possibility since I believe some change were made in
2003 to AutoCorrect.




--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Thanks David. What I am referring to is when I input new
data in the column. The new data may be three or four
rows down from the cell where the fill color was
initially used. As I type in the new data (again, some
distance away in the column) the background color
automatically fills in. I don't know how to shut this
off.

Any ideas will be appreciated. It doesn't keep me from
using Excel, but it sure is annoying.

Railroader.

-----Original Message-----
If by going down the column you mean using the fill handle
and copying down -- both the formulas and formats are copied.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Railroader" <[email protected]> wrote

in message news:[email protected]...

.

 

[Guest]

Thanks Debra. That may have solved the problem. I
unclicked that box and all is well -- so far.

Again, thanks.

Railroader

 

[Guest]

Thanks David. I saw Debra's reply and have tried it. So
far it seems to have solved the problem. What is really
strange is that the spreadsheet seemed to like the 25%
gray color best of all. It would fill it in whenever and
that was annoying.

I have used Excel 98 for years without any problems.
Something about Excel 2003 that is new I suppose. Again,
thanks.

Railroader

-----Original Message-----
Did you note Debra's reply.

Leaves me at a loss since you say it is all worksheets, but
check the following anyway who knows, could be template.
1) right click on sheet tab, view code, is there more than
one line present. -- Worksheet Event macros
2) with the colored cell selected, format, Conditional Formatting
do you seen anything there like the background color of the cell.
3) Right click on the logo to the left of the menu and choose
"thisworkbook" is there any code there -- workbook Event macros.

I don't have Excel 2003, but you also have not acknowledge Debra's
reply about
Tools, Options, Extend Formulas and Formats,
did you try turning if off. I have it on in my Excel 2000, no such
problems at least not if I understand your problem.

Another possibility since I believe some change were made in
2003 to AutoCorrect.




--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Thanks David. What I am referring to is when I input new
data in the column. The new data may be three or four
rows down from the cell where the fill color was
initially used. As I type in the new data (again, some
distance away in the column) the background color
automatically fills in. I don't know how to shut this
off.

Any ideas will be appreciated. It doesn't keep me from
using Excel, but it sure is annoying.

Railroader.

-----Original Message-----
If by going down the column you mean using the fill handle
and copying down -- both the formulas and formats are copied.

changed
Nov. 2001]

My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Railroader" <[email protected]>

wrote
in message news:15e3001c44766$689aaca0 [email protected]...

I am not new to Excel. However, this is a new computer
running MS Small Business Edition with what I

suppose
is

Excel 2003.

In loading data in columns I find that once I choose a
fill color near the top of the column, no matter what
data in put in the cells as I go down the column, this
previously chosen color will fill in the background as
soon as I hit enter.

This is happening on all my Excel spreadsheets so I
figure there is a "switch" somewhere I can turn off.
However, no handbook on Excel mentions this problem.
Anyone got any ideas?


.

.