Hi, When I used Lotus 123 I was able too create say 100 sheets And then
highlight And copy the first sheet then using Shift and page up I could copy
allthe propertys of the first sheet onto the other 99, is there a similiar
system on excel, also how many sheets can I open.

Thank you in advance, Wildauk.

You can select as many sheets as you want to. Select one sheet and then
holding down the shift key select another sheet (to grab all of the sheet sin
between) or holding down the control key to select multiple individual
sheets. similar to the functionality in windows explorer...

So to do what you want select the sheet you wnat to copy from and select all
o f the cells. Now copy (Ctrl + C). Select all of the sheets you want to
paste too. Right click and select paste special. Now select the format you
want (one at a time is the only option so you may have to paste special a few
times) and paste.
--
HTH...

Jim Thomlinson


"wildauk" wrote:

Hi, When I used Lotus 123 I was able too create say 100 sheets And then
highlight And copy the first sheet then using Shift and page up I could copy
allthe propertys of the first sheet onto the other 99, is there a similiar
system on excel, also how many sheets can I open.

Thank you in advance, Wildauk.