| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the cells with formula into the resulting answer
I want to change a column that was created as a result of a simple summary
formula now into a column with just the answers. The reason is I now want to delete the columns that are the source and have only the answer on my spreadsheet. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the cells with formula into the resulting answer
hi
copy the column with the summary formula then in the same column... pastespecial values. this will turn the formaula into had data. source data no longer needed. Regards FSt1. "Janet E" wrote: I want to change a column that was created as a result of a simple summary formula now into a column with just the answers. The reason is I now want to delete the columns that are the source and have only the answer on my spreadsheet. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the cells with formula into the resulting answer
Hi Janet,
FSt1 has already provided a good answer. Sometimes I prefer to keep both my formulas and my "Paste Special Values" column in the spreadsheet, but simply hide the column with the formulas after doing the PSV. Cheers, Matt "Janet E" wrote: I want to change a column that was created as a result of a simple summary formula now into a column with just the answers. The reason is I now want to delete the columns that are the source and have only the answer on my spreadsheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Only Cells with positive answer to IF formula | Excel Discussion (Misc queries) | |||
| auto change cell text colour resulting from a condition | Excel Worksheet Functions | |||
| change format of cells (bold, italic) based on one cell's answer | Excel Discussion (Misc queries) | |||
| HOW TO: In a formula, how to change the format of the resulting te | Excel Worksheet Functions | |||
| how can i create a formula or format the cells so the answer is a. | Excel Discussion (Misc queries) | |||
Linear Mode
