If you want a duplicate of a worksheet, for more efficient to right click on
the tab name and choose Move or Copy, Create a Copy.

Better and quicker yet, hold down the Ctrl key, click and drag the worksheet
tab to a new location. Doing so creates a copy of the sheet.

If you click on the intersection of the row and column headers in 2007, you
are selecting a million rows by ?? columns = hundreds of millions of cells,
maybe more. That's a lot to copy.

"SallyGirl" wrote:

I was just upgraded from Excel 2003 to excel 2007. When I copy and paste a
sheet using the tab between colum A and Row 1 I encounter the following
problems. What am I doing wrong.
1. I get an error message that reads "Excel cannot complete this task with
available resources. What I am copying is usually very little information
not complex formulas.
2.When I select the data to copy and paste into another sheet it will not
transfer my colum and row widths and heights.

Is there something that I am doing wrong. I never had these issues with 2003.