| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste special from cells without formulas/formats
I want to copy a column in which certain cells have formulas and/or
formatting applied, and paste it to an adjacent column which has just been added to the sheet. However, when I choose 'Paste Special' 'Formulas and number formats', I find that values from cells which contain only data are pasted into the adjacent cell, i.e. it is not just 'Formulas and number formats' which get pasted. Is there a way around this, other than copying and pasting one-by-one the cells which have formulas and/or formatting applied? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Paste special from cells without formulas/formats
Spartacus,
Any plans on leading an Excel-slave revolt? ;-) After you complete the steps that you descibe, use Edit / Go To.... Special Constants, OK and then press Delete. HTH, Bernie MS Excel MVP "Spartacus" wrote in message ... I want to copy a column in which certain cells have formulas and/or formatting applied, and paste it to an adjacent column which has just been added to the sheet. However, when I choose 'Paste Special' 'Formulas and number formats', I find that values from cells which contain only data are pasted into the adjacent cell, i.e. it is not just 'Formulas and number formats' which get pasted. Is there a way around this, other than copying and pasting one-by-one the cells which have formulas and/or formatting applied? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Paste special from cells without formulas/formats
Dear Bernie,
"I am not an animal!" ;^D Fanatastic answer - exactly what I was after; many thanks. Spartacus R "Bernie Deitrick" wrote: Spartacus, Any plans on leading an Excel-slave revolt? ;-) After you complete the steps that you descibe, use Edit / Go To.... Special Constants, OK and then press Delete. HTH, Bernie MS Excel MVP "Spartacus" wrote in message ... I want to copy a column in which certain cells have formulas and/or formatting applied, and paste it to an adjacent column which has just been added to the sheet. However, when I choose 'Paste Special' 'Formulas and number formats', I find that values from cells which contain only data are pasted into the adjacent cell, i.e. it is not just 'Formulas and number formats' which get pasted. Is there a way around this, other than copying and pasting one-by-one the cells which have formulas and/or formatting applied? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formats-Paste special | Excel Discussion (Misc queries) | |||
| Conditional formats- paste special formats? | Excel Discussion (Misc queries) | |||
| Paste Special - Formulas - Add | Excel Worksheet Functions | |||
| Excel - Need to paste special formats only bold | Excel Discussion (Misc queries) | |||
| Paste Special Formats Generated by Conditional Formatting | Excel Discussion (Misc queries) | |||
Hybrid Mode
