Excel auto-fit

I accidently dragged and deleted the format width autofit option on my
toolbar. I want it back. I know you can double click the column top to get
the whole column to autofit; but sometimes I just want a cell to be the
autofit width for the entire column. How can I get it back?

You can reset toolbars under tools>customize>toolbars and reset


Regards,

Peo Sjoblom

"NancyC" wrote:

> I accidently dragged and deleted the format width autofit option on my
> toolbar. I want it back. I know you can double click the column top to get
> the whole column to autofit; but sometimes I just want a cell to be the
> autofit width for the entire column. How can I get it back?

Sorry, it was not on the toolbar, it is on the top command bar where "File
is. I used to be able to hit Format Column and the Autofit option was there.
I tried resetting toolbars; but I do not believe this is called a toolbar,
it is where the commands are like File, Edit, View, Insert, Format, etc. I
had accidently dragged it somehwere and it disappeared.

"Peo Sjoblom" wrote:

> You can reset toolbars under tools>customize>toolbars and reset
>
>
> Regards,
>
> Peo Sjoblom
>
> "NancyC" wrote:
>
> > I accidently dragged and deleted the format width autofit option on my
> > toolbar. I want it back. I know you can double click the column top to get
> > the whole column to autofit; but sometimes I just want a cell to be the
> > autofit width for the entire column. How can I get it back?

Use Peo's approach but select Worksheet Menu Bar (towards the end of the
list) and then do the reset.

--
Jim Rech
Excel MVP
"NancyC" <[email protected]> wrote in message
news:[email protected]...
| Sorry, it was not on the toolbar, it is on the top command bar where "File
| is. I used to be able to hit Format Column and the Autofit option was
there.
| I tried resetting toolbars; but I do not believe this is called a toolbar,
| it is where the commands are like File, Edit, View, Insert, Format, etc.
I
| had accidently dragged it somehwere and it disappeared.
|
| "Peo Sjoblom" wrote:
|
| > You can reset toolbars under tools>customize>toolbars and reset
| >
| >
| > Regards,
| >
| > Peo Sjoblom
| >
| > "NancyC" wrote:
| >
| > > I accidently dragged and deleted the format width autofit option on my
| > > toolbar. I want it back. I know you can double click the column top
to get
| > > the whole column to autofit; but sometimes I just want a cell to be
the
| > > autofit width for the entire column. How can I get it back?

I have a similar problem. I was previously using Excell 2000 and when I
upgraded to 2003 the autofit icon that I had put on my extensively customized
toolbar was no longer there.

I have searched for the icon in tools/customize, but can't find it to drag
on the toolbar. Is it called something different now? I don't want to reset
toolbar because of customization. Am not having any luck with "Double-click
the left column border in the column header to set the column to Best Fit."
I must be clicking in the wrong place, but can't find the correct place.

Any help greatly appreciated.

"Jim Rech" wrote:

> Use Peo's approach but select Worksheet Menu Bar (towards the end of the
> list) and then do the reset.
>
> --
> Jim Rech
> Excel MVP
> "NancyC" <[email protected]> wrote in message
> news:[email protected]...
> | Sorry, it was not on the toolbar, it is on the top command bar where "File
> | is. I used to be able to hit Format Column and the Autofit option was
> there.
> | I tried resetting toolbars; but I do not believe this is called a toolbar,
> | it is where the commands are like File, Edit, View, Insert, Format, etc.
> I
> | had accidently dragged it somehwere and it disappeared.
> |
> | "Peo Sjoblom" wrote:
> |
> | > You can reset toolbars under tools>customize>toolbars and reset
> | >
> | >
> | > Regards,
> | >
> | > Peo Sjoblom
> | >
> | > "NancyC" wrote:
> | >
> | > > I accidently dragged and deleted the format width autofit option on my
> | > > toolbar. I want it back. I know you can double click the column top
> to get
> | > > the whole column to autofit; but sometimes I just want a cell to be
> the
> | > > autofit width for the entire column. How can I get it back?
>
>
>

I've never had autofit on my toolbar and I've never had any trouble with just
double clicking on the row/column headers.

But you could add an icon to your favorite toolbar:

Tools|customize (just to show that dialog)
now click on Format, then column, then ctrl-drag "autofit selection" to your
favorite toolbar.

ctrl-drag copies that icon. If you just drag it, you'll be moving it.



