display after converting lotus

[John]

After converting lotus files to excel... the outline of each cell as
dispalyed on the screen disappears to reveal a white only background.
How do I get the outline of each cell to reappear?
Thanks
John

 

[Peo Sjoblom]

You could make your own list picking the data from here

http://cherbe.free.fr/traduc_fonctions_xl97.html

make it into a table and use vlookup
I also believe Norman Harker is working on one..
Look in the newsgroups for his name and email him
and if your home is good he might send you one for free <g>

 

[Gord Dibben]

John

Could be either of two cases.

1. Tools>Options>View>Window Options. "Gridlines" is unchecked.

NOTE: this is a worksheet setting. Select all sheets before setting.

2. Cells background is set to "White". Should be "No Color" or gridlines are
hidden.

Select all sheets then CRTL + A and Format>Cells>Patterns>"No Color"

Another note: to select all sheets, right-click on one tab and "Select all
sheets".

DO NOT FORGET to "ungroup" sheets when done. Changes made to active sheet
will be done to all.

Gord Dibben Excel MVP

 

[Lady Layla]

Hi John,

Select the area in question, Go to Format Cells Pattern no color



: After converting lotus files to excel... the outline of each cell as
: dispalyed on the screen disappears to reveal a white only background.
: How do I get the outline of each cell to reappear?
: Thanks
: John

 

[Peo Sjoblom]

Sorry, wrong thread.. Was supposed to have gone in the Spanish Translations

 

[Ken Wright]

and if your home is good he might send you one for free <g>

LOL