Excel auto-fit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Use Peo's approach but select Worksheet Menu Bar (towards the end of the
list) and then do the reset.

--
Jim Rech
Excel MVP
| 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.
 
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.
 
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
 
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 - 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
 
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.
 
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
 
Had no idea about the Google group. The alt+drag did the trick! Both Word &
Excel are FREE!

Ann
 
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
 
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.
 
Back
Top