How to stop automatic cell shading
 

Excel 2007

I have a spreadsheet where I keep track of contractor hours by week. When I
receive the invoice for the week, I shade the cell yellow. When I go to add
next weeks hours, if the cell above is yellow, my new cell automatically
shades. How do I stop this? I couldn't find any place to turn off/on
autoformatting.

Thank you.

How to stop automatic cell shading
 

hi
try this...
2003 on the menu bar.....
toolsoptionsedit tabuncheck extend formats and formulas


Regards
FSt1

"Victoria@DIG" wrote:

Excel 2007

I have a spreadsheet where I keep track of contractor hours by week. When I
receive the invoice for the week, I shade the cell yellow. When I go to add
next weeks hours, if the cell above is yellow, my new cell automatically
shades. How do I stop this? I couldn't find any place to turn off/on
autoformatting.

Thank you.

How to stop automatic cell shading
 

I have 2007.


"FSt1" wrote:

hi
try this...
2003 on the menu bar.....
toolsoptionsedit tabuncheck extend formats and formulas


Regards
FSt1

"Victoria@DIG" wrote:

Excel 2007

I have a spreadsheet where I keep track of contractor hours by week. When I
receive the invoice for the week, I shade the cell yellow. When I go to add
next weeks hours, if the cell above is yellow, my new cell automatically
shades. How do I stop this? I couldn't find any place to turn off/on
autoformatting.

Thank you.

How to stop automatic cell shading
 

hi
i don't.
all i know is that is office buttonexcel options
may be the same after that.

regards
FSt1

"Victoria@DIG" wrote:

I have 2007.


"FSt1" wrote:

hi
try this...
2003 on the menu bar.....
toolsoptionsedit tabuncheck extend formats and formulas


Regards
FSt1

"Victoria@DIG" wrote:

Excel 2007

I have a spreadsheet where I keep track of contractor hours by week. When I
receive the invoice for the week, I shade the cell yellow. When I go to add
next weeks hours, if the cell above is yellow, my new cell automatically
shades. How do I stop this? I couldn't find any place to turn off/on
autoformatting.

Thank you.