Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Mar 2001
    Location
    Tampa, Florida, USA
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Drawing multiple borders (2003 SP1)

    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?

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Drawing multiple borders (2003 SP1)

    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.
    Regards,
    Rudi

  3. #3
    Lounger
    Join Date
    Mar 2001
    Location
    Tampa, Florida, USA
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Drawing multiple borders (2003 SP1)

    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.

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Drawing multiple borders (2003 SP1)

    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??
    Regards,
    Rudi

  5. #5
    Lounger
    Join Date
    Mar 2001
    Location
    Tampa, Florida, USA
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Drawing multiple borders (2003 SP1)

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

    <img src=/S/shocked.gif border=0 alt=shocked width=15 height=15>

    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.

  6. #6
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Drawing multiple borders (2003 SP1)

    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!
    Regards,
    Rudi

  7. #7
    Lounger
    Join Date
    Mar 2001
    Location
    Tampa, Florida, USA
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Drawing multiple borders (2003 SP1)

    So upgrade it to SP1 and let's see if it breaks the drawing borders function! <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

    Mine shows: "Microsoft Office Excel 2003 (11.6355.6408) SP1"

    Thanks for trying!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •