Spellcheck in Excel
Thread poster: Charles Tippie

Charles Tippie  Identity Verified
United States
Local time: 18:52
English to Spanish
+ ...
Nov 19, 2002

Im trying to spell check on column in excel and it keeps saying that the formula is too long. Has anyone had similar problems?

 

Csaba Ban  Identity Verified
Hungary
Local time: 03:52
Member (2002)
English to Hungarian
+ ...
copy and paste to Word Nov 19, 2002

When I have to run spellcheck on an xls file, I copy and paste the relevant cells into Word and do it there. Once finished, you can copy/paste it back easily into Excel.

 

Jerzy Czopik  Identity Verified
Germany
Local time: 03:52
Member (2003)
Polish to German
+ ...
Spell-check in Excel Nov 19, 2002

Even if the idea of Csaba is brillant, you can try to stay in Excel (and you must, if you have different versions of Word and Excel in your PC, ie. Word 2000 with Excel 97, as the copying of cells does not work proper then).


You have to select the column you will do spell-checking in, then via Extras select the cell formatting and define the cells as \"only text\" or \"simple text\" or \"plain text\" (I do not know the proper English name, as I use german Excell).

After that, Excell should stop to tell anything about to long fomrulas, as the program then knows, that there are no formulas in those cells.


HTH

Jerzy


 

Charles Tippie  Identity Verified
United States
Local time: 18:52
English to Spanish
+ ...
TOPIC STARTER
###### in the cell Nov 19, 2002

Jerzy,


Thank you for your help. After I followed your directions ########## appeared in the cell block. If I click on it the writing appears perfectly but Im not sure why ###### appears. Can you offer any more sugesstions?

Thank you very much.

Charles


 

Charles Tippie  Identity Verified
United States
Local time: 18:52
English to Spanish
+ ...
TOPIC STARTER
###### in the cell Nov 19, 2002

Jerzy,


Thank you for your help. After I followed your directions ########## appeared in the cell block. If I click on it the writing appears perfectly but Im not sure why ###### appears. Can you offer any more sugesstions?

Thank you very much.

Charles


 

Judy Rojas  Identity Verified
Chile
Local time: 21:52
Spanish to English
+ ...
Resize the cell Nov 19, 2002

The #### symbol appears when the cell is too small for the contents. Just resize the cell and you will be able to see the text.

HIH


 

Jerzy Czopik  Identity Verified
Germany
Local time: 03:52
Member (2003)
Polish to German
+ ...
Ricardo knew the trick Nov 19, 2002

You can either resize the cell or make the text smaller (10 points instead of 12 ie.)


Try to ask Excell\'s help - or to look for a term in help files. Microsoft help files are usually very good - I learned almost everything I know about Word and co. from help files and using those programs.


Jerzy


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Spellcheck in Excel

Advanced search






Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search