Pasting Hard Coded Number Only from within a range.

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

Is there a way to highlight a range and paste the range such that i
will only paste the cells which do not have formulas? That is if
highlight range A1:A10, I want to be able to paste the entire range t
a new sheet, but I do not want the values within the range that ar
driven from formulas. The catch here is that I want to preserve th
original range. So in the range A1:A10, if only A2;A5 have hard code
numbers, then I want A1, A6:A10 to have no values after the paste

I am rebuilding a spreadsheet from scratch and want to preserve th
hard coded values and reinsert a new formula for the cells which tak
formulas.

Thank
 
I'm not sure if I understand, but if you're pasting to an unused range, maybe:

Copy A1:A10 of sheet1 (say)
paste into c9:c18 of sheet2 (say)

Now select your range (c9:c18)
Edit|goto|Click Special
Now you can click on Constants and hit ok.
Now just the constants are selected.
Hit the Delete key to clear that selection.

But I wasn't sure what was the original range and what was the pasted range.

But you can do the same thing with the Formulas, too.
 
Back
Top