View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Liliana[_4_] Liliana[_4_] is offline
external usenet poster
 
Posts: 39
Default Is it possible to choose a certain amount of rows and have them ex

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.




--