| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I fix values in cells calculated by formula in Excel
I have been given a very large spreadsheet I want to manipulate but most of
the cells have values created by formulas and I'm having difficulty moving and rearranging rows without losing data. It would be helpful if I could just freeze the values in the cells and then move the data around. I can't find a simple way of doing this - can anyone help please? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I fix values in cells calculated by formula in Excel
This might work for you:
1. Select all of your data 2. Edit -- Copy 3. Move to a new blank worksheet (or unused area of same worksheet) 4. Edit -- Paste Special 5. Select "Values" 6. OK HTH, Elkar "Leigh" wrote: I have been given a very large spreadsheet I want to manipulate but most of the cells have values created by formulas and I'm having difficulty moving and rearranging rows without losing data. It would be helpful if I could just freeze the values in the cells and then move the data around. I can't find a simple way of doing this - can anyone help please? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| in excel, formula to work only when all cells full of data | New Users to Excel | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| How can I get excel to ignore formula in dependant cells... | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
