Ask Experts Questions for FREE Help !
Ask
    smokedetector's Avatar
    smokedetector Posts: 368, Reputation: 56
    Full Member
    		  
    #1

    Jan 18, 2010, 07:53 PM
    excel
    I referenced a group of data from one sheet to another in the same workbook. I plan on deleting some of the information I referenced as it becomes out of date, but it will screw up my formatting in the new sheet if it updates with the referenced cells. Is there a way I can make the information in the new sheets keep the values it has now and make it unreference the sheet I plan to edit?

    ~~~~~~~~~~~~~~edit~~~~~~~~~~~~~~~
    If not, I will just hide the information instead of deleting it, but I'd rather do it this way.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Jan 18, 2010, 08:00 PM

    Copy and use Paste special to paste the value of the formula.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to connect one excel sheet to other excel sheet [ 28 Answers ]

How to connect one excel sheet to other excel sheet.

About Excel [ 1 Answers ]

How much of Excel do you need to know to be considered proficient in it? In particular how many function do you need to know?

Excel 2007 to have excel 2003 look? [ 6 Answers ]

Hey I have Microsoft Excel 2007, from my course at college I have been given instructions to do a task. However these instructions are for excel 2003. How do I change my excel 07 to look like excel 03 so that it is easier. I know there is a way, help greatly appreicated thanks.

How to get better with Excel [ 2 Answers ]

My Vietnamese staff and I use Excel all the time, but we're limited to very basic stuff. Can anyone recommend an easy and comprehensive how-to reference, either book form (which we would have to order by mail) or on-line info? Thanks. -- Chuck Searcy, Hanoi

Excel [ 2 Answers ]

:rolleyes: I try to use excel to print an invoice, how can I put an invoice number that will auto upadate the next time I use the file?

View more questions Search