I'd copy and paste just like you did.
Then with the pasted range still selected, you can hit:
edit|goto|special|click constants and ok
(notice the change in selection)
Then hit the delete key on the keyboard to clear those cells.



buddyorliz wrote:

I need to copy the formulas, format etc.. from one sheet to another sheet,
but I do not all the text (data I have put in for the previous month.

I have been, using copy and paste But then I'm having to clear Each cell
that is used to do all the calculations (sometimes there are over 200).

I do not use any calculations based on previous sheets (as far as like
adding something from one page to another for totals)

Just want to use that one sheet - blank - to start my new month.

Thanks to anyone that can make this easier for me.
Liz

--

Dave Peterson