Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Gqinvt00
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Marcelo
 
Posts: n/a
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Master Worksheet populated by other Worksheets? Steve Lundwall Excel Worksheet Functions 0 March 3rd 06 01:38 PM
Reference External Worksheets & Protect Worksheet / Workbook DGM Excel Worksheet Functions 0 January 9th 06 10:31 PM
Excel 2000 worksheet where I want to convert date format Russell-stanely Excel Discussion (Misc queries) 5 December 19th 05 02:02 AM
Need to have multiple worksheets use a single worksheet storm5527 Excel Worksheet Functions 1 April 22nd 05 11:25 AM
Keep custom format in new worksheet Buddy Excel Discussion (Misc queries) 2 March 14th 05 10:03 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"