Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Here is what I would like to be able to do. This is really a
formatting/presentation issue: Lets say I have A1:C5 selected, which represent headdings and data for jan, feb and march. I want to do an auto fit for each column, so that the column widths are big enough to fit the numbers. No problem, format--column--autofit and I'm done. But once that is done (for example), the width of column A is 15, column B is 7 and column C is 13. When you print the spreadsheet, it will look much better if all the column widths are the same. So, since column A is the largest, I would want all three columns sized to 15. So, essentially I would like a macro that looks at the selection, does and autofit on the column widths and then makes all three columns the same width as the largest column. Ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Editing a simple macro | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |