New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Turn Formulas into the Values They Output – Another way

Free Excel Tips and Tutorials

Turn Formulas into the Values They Output – Another way

Postby pecoflyer » Tue Feb 14, 2012 10:08 am

Select the range containing the formulas of which you want to keep the values

Put your cursor against the upper boundary of the selected zone -A cross appears -

Press right button of your mouse and WHILE KEEPING THE BUTTON PRESSED move the selected range to where you need the values. ( It can be the same place you started from but you have to move a littlt).

Release the button and a menu will pop up.

Select " Copy Here as Values Only" - Done

There are also some other interesting items in this menu
You do not have the required permissions to view the files attached to this post.
A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010

Return to Excel Tips and Tutorials

Who is online

Users browsing this forum: No registered users and 24 guests