how do i format from the main worksheet to the other worksheets s.

So all i have to do is input it in the main worksheet then it will go to all
the others

Hi,

select all worksheets where you would like to format or imput the same
values, using CTRL (mantainm ctrl pressed and click on the sheets).
all changes that you do on the main ws will reflect in all you have been
select

hth
regards from Brazil
Marcelo



"Gqinvt00" escreveu:

> So all i have to do is input it in the main worksheet then it will go to all
> the others

Investigate the use of "linking cells" through the Help section of Excel.

Also see "grouping worksheets" to learn how to link multiple sheets at one go.


Gord Dibben MS Excel MVP



On Mon, 26 Jun 2006 12:12:03 -0700, Gqinvt00
<[email protected]> wrote:

>So all i have to do is input it in the main worksheet then it will go to all
>the others