The best way is to duplicate the worksheet. That will duplicate all the cells
on a worksheet to have the same formatting.

Right click on the Sheet1 worksheet name tab,
select move or copy...
In the dialog box that appears be sure to check the box that says
create a copy and click Okay.
That will get you a duplicate copy of the worksheet with all the formatting.

Alternate Method:
Copy the range of cells on Sheet1, by selecting the whole rows
this will get you the row heights.
Place the mouse pointer over the row headers
and click and drag to bottom row then select edit - copy.
Go to Sheet2 - edit - paste
right click inside the highlighted selection,
paste special - select column widths.
That will get you all the formatting for all the selected rows.

HTH
--
Data Hog


"Robert Crandal" wrote:

I wanted to copy and paste one sheet to another sheet. The
problem is, I can't seem to copy EVERYTHING over,
including row and column heights, etc etc....

I used "Paste Special" during my paste, but it does not copy
over the row and column heights. What am I doing wrong??

thanx


.