In Office 2000.

I have a spreadsheet, and I open another instance of Excel. In the first
spreadsheet I select some rows and columns and copy them. I then paste them
in the second spreadsheet.

The values copy, but the format and formulas do not.

Paste - Special gives me options to paste in the range of cells as an image.

So how do I copy the formulas from one spreadsheet to another?