but I want to leave the formulas in the cells intact. Can this be done? Thanks for any help
S Skip Nov 4, 2009 #1 but I want to leave the formulas in the cells intact. Can this be done? Thanks for any help
G Glenn Nov 4, 2009 #2 Skip said: but I want to leave the formulas in the cells intact. Can this be done? Thanks for any help Click to expand... Maybe this is what you want. Select the entire range of cells. Edit / Go To / Special... / Constants / OK / Delete If not, provide more details.
Skip said: but I want to leave the formulas in the cells intact. Can this be done? Thanks for any help Click to expand... Maybe this is what you want. Select the entire range of cells. Edit / Go To / Special... / Constants / OK / Delete If not, provide more details.
S Skip Nov 6, 2009 #3 Maybe this is what you want. Select the entire range of cells. Edit / Go To / Special... / Constants / OK /Delete If not, provide more details. Click to expand... Glenn< I tried your idea, no luck. I got a no cell selected box. Skip
Maybe this is what you want. Select the entire range of cells. Edit / Go To / Special... / Constants / OK /Delete If not, provide more details. Click to expand... Glenn< I tried your idea, no luck. I got a no cell selected box. Skip
G Glenn Nov 6, 2009 #4 Skip said: Glenn< I tried your idea, no luck. I got a no cell selected box. Skip Click to expand... Then try my other suggestion.
Skip said: Glenn< I tried your idea, no luck. I got a no cell selected box. Skip Click to expand... Then try my other suggestion.
S Skip Nov 6, 2009 #5 Then try my other suggestion.- Click to expand... I am sorry, what is your other idea?
G Glenn Nov 6, 2009 #6 Skip said: I am sorry, what is your other idea? Click to expand... "provide more details"
