excel function

D

Dick

In Excel is there anything like the Range Value command in
Lotus which I used to blow away a range of cells' formulae
while leaving behind in the cells the latest values
provided by the formulae?
 
G

Gord Dibben

Dick

Select your range then Copy>Paste Special>Values

Gord Dibben Excel MVP XL2002
 

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

Newbie Help - IF Yes No Function 0
Excel - Wich Function should I use? 1
Word macro that can call cells out of Excel for a find and replace 0
Autonumber field in Excel that behaves the same as Access 0
Match table shading (color) to Visio color/Transparency 1
Use TODAY() function as the criteria in a SUMIF formula 1
Merging from an Excel file with graphics 1
IF AND Function Date Range Issues 6

Top