| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to insert an Auto Fit Width button at the tool
Hi,
Thanks for your reply. Low -- A36B58K641 "FSt1" wrote: hi there isn't a built in icon for auto fit. there is one of manual fit. auto fit is usually done you placing the mouse pointer on the column header row on the right line of the column you want to fit. the mouse pointer will change to a vertical line with arrows on both sides pointing out. double click to auto fit. but if you want an icon, you can attach this macro to your button. just select the column you want to autofit then click the button. sub autofitcolumn() selection.entirecolumn.autofit end sub regards FSt1 "Mr. Low" wrote: Hi, I try to customise my tool basr with the above button, but could not find this option under the customisez selection Format Column Width Auto Fit. Can anybody help me on this ? Thanks Low -- A36B58K641 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: Any button to insert blank rows at specific interval? | Excel Discussion (Misc queries) | |||
| Insert select button on excel worksheet to auto transfer data. | Excel Worksheet Functions | |||
| Excel 2002 : How to set thousand separator at tool bar ? | Excel Discussion (Misc queries) | |||
| Add a formated date button for Excel 2002 tool bar | Excel Discussion (Misc queries) | |||
| Excel 2002: Format Cell Height/Width | Excel Discussion (Misc queries) | |||
Threaded Mode
