+ Reply to Thread
Results 1 to 2 of 2

insert formula in many sheets

  1. #1
    Registered User
    Join Date
    12-19-2008
    Location
    Vancouver,WA
    MS-Off Ver
    2007 Excel
    Posts
    87

    insert formula in many sheets

    I have a book with twenty sets ofsheets Each 20 sets has 4 sheets. I would like to place a formula into all twenty sets of four but only into the 2nd sheet of each set. Is there an easyer way then going to each sheet to put in the formula.
    Last edited by amsanborn; 01-27-2010 at 12:30 AM.
    AL

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: insert formula in many sheets

    If the formula you're going to enter is in the same cell on all 20 sheets, the easiest way would be to hold down the CTRL key and then click on the 20 sheet tabs you want to modify. This will select them as a group, so that any change you make to one sheet will also be made on the other 19. Once you're done adding the formula, be sure to click on another sheet tab (or right-click one of the selected sheet tabs and choose "Ungroup sheets", otherwise you'll keep changing all 20 sheets at once - possibly unintentionally).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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