Ann Shaw wrote:
>
> I have a similar problem. I was previously using Excell 2000 and when I
> upgraded to 2003 the autofit icon that I had put on my extensively customized
> toolbar was no longer there.
>
> I have searched for the icon in tools/customize, but can't find it to drag
> on the toolbar. Is it called something different now? I don't want to reset
> toolbar because of customization. Am not having any luck with "Double-click
> the left column border in the column header to set the column to Best Fit."
> I must be clicking in the wrong place, but can't find the correct place.
>
> Any help greatly appreciated.
>
> "Jim Rech" wrote:
>
> > Use Peo's approach but select Worksheet Menu Bar (towards the end of the
> > list) and then do the reset.
> >
> > --
> > Jim Rech
> > Excel MVP
> > "NancyC" <[email protected]> wrote in message
> > news:[email protected]...
> > | Sorry, it was not on the toolbar, it is on the top command bar where "File
> > | is. I used to be able to hit Format Column and the Autofit option was
> > there.
> > | I tried resetting toolbars; but I do not believe this is called a toolbar,
> > | it is where the commands are like File, Edit, View, Insert, Format, etc.
> > I
> > | had accidently dragged it somehwere and it disappeared.
> > |
> > | "Peo Sjoblom" wrote:
> > |
> > | > You can reset toolbars under tools>customize>toolbars and reset
> > | >
> > | >
> > | > Regards,
> > | >
> > | > Peo Sjoblom
> > | >
> > | > "NancyC" wrote:
> > | >
> > | > > I accidently dragged and deleted the format width autofit option on my
> > | > > toolbar. I want it back. I know you can double click the column top
> > to get
> > | > > the whole column to autofit; but sometimes I just want a cell to be
> > the
> > | > > autofit width for the entire column. How can I get it back?
> >
> >
> >

--

Dave Peterson

Dave -
Thanks so much for your help. That option worked, although I would prefer
the smaller icon that evidentally has been eliminated from the toolbar
choices. I do still have the icon in Word and have put a screenshot on my
web page so that you can see what it looks like. Here's the page address:
http://www.dogwoodtrainingacademy.com/autofit.htm
Ann

"Dave Peterson" wrote:

> I've never had autofit on my toolbar and I've never had any trouble with just
> double clicking on the row/column headers.
>
> But you could add an icon to your favorite toolbar:
>
> Tools|customize (just to show that dialog)
> now click on Format, then column, then ctrl-drag "autofit selection" to your
> favorite toolbar.
>
> ctrl-drag copies that icon. If you just drag it, you'll be moving it.
>
>
>
> Ann Shaw wrote:
> >
> > I have a similar problem. I was previously using Excell 2000 and when I
> > upgraded to 2003 the autofit icon that I had put on my extensively customized
> > toolbar was no longer there.
> >
> > I have searched for the icon in tools/customize, but can't find it to drag
> > on the toolbar. Is it called something different now? I don't want to reset
> > toolbar because of customization. Am not having any luck with "Double-click
> > the left column border in the column header to set the column to Best Fit."
> > I must be clicking in the wrong place, but can't find the correct place.
> >
> > Any help greatly appreciated.
> >
> > "Jim Rech" wrote:
> >
> > > Use Peo's approach but select Worksheet Menu Bar (towards the end of the
> > > list) and then do the reset.
> > >
> > > --
> > > Jim Rech
> > > Excel MVP
> > > "NancyC" <[email protected]> wrote in message
> > > news:[email protected]...
> > > | Sorry, it was not on the toolbar, it is on the top command bar where "File
> > > | is. I used to be able to hit Format Column and the Autofit option was
> > > there.
> > > | I tried resetting toolbars; but I do not believe this is called a toolbar,
> > > | it is where the commands are like File, Edit, View, Insert, Format, etc.
> > > I
> > > | had accidently dragged it somehwere and it disappeared.
> > > |
> > > | "Peo Sjoblom" wrote:
> > > |
> > > | > You can reset toolbars under tools>customize>toolbars and reset
> > > | >
> > > | >
> > > | > Regards,
> > > | >
> > > | > Peo Sjoblom
> > > | >
> > > | > "NancyC" wrote:
> > > | >
> > > | > > I accidently dragged and deleted the format width autofit option on my
> > > | > > toolbar. I want it back. I know you can double click the column top
> > > to get
> > > | > > the whole column to autofit; but sometimes I just want a cell to be
> > > the
> > > | > > autofit width for the entire column. How can I get it back?
> > >
> > >
> > >
>
> --
>
> Dave Peterson
>

