• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 407
  • Last Modified:

Excel subtotal function default wordings

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.

1 Solution

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.
queeniewuAuthor Commented:

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...
If no objections are made in the next 5 days, I will reduce points to 0, refund them, and PAQ this question.

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.
This question will be placed in PAQ and points refunded.

Best regards,
Community Support
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now