Mac Forum / Applications / Excel / December 2006

On 12/20/06 8:28 PM, in article
1166675336.555195.290760@73g2000cwn.googlegroups.com, "Geoff Lilley"
<ruthlesslightning@gmail.com> wrote:

Thanks Geoff: just like you last help, the clear formatting should be what I
should have done right from the start. I have to keep remembering that with
Excel everything is formatting.  (which is hard to remember sometimes, when
you are not doing much formatting)

I don't believe there are formulas here. But I will say that this file is
sent abroad to India, where they add keywords etc. So they maybe put crap in
here that make for irrational things to happen? How do I clear this stuff
(or formulas out?) if it's even there.

Thanks Phil:
I "think" I may have this ok with the edit, clear formats, but if I do the
paste special, which I've never done before, is that to clear out formulas
that my be there you don't know about? And you should then paste in
everything except with word formula or values. Is that the idea: paste in:
Only formats, comments, valaidation(what is that?), column widths.

(yes the font was set to white in those screwed up columns thanks)

OS 10.4.7
Office 2004

I've had another idea.

Are there any formulae in your spreadsheet?  If not:

Select all of your "problem" spreadsheet (command-A).
Copy the contents (command-C).
Open a new, fresh sheet.
Go to cell A1.
Go to edit-paste special, then select VALUES.

Dump the "problem" spreadsheet and save the new one.

If there are formulae:
Open a new, fresh sheet.
Select all of your new, fresh sheet (command-A).
Copy the contents (command-C).
Open your "problem" spreadsheet.
Go to cell A1.
Go to edit-paste special, then select FORMAT.

Dump the fresh sheet and save your "problem" one.

PhilD

--
<><