Automating Text to be formated a certain way.

[Legacy 338295]

Hello. I have a question...if i want to create a custom format where text is center aligned, middle aligned, and applying text wrap when info is created into the cell how do i do that? i'm trying to automate it to do this. Also, how can I automate when info gets inserted into a cell the information gets sent to the top of the column? I know how to do this manually, I just need to learn a formula that can automate it. Thanks.

 

[cooper645]

You could record a macro that selects the entire worksheet and formats the text and alignment and wrapping - and then assign it to a command button in the top corner of the worksheet, which would speed things up a bit.

You can also record a macro to move the data, if it always goes from the same cell on insertion to the top of the same column - and then assign this macro to another button.

alternatively you could put it all in one macro and one button

 

[Legacy 338295]

You could record a macro that selects the entire worksheet and formats the text and alignment and wrapping - and then assign it to a command button in the top corner of the worksheet, which would speed things up a bit.

You can also record a macro to move the data, if it always goes from the same cell on insertion to the top of the same column - and then assign this macro to another button.

alternatively you could put it all in one macro and one button

Is there any other way without using macro? Is there a formula or a function I can use?

 

[cooper645]

I don't believe so, conditional formatting may possibly go some way to help but I don't think you can change the actual font