Home » Questions » Computers [ Ask a new question ]

Adding a custom format to the format drop down menu in Excel 2007

Adding a custom format to the format drop down menu in Excel 2007

How do I add a custom format to the format drop down menu in Excel 2007? On the Home tab there is a "Number" section that has a format drop down box. Is there a way to customize the formats in that list?

Asked by: Guest | Views: 290
Total answers/comments: 1
Guest [Entry]

"First, create a macro that does what you want (see directions here). Click on the down arrow in the Quick Access Toolbar (upper-left) and choose, More Commands. Then in the first drop-down, choose Macros. Then add your macro, and say ok. Now when you click on that macro in the QAT, it will format your cell (you don't even have to have the Home Tab chosen).

When making the macro, I found that hitting the comma and then the 'less decimal places' button twice was the quickest way."