short cut for custom formatting

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,559
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.
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,828
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
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

Well-known Member
Joined
Mar 27, 2016
Messages
1,559
Thank you. That helps. I never used style before. Very good idea. Thank you
 

Watch MrExcel Video

Forum statistics

Threads
1,096,451
Messages
5,450,534
Members
405,615
Latest member
patrickmm

This Week's Hot Topics

Top