PC Review


Reply
Thread Tools Rate Thread

Changing Formulars to results

 
 
Randall
Guest
Posts: n/a
 
      14th Nov 2003

How do i change an entire Sheet from formulars to the results.

I have links to databases etc, and want to send my spreadsheet t
another user on a different system.

How do i do this please

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

 
Reply With Quote
 
 
 
 
cmoore
Guest
Posts: n/a
 
      14th Nov 2003

First make sure you have a backup copy of the file

Select everything on the sheet (Control + A)

Go to Edit/Copy

Go to Edit/ Paste Special

Select Values

Hit OK

This will replace all the information on the sheet with the values.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

 
Reply With Quote
 
Randall
Guest
Posts: n/a
 
      14th Nov 2003

Thank you

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
formulars =?Utf-8?B?am5m?= Microsoft Excel Worksheet Functions 4 25th Mar 2006 12:05 AM
need help with formulars =?Utf-8?B?Z3JlZW5mcm9n?= Microsoft Excel Misc 2 19th Jan 2006 07:56 PM
Formulars med211 Microsoft Excel Worksheet Functions 1 25th Jan 2005 02:34 PM
formulars ian.fraser@dti.gsi.gov Microsoft Excel Worksheet Functions 3 4th Nov 2003 07:52 PM
Formulars Peter Microsoft Excel Worksheet Functions 5 22nd Aug 2003 03:39 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:34 PM.