?
Solved

Excel subtotal function default wordings

Posted on 2001-07-19
4
Medium Priority
?
402 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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

762 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