keep fill color when copying down a formula?

[RalphReinbeck]

Hello. I've got a spreadsheet where every other row is
filled grey or white. This makes things a bit easier to
read in print, but the problem is, when I copy a formula
down a column, the fill color comes along with the
formula. Is there any way I can ``lock'' the fill color
to the cells so that this doesn't happen?

Thanks for any help that's out there -- I really
appreciate it.

R

 

[gkelle]

go to the edit menu, choose paste special then check formulas and number
formats

 

[RagDyer]

Check out Chip's web page on the subject:

http://www.cpearson.com/excel/banding.htm
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[Earl Kiosterud]

Ralph,

One way is to select two cells (one grey, one white). Then copy.

 

[Debra Dalgleish]

To copy the formula without the formatting, point to the fill handle
(the small black square at the bottom right corner of the cell), and
press the RIGHT mouse button.

Drag down, then release the mouse button.
From the shortcut menu that appears, choose 'Fill without formatting'

 

[Earl Kiosterud]

I may have misread your question. My answer provides for the alternating
color when you copy down.

 

[RagDyer]

What version are we talking about Debra ?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

To copy the formula without the formatting, point to the fill handle
(the small black square at the bottom right corner of the cell), and
press the RIGHT mouse button.

Drag down, then release the mouse button.
From the shortcut menu that appears, choose 'Fill without formatting'

 

[Dave Peterson]

It's there in xl2002.

What version are we talking about Debra ?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

To copy the formula without the formatting, point to the fill handle
(the small black square at the bottom right corner of the cell), and
press the RIGHT mouse button.

Drag down, then release the mouse button.
From the shortcut menu that appears, choose 'Fill without formatting'

 

[RagDyer]

That makes it hard to find in 00 or 97 ... doesn't it ? <g>
--


Regards,

RD

 

[Dave Peterson]

I only meant that it appears in xl2002--I don't have xl97 or xl2k to test. So
it could be there in those earlier versions?????

Or are you saying it isn't in your version and that version would be......

 

[RagDyer]

<"Or are you saying it isn't in your version and that version would
be......">
00 at the office *and* 97 at home !
I have 02 at the plant, but don't use it much for this forum.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


I only meant that it appears in xl2002--I don't have xl97 or xl2k to test.
So
it could be there in those earlier versions?????

Or are you saying it isn't in your version and that version would be......