1) You can't change Excel's row numbers, but you can put your own row
numbers in a new column A

2) To copy an entire spreadsheet including column widths, etc, right-click
the sheet's tab and choose Move or Copy... then select where you want to copy
it

3) Unmerge by selecting the merged cells and using Format-Cells-Alignment
and unchecking the Merge cells checkbox

FWIW - most people here will tell you to avoid merging cells at almost any
cost. It screws up sorting, range selection, column widths, and who knows
what else. On that Alignment tab is an option to center a label over the
selected cells which accomplishes much that merging is used for. Also, text
boxes are a good way to enter big blocks of text on a sheet

"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.