OK, that is clearer. I thought your need was to have fifty rows of data
repeated on every sheet. Your problem is the loss of formatting when
pasting. Column widths being a likely candidate.

Rather than cut and paste, use copy and paste special. For the first paste
special option, choose 'all'. When you see the result is missing something
(say - column widths), just paste special again (no need to copy again) and
select the missing component to paste. Once all is to your satisfaction, go
back to your original sheet and press delete to clear.

XL2003

Edit, Paste Special

XL2007

Home tab, Clipboard group, click the Paste Button, and then click Paste
Special.




?B?b2NlYW4=?= wrote in
:

I don;t understand your answer.

Let me be sure you understand my question

Let's say, I have 300 rows of data on one sheet. What I want to do is
tell excel that I would like to put every 100 rows onto a separate
tab. How do I do that?

"Liliana" wrote:

You can group sheets so data entry, formatting, etc is copied to all
grouped sheets as you amend a single sheet.

To group sheets:
- Click on the first sheet tab you want group
- Press the Shift key and click on the last sheet tab that you want
grouped.

Start typing, formatting, etc.

- To ungroup, click a sheet tab other than the sheet that has focus.

To speed things up, try pasting using Ctrl-V instead of Excel menus.


--
Lil





?B?b2NlYW4=?= wrote in
:

I would like to choose lets say 50 rows of data and have every 50
rows go on each tab? Is that possible? I have already entered the
data into the rows and when I tried to cut and paste, all of the
formatting was lost. Thank you.




--





--