Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 26th 04, 05:05 PM
HighPlanes
 
Posts: n/a
Default How can I set the default line width

I would like to change the default width of the lines fo shapes and lines.
The program automatically uses 3/4 pt. I would like to change the default to
3 pt instead of having to do it manually for each object,line shape.

  #2   Report Post  
Old November 27th 04, 03:30 AM
Debra Dalgleish
 
Posts: n/a
Default

You can format one line or shape.
Select it, then on the Drawing menu, choose DrawSet AutoShape Defaults

Other shapes that you add to that workbook will have the default settings.

For files with existing shapes, you can format one shape
Select it, and double-click the Format Painter button on the Formatting
toolbar
Click on each shape to apply the formatting
Click on the Format Painter button to deselect it (or press the Esc key)

HighPlanes wrote:
I would like to change the default width of the lines fo shapes and lines.
The program automatically uses 3/4 pt. I would like to change the default to
3 pt instead of having to do it manually for each object,line shape.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #3   Report Post  
Old December 3rd 04, 03:35 AM
Jon Peltier
 
Posts: n/a
Default

Also, if you make an autoshape with the formatting you like, select it and use the
Set Autoshape Default, on the Draw menu of the Drawing toolbar, to make your
settings the default for subsequent autoshapes you draw.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Debra Dalgleish wrote:

You can format one line or shape.
Select it, then on the Drawing menu, choose DrawSet AutoShape Defaults

Other shapes that you add to that workbook will have the default settings.

For files with existing shapes, you can format one shape
Select it, and double-click the Format Painter button on the Formatting
toolbar
Click on each shape to apply the formatting
Click on the Format Painter button to deselect it (or press the Esc key)

HighPlanes wrote:

I would like to change the default width of the lines fo shapes and
lines. The program automatically uses 3/4 pt. I would like to change
the default to 3 pt instead of having to do it manually for each
object,line shape.





  #4   Report Post  
Old December 3rd 04, 05:21 AM
Jon Peltier
 
Posts: n/a
Default

Doh!

On rereading my post and comparing it to Debra's, I realize that she'd already said
the bit that I added. In my defense I'll say that it's late, and I'm an idiot.

Apologies all around.

- Jon

Jon Peltier wrote:

Also, if you make an autoshape with the formatting you like, select it
and use the Set Autoshape Default, on the Draw menu of the Drawing
toolbar, to make your settings the default for subsequent autoshapes you
draw.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Debra Dalgleish wrote:

You can format one line or shape.
Select it, then on the Drawing menu, choose DrawSet AutoShape Defaults

Other shapes that you add to that workbook will have the default
settings.

For files with existing shapes, you can format one shape
Select it, and double-click the Format Painter button on the
Formatting toolbar
Click on each shape to apply the formatting
Click on the Format Painter button to deselect it (or press the Esc key)

HighPlanes wrote:

I would like to change the default width of the lines fo shapes and
lines. The program automatically uses 3/4 pt. I would like to change
the default to 3 pt instead of having to do it manually for each
object,line shape.









Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:44 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017