Drawing multiple borders (2003 SP1)

Topic

New Reply

In Excel 2002, when you select the border drawing tool, it ‘stays on’–you can keep drawing borders with the pencil cursor until you click it off. But in version 2003, it clicks off after you draw the first border–the pencil cursor reverts back to the default cursor. Anyone know of a way to make it stay on like it did before?

Reply | Quote

Replies

I don’t have a 2003 version at hand at the moment, but have you tried double clicking the pencil icon. This can be used for for the format painter too. Double clicking keeps it active to format multiple objects/cells/etc. I can’t test it, but try it out and reply if it works.

Reply | Quote

Double-clicking doesn’t seem to work. I see what you mean about double-clicking the Format Painter icon…that does work. But I tried double-clicking everything I could in the borders toolbar, and everything responds to a single-click, and none of it leaves the pencil cursor active after drawing one border.

Reply | Quote

Ive managed to get to a 2003 PC. My pencil stays on when I draw borders. Are you using the Borders toolbar where you have the option of Draw Border and Draw Border Grid??

Reply | Quote

>Ive managed to get to a 2003 PC.
>My pencil stays on when I draw borders.

Is your 2003 installation SP1? Maybe that’s a difference….

>Are you using the Borders toolbar where you have
>the option of Draw Border and Draw Border Grid??

Yes, exactly.

Reply | Quote

when I go to the Help menu and select About Excel…It does not show the SP number. It shows “Microsoft Office Excel 2003 (11.123234.123) (Something like that!!!)
I doubt it is to do with the service pack…
Anyways…I’m not to sure what else to suggest!

Reply | Quote

So upgrade it to SP1 and let’s see if it breaks the drawing borders function!

Mine shows: “Microsoft Office Excel 2003 (11.6355.6408) SP1”

Thanks for trying!

Reply | Quote