Filling without copying border settings?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

davidd31415 - 19 Jun 2005 02:58 GMT

Is there a way to Fill-Down or Fill-Right in Excel without affecting
borders? I have written macros to do such things but I end up using
Excel on so many computers that I am compelled to see if there is a
simpiler solution?

Often I have a preformated form, and I end up having to reformat cells
because the border outline ends up either getting removed or copied
into interior cells.

Reply to this Message

Norman Jones - 19 Jun 2005 03:06 GMT

Hi David,

With the Ctrl key depressed, drag with the right mouse key - you will see
options to Fill Values or to Fill Formats.

---
Regards,
Norman

> Is there a way to Fill-Down or Fill-Right in Excel without affecting
> borders? I have written macros to do such things but I end up using
[quoted text clipped - 4 lines]
> because the border outline ends up either getting removed or copied
> into interior cells.

Reply to this Message

Earl Kiosterud - 19 Jun 2005 14:43 GMT

Norman,

I've not been able to see a difference with or without Ctrl when
right-dragging the Fill Handle. I'd expect Ctrl to stop the incrementing
that normally would occur with something like Dept1, or a date. Doesn't
seem to work. And in the right-drag menu, I don't get the Fill Values you
mention (this is Excel 2002) -- I get Fill Without Formatting (which is a
pain for dates).

The only method to copy while preserving borders (at least that I've found)
is to Copy, then Paste-special - All Except Borders.

Signature

Earl Kiosterud
www.smokeylake.com/

Off-topic: There's a hilarious comedy act by Men in Coats at
http://www.koreus.com/files/200505/men-in-coats.html. You gotta see this.
I had to share.
-------------------------------------------

> Hi David,
>
[quoted text clipped - 13 lines]
>> because the border outline ends up either getting removed or copied
>> into interior cells.

Reply to this Message

Norman Jones - 19 Jun 2005 16:28 GMT

Hi Earl,

> I've not been able to see a difference with or without Ctrl when
> right-dragging the Fill Handle. I'd expect Ctrl to stop the incrementing
> that normally would occur with something like Dept1, or a date. Doesn't
> seem to work.

You are correct, Ctrl has no effect; it is merely a long-standing
misaprehension on my part!

> And in the right-drag menu, I don't get the Fill Values you mention (this
> is Excel 2002) -- I get Fill Without Formatting (which is a pain for
> dates).

I think that Fill Values and Fill Without Formatting are inter-version
equivalents. More specifically, with xl2k, right-dragging a series puts up
the following main context menu:

Copy Cells
Fill series
Fill Formats
Fill Values.

---
Regards,
Norman

Reply to this Message

davidd31415 - 20 Jun 2005 01:42 GMT

Just the functionality I was looking for. I often avoid using the
mouse and am suprised there is not a menu option to simply select
between a default mode, but this is a great solution.

Thank you!

David.

Reply to this Message