?
Solved

Excel subtotal function default wordings

Posted on 2001-07-19
4
Medium Priority
?
406 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
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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
MS Outlook undoubtedly is the most widely used email client.Its user-friendliness, cost effectiveness, and availability with Microsoft Office Suite make it the most popular email application.  Its compatibility with Microsoft applications like Exch…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

809 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