Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste Special - Values
I have one column with hundreds of rows of different values that need to have
paste special values in each cell next to them as all formulas will be removed in another copy of the excel file. Is there was to achieve this without having to paste special every individual cell (can't seem to find anything about this type of thing). Thanks in advance. Rgds KYMO |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste Special - Values
Just found how to do :)
dumb question it twas :( "KYMO" wrote: I have one column with hundreds of rows of different values that need to have paste special values in each cell next to them as all formulas will be removed in another copy of the excel file. Is there was to achieve this without having to paste special every individual cell (can't seem to find anything about this type of thing). Thanks in advance. Rgds KYMO |
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) | |||
paste special values | Excel Worksheet Functions | |||
Paste Special - Values - Transpose | Excel Worksheet Functions | |||
Paste special in Excel 2002 | Excel Discussion (Misc queries) | |||
Paste Special | Excel Discussion (Misc queries) |