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.

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.




--

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.




--

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.




--





--

Thank you. I get the feeling that what I want to do is not possible. It looks
like my only option is to copy and paste, but I wanted to tell excel to put a
certain range of data on each tab. For example, ask excel to put my 100 rows
of data I have already entered onto one tab and so on. Thank you for your
help.

"Liliana" wrote:

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.




--





--

I would not say "cannot be done" about anything in Excel. It is amazing
what some perople can achieve. My perception of your reqirements are
currently very scant in detail - you want to copy data fifty rows at a time
to other sheets; copy paste does not do what you wish. If you describe in
more detail what you need and your general aim in doing this, perhaps your
problem may be relatively easy to resolve? Perhaps a simple macro will
automate a task for you? Perhaps there is an alternative solution?


--Lil




?B?b2NlYW4=?= wrote in
:

Thank you. I get the feeling that what I want to do is not possible.
It looks like my only option is to copy and paste, but I wanted to
tell excel to put a certain range of data on each tab. For example,
ask excel to put my 100 rows of data I have already entered onto one
tab and so on. Thank you for your help.