| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and paste color
I have a document that is protected and I have managed to put formulas on
certain cells with a background color. When my worker copies and pastes the information into a new document since the cells she is copying are in color they paste in color is there any way where when she copies and pastes she only paste the numbers or data instead of the color of the cell? Thanks, -Sophie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy and paste color
Paste values only
"Sophie" wrote: I have a document that is protected and I have managed to put formulas on certain cells with a background color. When my worker copies and pastes the information into a new document since the cells she is copying are in color they paste in color is there any way where when she copies and pastes she only paste the numbers or data instead of the color of the cell? Thanks, -Sophie |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy and paste color
So is there a way that when I protect my sheet in excel I can set for the
worker to copy and automatically set for it to paste the values only or will they have to do this? "Steve" wrote: Paste values only "Sophie" wrote: I have a document that is protected and I have managed to put formulas on certain cells with a background color. When my worker copies and pastes the information into a new document since the cells she is copying are in color they paste in color is there any way where when she copies and pastes she only paste the numbers or data instead of the color of the cell? Thanks, -Sophie |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy and paste color
Copy then Paste SpecialValues
Gord Dibben MS Excel MVP On Thu, 11 Feb 2010 13:27:02 -0800, Sophie wrote: I have a document that is protected and I have managed to put formulas on certain cells with a background color. When my worker copies and pastes the information into a new document since the cells she is copying are in color they paste in color is there any way where when she copies and pastes she only paste the numbers or data instead of the color of the cell? Thanks, -Sophie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| copy/paste from excel to word including cell color | Excel Discussion (Misc queries) | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| How to Paste Link a cell with color and maintain the color | Excel Discussion (Misc queries) | |||
| I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
Linear Mode
