Changing a linked cell to a constant value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karl Clauset - 26 Aug 2005 07:13 GMT

I have sorted a database and analyzed a subset of records to calculate
average values. I want to save these averages on another spreadsheet
in the workbook. How do I paste the numbers without pasting the cell
references? I need to resort the database to do other calculations.

Reply to this Message

Barry Wainwright - 26 Aug 2005 10:49 GMT

On 26/8/05 07:13, in article
1125036809.070541.293840@g49g2000cwa.googlegroups.com, "Karl Clauset"
<khclauset@comcast.net> wrote:

> I have sorted a database and analyzed a subset of records to calculate
> average values. I want to save these averages on another spreadsheet
> in the workbook. How do I paste the numbers without pasting the cell
> references? I need to resort the database to do other calculations.

'Paste Special...' -- 'Values'

Signature

Barry Wainwright
Microsoft MVP (see http://mvp.support.microsoft.com for details)
Seen the All-New Entourage Help Pages? - Check them out:
<http://www.entourage.mvps.org/>

Reply to this Message

Mac Forum / Applications / Excel / August 2005

Changing a linked cell to a constant value