Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofit to contents
Is there a way to format an Excel worksheet to "autofit to contents" the way
it works in a Word table? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofit to contents
Format-Row-AutoFIt
Format-Column-AutoFIt "Donna" wrote: Is there a way to format an Excel worksheet to "autofit to contents" the way it works in a Word table? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofit to contents
Do you mean to adjust the width? Not that I know of. Would have to build
code to handle that. You can set cell Format/Alignment property to wrap text and the row height will expand to acommodate the wrapped text. "Donna" wrote: Is there a way to format an Excel worksheet to "autofit to contents" the way it works in a Word table? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofit to contents
I thought Donna meant to have this adjustment occur without any action by
user. Of course you can select the columns and use Format settings manually, to automate would require VBA or macro. "June7" wrote: Do you mean to adjust the width? Not that I know of. Would have to build code to handle that. You can set cell Format/Alignment property to wrap text and the row height will expand to acommodate the wrapped text. "Donna" wrote: Is there a way to format an Excel worksheet to "autofit to contents" the way it works in a Word table? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofit to contents
Yes, I meant to have it do it automatically without the user having to know
how to do anything. In Word, the field grows as the entries get larger. Thanks for your ideas about a macro or VBA. "June7" wrote: I thought Donna meant to have this adjustment occur without any action by user. Of course you can select the columns and use Format settings manually, to automate would require VBA or macro. "June7" wrote: Do you mean to adjust the width? Not that I know of. Would have to build code to handle that. You can set cell Format/Alignment property to wrap text and the row height will expand to acommodate the wrapped text. "Donna" wrote: Is there a way to format an Excel worksheet to "autofit to contents" the way it works in a Word table? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofit (Columns.EntireColumn.AutoFit) does not work | Excel Discussion (Misc queries) | |||
autofit cell height and width to match bitmap contents | Excel Worksheet Functions | |||
compare the contents of one range of cells with the contents of a. | Excel Discussion (Misc queries) | |||
Autofit didn't work to adjust row height to fit wrapped contents | Excel Discussion (Misc queries) | |||
Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) |