Mobile menu

Spellcheck in Excel
Thread poster: Charles Tippie

Charles Tippie  Identity Verified
United States
Local time: 18:33
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?

Direct link Reply with quote
 

Csaba Ban  Identity Verified
Hungary
Local time: 03:33
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.

Direct link Reply with quote
 

Jerzy Czopik  Identity Verified
Germany
Local time: 03:33
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


Direct link Reply with quote
 

Charles Tippie  Identity Verified
United States
Local time: 18:33
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


Direct link Reply with quote
 

Charles Tippie  Identity Verified
United States
Local time: 18:33
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


Direct link Reply with quote
 

Judy Rojas  Identity Verified
Chile
Local time: 22:33
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


Direct link Reply with quote
 

Jerzy Czopik  Identity Verified
Germany
Local time: 03:33
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


Direct link Reply with quote
 


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






WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »
SDL Trados Studio 2017 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

More info »



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