How can I remove a formula from an entire column?

's Computer Specifications

Using F2 and F9, I am able to remove a formula from a cell, but how can I do
it for an entire column of numbers? Tks, mr

's Computer Specifications

Select your range > right click Copy > right click Paste Special > Values >
OK out

"ManhattanRebel" wrote:

> Using F2 and F9, I am able to remove a formula from a cell, but how can I do
> it for an entire column of numbers? Tks, mr

's Computer Specifications

Thank you..that works

"Teethless mama" wrote:

> Select your range > right click Copy > right click Paste Special > Values >
> OK out
>
>
> "ManhattanRebel" wrote:
>
> > Using F2 and F9, I am able to remove a formula from a cell, but how can I do
> > it for an entire column of numbers? Tks, mr

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula not getting copied to entire column	theacegary	General Software	0	27th Nov 2010 07:36 PM
enter formula once for entire column	=?Utf-8?B?c2hlZXBkaXZlcg==?=	Microsoft Excel Worksheet Functions	1	9th Oct 2006 09:26 PM
Applying a formula to an entire column	=?Utf-8?B?QXVkcmV5?=	Microsoft Excel Misc	3	20th Apr 2006 07:26 PM
apply formula to entire column	vauneen	Microsoft Excel Worksheet Functions	2	20th Nov 2003 12:31 PM
Remove hyperlinks in an entire column in excel	Christian	Microsoft Excel Misc	2	16th Sep 2003 02:11 AM