One way would be to copy the entire sheet and delete the parts
from the copy that you don't want.

If you just use Copy (Ctrl+C) and then paste, you are not
picking up column width for example.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Fadi Chalouhi" wrote in message ...
Hi Kitty, JulieD,

I think I understand what Kitty means : what you do a sort on an excel
table, the format actually moves with the cell... so for example if
you're using the alternating row format (yellow, white, yellow, white)
and then you sort the rows in the table you might end up with a
"messed up" format where the colors are no longer alternating.

What I usually do in these cases is copy the data into ONE other
sheet, sort the data and then paste it back in the original table.
this keeps the format intact.

I'd be interested to know if there is any othe way of doing it (other
than through VBA)

HTH

Fadi
On Thu, 24 Mar 2005 15:55:01 +0800, "JulieD"
wrote:

Hi Kitty

what do you mean by "messes up the format"
and what version of excel are you using?

Cheers
JulieD

"Kitty" wrote in message
...
Hi there,
I am having trouble working with Excel. Here is what
happens. My master spreadsheet is very big: 123 rows and
7 columns. I need to divide the master spreadsheet into 8
separete (smaller) spreadsheets to send those smaller
spreadsheets to 8 different people. The problem is when I
try to first sort the master spreadsheet by peoples' name
and then copy and paste the sorted section into a brand
new spreadsheet, Excell messes up the format. I have been
struggling spending numerous hours on just trying to
format that monster. The only solution I found is to save
the master spreadsheet 8 times and delete sections that
don't apply, which makes the process extremely time
consuming and prone to error. Is there a better way to
manage large spreadsheets like that? I tried the Help
section, but it did not seem to really apply to this
issue.
Any help is greatly appreciated.
Thank you