Just to add to Duke's excellent response on doing a sheet copy

for the column widths, you can also
1) copy the entire column and paste it
or
2) after pasting, immediatly do Edit=Paste Special and choose column widths
or
3) If you are copying all the information but don't want to copy the sheet,
then click in the upper left corner of the worksheet in the blank grey square
at the intersection of the row and column headers to select all the cells in
the sheet. Then copy that. When you paste in A1 of a new sheet, it will
bring the row heights and column widths as well.

The bottom line is that the column width is the property of the entire
column rather than an subset of cells in the column.

--
Regards,
Tom Ogilvy


"JoJo" wrote:

Folks:



On my spreadsheet I would sometimes like to print the row & column headings.
I can do this by going to the PAGE SETUP Sheet Tab check the "Row &
Column headings" Box.

However, because on my actual spreadsheet the first 4 rows are used for
various headings, actual data only starts at row 5.

* Is there a way to start the row numbering, not from the top but from 5
rows down ?



(2) How can I copy & paste a spreadsheet in such a way that all the
column width information is also transferred ?


(3) How do I "un-merge" a group of cells that I have merged ?


Thanks,
Jo.