+ Reply to Thread
Results 1 to 4 of 4

How to turn formula cells into fixed values

  1. 12-31-2016, 10:06 AM #1
    Triggaaar
    Triggaaar is offline
    Registered User
    Join Date
    12-31-2016
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    2

    How to turn formula cells into fixed values

    Hi all

    I'm creating a one off spreadsheet. I want to use a lot of data and some formulas to create results.
    I then want to remove the data (not just hide) and keep the results.

    Is it possible to make the results that were created with formulas fixed, so that removing the data doesn't change the results?


    Thanks
    Reply With QuoteRegister To Reply
  2. 12-31-2016, 10:17 AM #2
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: How to turn formula cells into fixed values

    Select the formulas

    Right click>Copy
    Right click>Paste Special>Values>OK
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  3. 12-31-2016, 10:55 AM #3
    Triggaaar
    Triggaaar is offline
    Registered User
    Join Date
    12-31-2016
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    2

    Re: How to turn formula cells into fixed values

    Quote Originally Posted by Tony Valko View Post
    Select the formulas

    Right click>Copy
    Right click>Paste Special>Values>OK
    Genius.

    Thank you very much, you've saved me a chunk of time.
    Reply With QuoteRegister To Reply
  4. 12-31-2016, 10:59 AM #4
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: How to turn formula cells into fixed values

    You're welcome. Thanks for the feedback!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Select Cells Individually, Fixed Columns, Fixed Rows, Every Other Row
    By ZooTV92 in forum Excel General
    Replies: 13
    Last Post: 10-13-2015, 04:17 AM
  2. [SOLVED] Macro to turn color cells for certain dates and to input cell with values
    By mark888 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-24-2015, 09:00 PM
  3. Subtracttion from a fixed cell Using Horizontal Values and Results in Vertical Cells
    By angirasv in forum Excel General
    Replies: 2
    Last Post: 11-11-2014, 06:41 AM
  4. Formula to find average of values between negative values in 'random' array of fixed size
    By zorba457773434 in forum Excel General
    Replies: 13
    Last Post: 10-08-2014, 08:35 AM
  5. Counting formula to sum values over a fixed interval
    By aart008 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-08-2014, 02:50 AM
  6. Formula with 2 variables and 2 fixed values
    By amenasce in forum Excel General
    Replies: 9
    Last Post: 03-14-2011, 08:43 PM
  7. Multiplying cells by various fixed values...
    By ChrisMattock in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-12-2007, 09:16 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1