different languages for different columns

  • Thread starter Thread starter kris_k
  • Start date Start date
K

kris_k

Hello,

I have a problem working on a dictionary and I'm trying to do it i
Excel.
The problem is: Insofar I'm using three different languages (and thre
different alphabets, mind you) which makes things quite complicated.
have to write in one alphabet in the first column, another in th
second and yet another (even oriented right-to-left) in the thir
column. This costs me a lot of time to change the language settings fo
each and every cell individually.
Is there any way to command Excel to save language settings fo
specific columns? I'm quite convinced that there must be a way althoug
I couldn't find it...and I've tried hard!
I hope I've made my problem understood. Thanks to anyone who could hel
me with that!!
 
How are you changing these settings?

Is it a windows setting? If yes, then I can't think of a workaround.

Are you doing:
Windows start button|Programs|MS Office XP tools|MS Office XP language settings

This is untested--but might be worth the 2 minutes for you to try.

Start excel with one language set.
change the setting
start another instance of excel
did that change the setting in the first instance? If yes, then never mind.

If no, then change the setting and start a 3rd instance.

Tile your 3 excel applications so you can see each instance. Use a column from
each.

Save each workbook and then close 2 of the instances and reopen them (via
file|open) in the first.

Copy|Paste

If you're careful about your matching your rows, it might work????

(I was too chicken to try--but I did click on that "MS Office XP language
settings" for the first time ever!)

Does that language settings stuff give you the ability to use multiple languages
at once? If yes, then ignore all this and just use that.
 
Back
Top