ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how do i format from the main worksheet to the other worksheets s. (https://www.excelbanter.com/new-users-excel/96163-how-do-i-format-main-worksheet-other-worksheets-s.html)

Gqinvt00

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

Marcelo

how do i format from the main worksheet to the other worksheets s.
 
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


Gord Dibben

how do i format from the main worksheet to the other worksheets s.
 
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
wrote:

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




All times are GMT +1. The time now is 08:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com