Solved

Excel subtotal function default wordings

Posted on 2001-07-19
4
395 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
4 Comments
 
LVL 6

Expert Comment

by:bkpchs237
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
This question will be placed in PAQ and points refunded.

Best regards,
ComTech
Community Support
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now