short cut for custom formatting

[lezawang]

Hi
I want to Right click on group of cells --> Format Cell --> Custom --> [h]:mm
So it is 3-4 click and I want to do that alot. Can I create a short cut to do these 3-4 steps in one click for example. Or Can I create a link in QAT area. Thank you very much.

 

[RoryA]

You can create a style for that and then apply it using the styles dropdown. Just FYI, Ctrl+1 takes you straight to the Format Cells dialog.

 

[lezawang]

Thank you. That helps. I never used style before. Very good idea. Thank you