Forum Discussion
Special Paste (Values) not working
Hey guys, I have an issue with paste special where I cannot paste without formatting. - this issue only started happening today after using excel for years. - I have 2 computers on the same of...
The "Paste Special" option may not be available when you copy a row of values in Excel if the cells where you want to paste the values are not compatible with the data type of the copied cells. For example, if you copy a row of values that includes numbers and paste them into a column of cells formatted as text, the "Paste Special" option may not be available. Similarly, if you copy a row of values that includes formulas and try to paste them as values, the "Paste Special" option may not be available.
What i do is = i copy the data that i want to special paste, and i create a new worksheet in the same excel file and i can special paste in that new excel file.
And then i cut that data from the new excel sheet and paste it in the original worksheet.
Hope this helps.
What i do is = i copy the data that i want to special paste, and i create a new worksheet in the same excel file and i can special paste in that new excel file.
And then i cut that data from the new excel sheet and paste it in the original worksheet.
Hope this helps.