How can I remove a formula from an entire column?

M

ManhattanRebel

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
 
T

Teethless mama

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF formula, Partial word, SUM function as result 1
Create One Formula for Entire Column 1
Create Generic Formula for Entire Column 1
Help needed 0
Remove punctuation mark, Split cells & average accross column 4
replaces formula to its value 2
Copying formulas across columns 2
Excel Calculation Result Display Failure 4

Top