+ Reply to Thread
Results 1 to 3 of 3

Creating Grouped Worksheets

  1. #1
    Registered User
    Join Date
    01-09-2006
    Location
    Massachusetts
    MS-Off Ver
    Version 2402 Build 16.0.17328.20124)
    Posts
    60

    Creating Grouped Worksheets

    Hi,
    I am using a file that has multiple tabs. When I create the columns and formats in Sheet 1, is there a way I can have this grouped to all other tabs? I created the first wkst, and copied it to all the other tabs (timely, but worked) however, everytime I make a change to wkst 1 (example adding columns or rows), I'd like to be able to have it automatically populate into the other sheets. Many years ago I seem to remember some way of grouping worksheets. Also, if the formatting and set up can be duplicated, is it possible to have the formulas from worksheet 1 populate to the other tabs?
    I am trying to be able to set this worksheet up only once to avoid going in to each tab everytime I make a change in formats or formulas.
    Thanks for any help you could provide.
    Last edited by Janie; 07-24-2013 at 10:52 AM. Reason: addtional information

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Creating Grouped Worksheets

    1) Click on the sheet1 to activate it
    2) Shift-click on the last sheet. This groups all the sheets and "selects" them all at the same time
    3) Make your formatting edits on sheet1, they will be happening in all sheets at the same time

    When done:
    4) Right-click on the sheet tabs and select UNGROUP sheets.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Creating Grouped Worksheets

    Before making changes to one sheet, group all sheets together
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating and naming multiple worksheets; copying contents to new worksheets
    By HeadfortheHills in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-14-2012, 08:49 AM
  2. help with macro - creating new columns/copying/creating new worksheets from default
    By vsantoro in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-17-2010, 09:29 AM
  3. Creating "grouped" checkboxes
    By aeshower in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2006, 11:06 AM
  4. VBA / Macro for creating new worksheets and new columns from existing worksheets
    By webby2006 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2006, 10:38 AM
  5. [SOLVED] protect/unprotect grouped worksheets
    By Todd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2005, 12:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1