MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Icon for convetring formulas to values


Posted by Dee on November 14, 2001 11:39 AM

I understand there's an icon I can add to my toolbar that calls for converting formulas to values. Where can I find it & how can I add it to my toolbar?


Posted by Juan Pablo on November 14, 2001 11:41 AM

Right click in any toolbar, choose customize. Now go to commands, in the categories, choose "Edit", there, look for "Paste values" icon, drag it to a toolbar and position it wherever you want, click Ok. There are also some icons for "Paste format", and "Paste Special".

Juan Pablo

Posted by Dee on November 14, 2001 12:05 PM

Posted by Dee on November 14, 2001 12:06 PM

Thank you for your prompt & informative answer to my question.