Hello!
While typing in the same cell, I've to keep changing between two fonts. I wonder how it could be done with two shortcut keys.
Thank you!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Toggle Fonts
0
Discussion
Usually you wouldn't want to do this and Im not yet certain how useful/practical this would be, but would you be willing to use a macro to do it?
don (rep: 1989) Apr 25, '18 at 5:50 am
The same cell demands Nepali and English fonts. I tried recording macro but it was useful for different cells, not in the same.
Best would be without macro because not all the time we use macro enabled file. But if not possible, vba coding is also appreciated.
Thanks for your response.
Best would be without macro because not all the time we use macro enabled file. But if not possible, vba coding is also appreciated.
Thanks for your response.
Chhabi Acharya (rep: 111) Apr 25, '18 at 6:00 am
Answers
1
Selected Answer
Edited:
The best solution (as per my purpose) I've found recently is downloading Unicode Nepali (Devanagari) font from here (original site) or direct link After installation, Ctrl+Shift changes the script and the same combination changes into the normal font. With this, all mathematical and formulaic processes are possible.
Previous answer:
Very bad solution (2/5 rating for my purpose) I got through is installing offline application GoogleInputToolsHindi (Hindi and Nepali scripts are both Devanagari) instructed in this site.
Discussion
Sorry we could be of more help. This is definitely not a standard thing to do in Excel, as you found out. I will go ahead and select this post as the answer since it worked for you.
don (rep: 1989) May 22, '18 at 8:29 am
I'm grateful to you.
Chhabi Acharya (rep: 111) May 23, '18 at 6:29 am
0
Chhabi, you are trying to use a Word concept in an Excel file. Change the application or the concept.
Excel is a numbers application with some explanations next to the numbers. Word is a text manipulation application. See the difference? I know that understanding the problem doesn't solve it but you can stop banging your head on the keyboard lol:.
Start with Excel's requirement to have a single language in a cell, end with your requirement to have two descriptions in a cell, and you invariably reach the conclusion that you shouldn't enter your descriptions in the sheet you want to show. Therefore you design a concept by which you enter your descriptions in another sheet, one which you don't show to the viewer.
The sheet you show to the viewer is created from the sheet or sheets where you enter the data either using formulas or VBA (I don't think you can do it with formulas.)
Discussion
Thank you very much for your suggestions. Sometimes we may demand more than what excel can provide us. I guess it is common to the beginners like me.
Chhabi Acharya (rep: 111) Apr 26, '18 at 9:30 pm