I am engineering student and use the greek symbols ('symbol font') very often in excel.
Can I have a 'symbol' font toolbar button separately, so that once I click on it, the text will be changed to appropriate geek characters.
In MS Word, the customize toolbar -> Command ->category has a separate 'Fonts' section in which I can choose any font I need as a separate button. Excel does not have this facility?
If So, how to get separate 'Symbol' font button in toolbar?
Do you want this button to simply convert the active cell to font symbol or to actually present Greek symbols like Character map?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I want the text to be changed into 'symbol' font.Originally Posted by ChemistB
Check out the jpg file for example.
Thanks
You want to insert the following macro into a moduleAlt F11This code will change all selected cells to symbol font
Insert>Module
Copy and paste this code into module screen
Close Editor (no need to save)To create an icon on your toolbar
Please Login or Register to view this content.View>Toolbars>Customize>CommandsHow'd that go?
Choose smiley face (you can modify later)
Drag to your toolbar
Rightclick on new icon>Assign Macro
CB is an appropriate geek character
Suggest this alternative:
makes a toggle (if I've done it right...)Please Login or Register to view this content.
CC
CC's answer is better as it allows you to freely toggle back and forth by clicking on the button.
How to apply it to all the spreadsheets? I would like to make it work for any excel sheet. Is it possible?CB is an appropriate geek character
Suggest this alternative:
makes a toggle (if I've done it right...)Please Login or Register to view this content.
CC
Have you tried it? It should work for any spreadsheet as it is...
CC
You would need to stick the code in either you personal.xls or more likely create an Addin.
Why not use the Font Name dropdown box. Admittedly an extra click/scroll but it is available to all spreadsheets.
Thanks! this is nice.
This code changes the entire text in a cell to symbol. Is it also possible to edit only selected characters? for example in the following gm2, where the 'g' is written as a symbol.
Thanks for helping!!
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar or even the same as this thread, we have a rule that you open your own thread on the issue and do not piggy back another member's thread.
Please see Forum Rule #1 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks