How to stop automatic cell shading

V

Victoria@DIG

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.
 
F

FSt1

hi
try this...
2003 on the menu bar.....
tools>options>edit tab>uncheck extend formats and formulas


Regards
FSt1
 
F

FSt1

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

regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make the shading look uniform around a double spaced line in MS Word? 0
Cumulative formula for word table 0
How do I convert shading to highlighting for specific colors 8
cell shading 1
Shading periods in a scatter plot 0
Automatic If statement / macro to copy one cell to different worksheet and print! 2
Recognize Cell Color and Sum Data accordingly 3
Drop Down Shading 3

Top