Strange Background


J

JAD

I have a worksheet that I cut and copied to another worksheet. When I return
to the worksheet that I just cut from, I have a number of green and yellow
rows that stretch from one end to the other and repeats that patern every
15th or 20th row. It also has a horizontal border line that does the same.
With the original design in place, prior to the cut and paste task, I neither
see the horizontal bars or border behind my design or to the right of my
section. The worksheet acts as if there are two layers of design; mine and
the color bars and border. My question is three fold. 1st, what can I do to
eliminate / delete the hidden color bar and border without destroying my
design? 2nd, how did this happen? 3rd how do you prevent it from happening?
Any help would be appreciated, Thank You, JAD
 
Ad

Advertisements

I

IanKR

JAD said:
I have a worksheet that I cut and copied to another worksheet. When I
return
to the worksheet that I just cut from, I have a number of green and yellow
rows that stretch from one end to the other and repeats that patern every
15th or 20th row. It also has a horizontal border line that does the same.
With the original design in place, prior to the cut and paste task, I
neither
see the horizontal bars or border behind my design or to the right of my
section. The worksheet acts as if there are two layers of design; mine and
the color bars and border. My question is three fold. 1st, what can I do
to
eliminate / delete the hidden color bar and border without destroying my
design? 2nd, how did this happen? 3rd how do you prevent it from
happening?
Any help would be appreciated, Thank You, JAD

Is Track Changes enabled?
 
Ad

Advertisements

D

Doug Glancy

JAD,

It might have to do with conditional formatting and the condition is changed
by the cut. Highlight one of the cells that has the color/borders and click
Format>Conditional Formatting. See if there is any conditional formatting
specified. If there is you can remove it easily without messing up the
worksheet.

hth,

Doug
 

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

Top