All I want to do is copy from one Excel spreadsheet to another and the values remain instead of having to copy and literally manually rewrite over every single value.
It's like the most rudimentary Excel function. Why is it so hard?
Also, why can't you select more than one cell and just press delete? Why does Excel not wok online?
@georgia_Halston , if you mean to select non-adjacent cells - yes, that doesn't work. If continuous range - no problem with that.
@Sergei Baklan nope, I mean any cells the attached for example. When you paste it into another workbook, non of the formulas work, they don't see them as real numbers.
@georgia_Halston , strange, no problems with Ctrl+C/Ctrl+V of numbers.
@Sergei Baklan that's what I'm doing, but from one workbook to another, it doesn't understand numbers, the same if you copy from an Excel sheet on desktop.
@georgia_Halston , could you attache small sample file?