I didn't look at the picture, but you can do this:

Tools|customize (again, just so that dialog is visible)
rightclick on the "autofit selection"
You can change the the icon there
You can change it to the default style

There's a few options you may want to play with.

Ann Shaw wrote:
>
> Dave -
> Thanks so much for your help. That option worked, although I would prefer
> the smaller icon that evidentally has been eliminated from the toolbar
> choices. I do still have the icon in Word and have put a screenshot on my
> web page so that you can see what it looks like. Here's the page address:
> http://www.dogwoodtrainingacademy.com/autofit.htm
> Ann
>
> "Dave Peterson" wrote:
>
> > I've never had autofit on my toolbar and I've never had any trouble with just
> > double clicking on the row/column headers.
> >
> > But you could add an icon to your favorite toolbar:
> >
> > Tools|customize (just to show that dialog)
> > now click on Format, then column, then ctrl-drag "autofit selection" to your
> > favorite toolbar.
> >
> > ctrl-drag copies that icon. If you just drag it, you'll be moving it.
> >
> >
> >
> > Ann Shaw wrote:
> > >
> > > I have a similar problem. I was previously using Excell 2000 and when I
> > > upgraded to 2003 the autofit icon that I had put on my extensively customized
> > > toolbar was no longer there.
> > >
> > > I have searched for the icon in tools/customize, but can't find it to drag
> > > on the toolbar. Is it called something different now? I don't want to reset
> > > toolbar because of customization. Am not having any luck with "Double-click
> > > the left column border in the column header to set the column to Best Fit."
> > > I must be clicking in the wrong place, but can't find the correct place.
> > >
> > > Any help greatly appreciated.
> > >
> > > "Jim Rech" wrote:
> > >
> > > > Use Peo's approach but select Worksheet Menu Bar (towards the end of the
> > > > list) and then do the reset.
> > > >
> > > > --
> > > > Jim Rech
> > > > Excel MVP
> > > > "NancyC" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > | Sorry, it was not on the toolbar, it is on the top command bar where "File
> > > > | is. I used to be able to hit Format Column and the Autofit option was
> > > > there.
> > > > | I tried resetting toolbars; but I do not believe this is called a toolbar,
> > > > | it is where the commands are like File, Edit, View, Insert, Format, etc.
> > > > I
> > > > | had accidently dragged it somehwere and it disappeared.
> > > > |
> > > > | "Peo Sjoblom" wrote:
> > > > |
> > > > | > You can reset toolbars under tools>customize>toolbars and reset
> > > > | >
> > > > | >
> > > > | > Regards,
> > > > | >
> > > > | > Peo Sjoblom
> > > > | >
> > > > | > "NancyC" wrote:
> > > > | >
> > > > | > > I accidently dragged and deleted the format width autofit option on my
> > > > | > > toolbar. I want it back. I know you can double click the column top
> > > > to get
> > > > | > > the whole column to autofit; but sometimes I just want a cell to be
> > > > the
> > > > | > > autofit width for the entire column. How can I get it back?
> > > >
> > > >
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

Dave - You're wonderful. Never knew you could do all of that. I copies my
icon from Word and pasted it into Excel (the default icon in Excel was blank).

Now my only toolbar problem is one that was left over when I uninstalled a
program called TextBridge. I've got it in both Word & Excel. Have tried to
delete, but it's back everything I restart either program. Guess it's in the
registry of somewhere else I don't know where to look.

You have a great weekend and, again, thanks for all of your help.

Ann

"Dave Peterson" wrote:

> I didn't look at the picture, but you can do this:
>
> Tools|customize (again, just so that dialog is visible)
> rightclick on the "autofit selection"
> You can change the the icon there
> You can change it to the default style
>
> There's a few options you may want to play with.
>

I'd check to see if there's a textbridge addin being loaded when excel starts.

(I don't use the Textbridge software with my scanner.)

Tools|Addins
(If you find it here, uncheck it)

Or maybe in your XLStart folder.
(if you find it here, move it somewhere nice and safe--just in case you ever
want to use it later.)

If the toolbar is still there after you've turned off/moved the file, then
tools|customize|tooblars tab|uncheck the Textbridge toolbar.
(Or select it and delete it????)

Maybe the combination of turning everything off and removing it would keep it
turned off.

===
Textbridge does have different problem (not that you described). One of the
solutions for that is to move TBRun##.xls (or remove it). (TBRun97.xls comes up
often with this problem.)

You could use windows start button|search and look for:
tbrun*.xls

if you have trouble finding it.

Ann Shaw wrote:
>
> Dave - You're wonderful. Never knew you could do all of that. I copies my
> icon from Word and pasted it into Excel (the default icon in Excel was blank).
>
> Now my only toolbar problem is one that was left over when I uninstalled a
> program called TextBridge. I've got it in both Word & Excel. Have tried to
> delete, but it's back everything I restart either program. Guess it's in the
> registry of somewhere else I don't know where to look.
>
> You have a great weekend and, again, thanks for all of your help.
>
> Ann
>
> "Dave Peterson" wrote:
>
> > I didn't look at the picture, but you can do this:
> >
> > Tools|customize (again, just so that dialog is visible)
> > rightclick on the "autofit selection"
> > You can change the the icon there
> > You can change it to the default style
> >
> > There's a few options you may want to play with.
> >

--

Dave Peterson

Once again, thanks for all the suggestions. I don't use TextBridge anymore
so it's just leftover stuff.

I tried all your options below. It doesn't show up in add-ins or in the
toolbar list and when I delete it reappears the next time I open Excel. BUT,
I did find it in XLSTART and that did the trick.

It's also hanging around in Word so I checked every "start" folder, but
couldn't find it. Does Word have a uniquily named start folder?

Ann

"Dave Peterson" wrote:

> I'd check to see if there's a textbridge addin being loaded when excel starts.
>
> (I don't use the Textbridge software with my scanner.)
>
> Tools|Addins
> (If you find it here, uncheck it)
>
> Or maybe in your XLStart folder.
> (if you find it here, move it somewhere nice and safe--just in case you ever
> want to use it later.)
>
> If the toolbar is still there after you've turned off/moved the file, then
> tools|customize|tooblars tab|uncheck the Textbridge toolbar.
> (Or select it and delete it????)
>
> Maybe the combination of turning everything off and removing it would keep it
> turned off.
>
> ===
> Textbridge does have different problem (not that you described). One of the
> solutions for that is to move TBRun##.xls (or remove it). (TBRun97.xls comes up
> often with this problem.)
>
> You could use windows start button|search and look for:
> tbrun*.xls
>
> if you have trouble finding it.
>
> Ann Shaw wrote:
> >
> > Dave - You're wonderful. Never knew you could do all of that. I copies my
> > icon from Word and pasted it into Excel (the default icon in Excel was blank).
> >
> > Now my only toolbar problem is one that was left over when I uninstalled a
> > program called TextBridge. I've got it in both Word & Excel. Have tried to
> > delete, but it's back everything I restart either program. Guess it's in the
> > registry of somewhere else I don't know where to look.
> >
> > You have a great weekend and, again, thanks for all of your help.
> >
> > Ann
> >
> > "Dave Peterson" wrote:
> >
> > > I didn't look at the picture, but you can do this:
> > >
> > > Tools|customize (again, just so that dialog is visible)
> > > rightclick on the "autofit selection"
> > > You can change the the icon there
> > > You can change it to the default style
> > >
> > > There's a few options you may want to play with.
> > >
>
> --
>
> Dave Peterson
>

I still don't use TextBridge <bg> and I'm just dangerous enough to hurt myself
in MSWord.

But Google knows everything!

http://groups.google.co.uk/groups?th...%40tkmsftngp04

When you read Suzanne Barnhill's last post, you'll see something that works in
Excel, too.

(But I like to suggest the longer way!)



Ann Shaw wrote:
>
> Once again, thanks for all the suggestions. I don't use TextBridge anymore
> so it's just leftover stuff.
>
> I tried all your options below. It doesn't show up in add-ins or in the
> toolbar list and when I delete it reappears the next time I open Excel. BUT,
> I did find it in XLSTART and that did the trick.
>
> It's also hanging around in Word so I checked every "start" folder, but
> couldn't find it. Does Word have a uniquily named start folder?
>
> Ann
>
> "Dave Peterson" wrote:
>
> > I'd check to see if there's a textbridge addin being loaded when excel starts.
> >
> > (I don't use the Textbridge software with my scanner.)
> >
> > Tools|Addins
> > (If you find it here, uncheck it)
> >
> > Or maybe in your XLStart folder.
> > (if you find it here, move it somewhere nice and safe--just in case you ever
> > want to use it later.)
> >
> > If the toolbar is still there after you've turned off/moved the file, then
> > tools|customize|tooblars tab|uncheck the Textbridge toolbar.
> > (Or select it and delete it????)
> >
> > Maybe the combination of turning everything off and removing it would keep it
> > turned off.
> >
> > ===
> > Textbridge does have different problem (not that you described). One of the
> > solutions for that is to move TBRun##.xls (or remove it). (TBRun97.xls comes up
> > often with this problem.)
> >
> > You could use windows start button|search and look for:
> > tbrun*.xls
> >
> > if you have trouble finding it.
> >
> > Ann Shaw wrote:
> > >
> > > Dave - You're wonderful. Never knew you could do all of that. I copies my
> > > icon from Word and pasted it into Excel (the default icon in Excel was blank).
> > >
> > > Now my only toolbar problem is one that was left over when I uninstalled a
> > > program called TextBridge. I've got it in both Word & Excel. Have tried to
> > > delete, but it's back everything I restart either program. Guess it's in the
> > > registry of somewhere else I don't know where to look.
> > >
> > > You have a great weekend and, again, thanks for all of your help.
> > >
> > > Ann
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > I didn't look at the picture, but you can do this:
> > > >
> > > > Tools|customize (again, just so that dialog is visible)
> > > > rightclick on the "autofit selection"
> > > > You can change the the icon there
> > > > You can change it to the default style
> > > >
> > > > There's a few options you may want to play with.
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

Had no idea about the Google group. The alt+drag did the trick! Both Word &
Excel are FREE!

Ann


"Dave Peterson" wrote:

> I still don't use TextBridge <bg> and I'm just dangerous enough to hurt myself
> in MSWord.
>
> But Google knows everything!
>
> http://groups.google.co.uk/groups?th...%40tkmsftngp04
>
> When you read Suzanne Barnhill's last post, you'll see something that works in
> Excel, too.
>
> (But I like to suggest the longer way!)
>
>
>
> Ann Shaw wrote:
> >
> > Once again, thanks for all the suggestions. I don't use TextBridge anymore
> > so it's just leftover stuff.
> >
> > I tried all your options below. It doesn't show up in add-ins or in the
> > toolbar list and when I delete it reappears the next time I open Excel. BUT,
> > I did find it in XLSTART and that did the trick.
> >
> > It's also hanging around in Word so I checked every "start" folder, but
> > couldn't find it. Does Word have a uniquily named start folder?
> >
> > Ann
> >
> > "Dave Peterson" wrote:
> >
> > > I'd check to see if there's a textbridge addin being loaded when excel starts.
> > >
> > > (I don't use the Textbridge software with my scanner.)
> > >
> > > Tools|Addins
> > > (If you find it here, uncheck it)
> > >
> > > Or maybe in your XLStart folder.
> > > (if you find it here, move it somewhere nice and safe--just in case you ever
> > > want to use it later.)
> > >
> > > If the toolbar is still there after you've turned off/moved the file, then
> > > tools|customize|tooblars tab|uncheck the Textbridge toolbar.
> > > (Or select it and delete it????)
> > >
> > > Maybe the combination of turning everything off and removing it would keep it
> > > turned off.
> > >
> > > ===
> > > Textbridge does have different problem (not that you described). One of the
> > > solutions for that is to move TBRun##.xls (or remove it). (TBRun97.xls comes up
> > > often with this problem.)
> > >
> > > You could use windows start button|search and look for:
> > > tbrun*.xls
> > >
> > > if you have trouble finding it.
> > >
> > > Ann Shaw wrote:
> > > >
> > > > Dave - You're wonderful. Never knew you could do all of that. I copies my
> > > > icon from Word and pasted it into Excel (the default icon in Excel was blank).
> > > >
> > > > Now my only toolbar problem is one that was left over when I uninstalled a
> > > > program called TextBridge. I've got it in both Word & Excel. Have tried to
> > > > delete, but it's back everything I restart either program. Guess it's in the
> > > > registry of somewhere else I don't know where to look.
> > > >
> > > > You have a great weekend and, again, thanks for all of your help.
> > > >
> > > > Ann
> > > >
> > > > "Dave Peterson" wrote:
> > > >
> > > > > I didn't look at the picture, but you can do this:
> > > > >
> > > > > Tools|customize (again, just so that dialog is visible)
> > > > > rightclick on the "autofit selection"
> > > > > You can change the the icon there
> > > > > You can change it to the default style
> > > > >
> > > > > There's a few options you may want to play with.
> > > > >
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>

Glad you got it working.



Ann Shaw wrote:
>
> Had no idea about the Google group. The alt+drag did the trick! Both Word &
> Excel are FREE!
>
> Ann
>
> "Dave Peterson" wrote:
>
> > I still don't use TextBridge <bg> and I'm just dangerous enough to hurt myself
> > in MSWord.
> >
> > But Google knows everything!
> >
> > http://groups.google.co.uk/groups?th...%40tkmsftngp04
> >
> > When you read Suzanne Barnhill's last post, you'll see something that works in
> > Excel, too.
> >
> > (But I like to suggest the longer way!)
> >
> >
> >
> > Ann Shaw wrote:
> > >
> > > Once again, thanks for all the suggestions. I don't use TextBridge anymore
> > > so it's just leftover stuff.
> > >
> > > I tried all your options below. It doesn't show up in add-ins or in the
> > > toolbar list and when I delete it reappears the next time I open Excel. BUT,
> > > I did find it in XLSTART and that did the trick.
> > >
> > > It's also hanging around in Word so I checked every "start" folder, but
> > > couldn't find it. Does Word have a uniquily named start folder?
> > >
> > > Ann
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > I'd check to see if there's a textbridge addin being loaded when excel starts.
> > > >
> > > > (I don't use the Textbridge software with my scanner.)
> > > >
> > > > Tools|Addins
> > > > (If you find it here, uncheck it)
> > > >
> > > > Or maybe in your XLStart folder.
> > > > (if you find it here, move it somewhere nice and safe--just in case you ever
> > > > want to use it later.)
> > > >
> > > > If the toolbar is still there after you've turned off/moved the file, then
> > > > tools|customize|tooblars tab|uncheck the Textbridge toolbar.
> > > > (Or select it and delete it????)
> > > >
> > > > Maybe the combination of turning everything off and removing it would keep it
> > > > turned off.
> > > >
> > > > ===
> > > > Textbridge does have different problem (not that you described). One of the
> > > > solutions for that is to move TBRun##.xls (or remove it). (TBRun97.xls comes up
> > > > often with this problem.)
> > > >
> > > > You could use windows start button|search and look for:
> > > > tbrun*.xls
> > > >
> > > > if you have trouble finding it.
> > > >
> > > > Ann Shaw wrote:
> > > > >
> > > > > Dave - You're wonderful. Never knew you could do all of that. I copies my
> > > > > icon from Word and pasted it into Excel (the default icon in Excel was blank).
> > > > >
> > > > > Now my only toolbar problem is one that was left over when I uninstalled a
> > > > > program called TextBridge. I've got it in both Word & Excel. Have tried to
> > > > > delete, but it's back everything I restart either program. Guess it's in the
> > > > > registry of somewhere else I don't know where to look.
> > > > >
> > > > > You have a great weekend and, again, thanks for all of your help.
> > > > >
> > > > > Ann
> > > > >
> > > > > "Dave Peterson" wrote:
> > > > >
> > > > > > I didn't look at the picture, but you can do this:
> > > > > >
> > > > > > Tools|customize (again, just so that dialog is visible)
> > > > > > rightclick on the "autofit selection"
> > > > > > You can change the the icon there
> > > > > > You can change it to the default style
> > > > > >
> > > > > > There's a few options you may want to play with.
> > > > > >
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

Dave,

I created a pivot table. The only problem is that the cell widths keep
changing to very wide every time I move different data into the data field.
I "autofit" the columns and they get narrow again, but as soon as I change
something in the data field area again, they revert back to very wide. I
want to keep them narrow so I can see them on one screen, not scroll over and
over.

Any ideas how to lock cell widths? Or have autofit automatically adjust
cell widths?

Thanks,

Lyman Adrian
--
Lyman Adrian
USAF (ret)



"Dave Peterson" wrote:

> I'd check to see if there's a textbridge addin being loaded when excel starts.
>
> (I don't use the Textbridge software with my scanner.)
>
> Tools|Addins
> (If you find it here, uncheck it)
>
> Or maybe in your XLStart folder.
> (if you find it here, move it somewhere nice and safe--just in case you ever
> want to use it later.)
>
> If the toolbar is still there after you've turned off/moved the file, then
> tools|customize|tooblars tab|uncheck the Textbridge toolbar.
> (Or select it and delete it????)
>
> Maybe the combination of turning everything off and removing it would keep it
> turned off.
>
> ===
> Textbridge does have different problem (not that you described). One of the
> solutions for that is to move TBRun##.xls (or remove it). (TBRun97.xls comes up
> often with this problem.)
>
> You could use windows start button|search and look for:
> tbrun*.xls
>
> if you have trouble finding it.
>
> Ann Shaw wrote:
> >
> > Dave - You're wonderful. Never knew you could do all of that. I copies my
> > icon from Word and pasted it into Excel (the default icon in Excel was blank).
> >
> > Now my only toolbar problem is one that was left over when I uninstalled a
> > program called TextBridge. I've got it in both Word & Excel. Have tried to
> > delete, but it's back everything I restart either program. Guess it's in the
> > registry of somewhere else I don't know where to look.
> >
> > You have a great weekend and, again, thanks for all of your help.
> >
> > Ann
> >
> > "Dave Peterson" wrote:
> >
> > > I didn't look at the picture, but you can do this:
> > >
> > > Tools|customize (again, just so that dialog is visible)
> > > rightclick on the "autofit selection"
> > > You can change the the icon there
> > > You can change it to the default style
> > >
> > > There's a few options you may want to play with.
> > >
>
> --
>
> Dave Peterson
>

Maybe you could have a little macro run each time the worksheet calculates:

Right click on the tab that contains the pivottable.
Select View code
paste this into the code window:

Option Explicit
Private Sub Worksheet_Calculate()
Me.UsedRange.Columns.AutoFit
End Sub


Back to excel and test it out.

Lyman Adrian wrote:
>
> Dave,
>
> I created a pivot table. The only problem is that the cell widths keep
> changing to very wide every time I move different data into the data field.
> I "autofit" the columns and they get narrow again, but as soon as I change
> something in the data field area again, they revert back to very wide. I
> want to keep them narrow so I can see them on one screen, not scroll over and
> over.
>
> Any ideas how to lock cell widths? Or have autofit automatically adjust
> cell widths?
>
> Thanks,
>
> Lyman Adrian
> --
> Lyman Adrian
> USAF (ret)
>
> "Dave Peterson" wrote:
>
> > I'd check to see if there's a textbridge addin being loaded when excel starts.
> >
> > (I don't use the Textbridge software with my scanner.)
> >
> > Tools|Addins
> > (If you find it here, uncheck it)
> >
> > Or maybe in your XLStart folder.
> > (if you find it here, move it somewhere nice and safe--just in case you ever
> > want to use it later.)
> >
> > If the toolbar is still there after you've turned off/moved the file, then
> > tools|customize|tooblars tab|uncheck the Textbridge toolbar.
> > (Or select it and delete it????)
> >
> > Maybe the combination of turning everything off and removing it would keep it
> > turned off.
> >
> > ===
> > Textbridge does have different problem (not that you described). One of the
> > solutions for that is to move TBRun##.xls (or remove it). (TBRun97.xls comes up
> > often with this problem.)
> >
> > You could use windows start button|search and look for:
> > tbrun*.xls
> >
> > if you have trouble finding it.
> >
> > Ann Shaw wrote:
> > >
> > > Dave - You're wonderful. Never knew you could do all of that. I copies my
> > > icon from Word and pasted it into Excel (the default icon in Excel was blank).
> > >
> > > Now my only toolbar problem is one that was left over when I uninstalled a
> > > program called TextBridge. I've got it in both Word & Excel. Have tried to
> > > delete, but it's back everything I restart either program. Guess it's in the
> > > registry of somewhere else I don't know where to look.
> > >
> > > You have a great weekend and, again, thanks for all of your help.
> > >
> > > Ann
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > I didn't look at the picture, but you can do this:
> > > >
> > > > Tools|customize (again, just so that dialog is visible)
> > > > rightclick on the "autofit selection"
> > > > You can change the the icon there
> > > > You can change it to the default style
> > > >
> > > > There's a few options you may want to play with.
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson