Solved

Excel subtotal function default wordings

Posted on 2001-07-19
4
400 Views
Last Modified: 2006-11-17
In Excel's Data-> subtotal function, can the default wording of "subtotal" be changed?  In the Chinese Excel 97 version, the default wording is a Chinese word "subtotal" which cannot the changed.  The same problem exist in the pivot table function, the default wording is a Chinese word "total" which I cannot change the default as well.  I really don't like these default Chinese wordings.

Do anyone know how to change these default wordings?

Thanks a lot.

0
Comment
Question by:queeniewu
[X]
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
4 Comments
 
LVL 6

Expert Comment

by:bkpchs237
ID: 6302594
queeniewu,

Go to Tools, Customize this will give you access to edit your menu items.  Be careful what you do here because you are now able to add and DELETE items as well.  Click on Data, then right-click on the Subtotals menu item.  You'll see a line called "Name" with a white box that should read: Su&btotals...  which is for the word Subtotals... on the menu and the hot key of the letter b.  Edit as you see fit.

Hope this helps.
0
 

Author Comment

by:queeniewu
ID: 6310768
bkpchs237

Thanks for your response.  I am sorry that I need to change the default wordings in the result as well, not only the wordings on the tool bar menu.

The default result gives me the word subtotal in Chinese.  Everytime I need to change all these default result's wordings into something else.

The same problem happen in the pivot table result.  The default result is a word Total in Chinese which I have to change it as well.  Having all the column & row name in English but only the last row "total" in Chinese gives me a very ugly pivot table result.  

May be these default result's wording cannot be changed...
0
 

Expert Comment

by:costello
ID: 6415740
If no objections are made in the next 5 days, I will reduce points to 0, refund them, and PAQ this question.

costello
Community Support Moderator @ Experts-Exchange

P.S. This post is made as part of the general effort to clean up this topic area, meaning, looping through all the open questions with no activity since 21 days.
0
 

Accepted Solution

by:
ComTech earned 0 total points
ID: 6690891
This question will be placed in PAQ and points refunded.

Best regards,
ComTech
Community Support
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....
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

726 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