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

Export data from the same cell from multiple spreadsheets into a n 1
Cell shading depending on which day 1
How do I turn off auto cell formating? 3
slanted cell shading 8
How can colour of cell shading be fixed to one colour 2
Conditional Formatting a row based on a value in a cell 1
stop creating email link when @ sign is present 2
Cell shading with conditional formatting 5

Top