Re: including formulas in inserted columns

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Andy B (andyb_at_takethisbitout.dawsons.co.uk)
Date: 03/09/04 

Date: Tue, 9 Mar 2004 10:51:03 -0000

Melvin.

OK. Copy the whole column and paste it. Then select the pasted column and
Edit / Goto / Special / Constants. This will select all non-formulas. Hit
the delete key.

Andy.

"melvin >" <<melvin.12ujmr@excelforum-nospam.com> wrote in message
news:melvin.12ujmr@excelforum-nospam.com...
> Hi Andy,
>
> Sorry... I failed to mention the data field contains lots of values
> which I would not like to copy across and would not be easy to delete
> if they were copied across. All I want to transfer to the new column
> are formats and formulas if this is possible. I have tried copy and
> 'paste special' but this copies all data across even if I just select
> formulas and formats!
>
> cheers
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Relevant Pages

  • Re: Pivot Table & 0
    ... > Hi Andy, ... I'm pulling it through from a SQL table and the formats ... > Thanks Again, Phil ... >> Try doing a Count in the pivot table and see if that returns anything. ...
    (microsoft.public.excel.misc)
  • Re: Zip component for .zip, .rar, .7zip, etc.
    ... It gave me some ideas on exploring ... "Andy" wrote in message ... like .zip, .rar, .7zip, etc. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Zip component for .zip, .rar, .7zip, etc.
    ... Andy wrote: ... formats like .zip, .rar, .7zip, etc. ... mentioned formats. ...
    (borland.public.delphi.thirdpartytools.general)