Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Add Excel custom format to QAT?

Posted on 2014-03-10
3
406 Views
Last Modified: 2014-03-10
hi Folks
Hope you are well. I have a customer who constantly uses the following format in Excel..


So she goes in every time and highlights her cells and uses Format Cells - Custom
and changes #,##0.00;[Red]-#,##0.00 to #,##0.00;[Red](#,##0.00).
 I wonder if there is a more elegant way to do this...so I was wondering about (a) adding it to her QAT and how that would be done...(unless via a macro) or someway to customise her startup file...

Thanks as always for your help
0
Comment
Question by:agwalsh
3 Comments
 
LVL 50

Assisted Solution

by:Rgonzo1971
Rgonzo1971 earned 250 total points
ID: 39917077
Hi,

You could create a custom style

to use it in different workbook see Merge styles in the ref

http://office.microsoft.com/en-us/excel-help/using-styles-in-excel-HA001110199.aspx

Regards
0
 
LVL 19

Accepted Solution

by:
regmigrant earned 250 total points
ID: 39917101
as rgonzo says plus - once created it can be added as a quick style in the format ribbon and if she saves the workbook with the custom style as a template in Xlstart she will have it available to new workbooks as she opens them
0
 

Author Closing Comment

by:agwalsh
ID: 39917123
Thanks...a good solid short-term solution and a more elegant long-term one with the XLSTart.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question