How align text by using shortcut keys

[arool.m]

Hi,

my name is Arulmohan

Its possible to align text in Left,Right & Centre by using formula

 

[Domski]

Hi Arulmohan,

You can't do this with formula but it should be quite straightforward to write a VBA routine to achieve what you want.

Can you be more specific about what critieria you want to use to decide the appropriate alignment.

Dom

 

[Stormseed]

In elementary Excel it is not possible using a formula.

However, if you are good with the keyboard then use the shortcut keys:

Select or highlight the cell range to be indented:

Press Ctrl+1 --> A --> Alt+H --> Select Indentation --> Enter --> Enter.

 

[arool.m]

IS THERE IS ANY SHORTCUT KEY
FOR ALIGN TEXT LEFT, RIGHT, CENTRE

 

[Domski]

Nope. A full list of keyboard shortcuts can be found by entering 'Keyboard shortcuts' into the Excel help search box.

Dom

PS It's polite not to use capitals when typing a message. It makes it look like you're SHOUTING.