Excel Help

Discussion in 'Windows Desktop Systems' started by Sinster, Dec 13, 2004.

  1. Sinster

    Sinster Moderator

    Messages:
    520
    Location:
    M*ssholechusetts
    How do you go about editing seperate pages at the same time?

    I have a form and there are twelve entries which are all the same. I need to edit a the same fields on all of them. Instead of doing it one by one is there a way to edit all of them at one time?

    Also if I cut and paste the form the formulas don't work in the cells of the sheet I just pasted. For example I have an "ID" page so for example in one of my cells I have "='ID Page'!A9"
     
  2. jimi_81

    jimi_81 Moderator Political User

    Messages:
    820
    Location:
    Stoney Creek, ON, Canada
    for the 1st part, i dont know
    for the 2nd part... maybe try using the $.
    doesnt $ fix cells, rows, or pages?
     
  3. bush dogg

    bush dogg OSNN Senior Addict Political User

    Messages:
    433
    Location:
    Kansas
    I don't use Excel much anymore (I need to) but I think this worked for me if I remember right. (I use 2002)

    Enter data in multiple worksheets at the same time

    As an example, let's say you want to put the same title text into different worksheets. One way to do this is to type the text in one worksheet, and then copy and paste the text into the other worksheets. If you have several worksheets, this can be very tedious.

    An easier way to do this is to use the CTRL key:

    1. Start Excel. A new, blank workbook appears.
    2. Press and hold the CTRL key, and then click Sheet1, Sheet2, and Sheet3.
    3. Click in cell A1 in Sheet1, and then type:

    This data will appear in each sheet.
    4. Click Sheet2 and notice that the text you just typed in Sheet1 also appears in cell A1 of Sheet2. The text also appears in Sheet3.


    From Here
     
  4. Sinster

    Sinster Moderator

    Messages:
    520
    Location:
    M*ssholechusetts

    How do I go about fixing the formula.
     
  5. bush dogg

    bush dogg OSNN Senior Addict Political User

    Messages:
    433
    Location:
    Kansas
    I'm not sure how to fix the formula at this point on the sheets you cut and pasted.

    But if the formula in the first sheet still works you can use it and make new copies from instruction above or I just found this in Excel help that might be easier to try.


    Move or copy sheets

    (Caution: Be careful when you move or copy sheets. Calculations or

    charts based on worksheet data might become inaccurate if you move

    the worksheet. Similarly, if you insert a worksheet between sheets that

    are referred to by a 3-D formula reference, data on that worksheet might

    be included in the calculation.)

    To move or copy sheets to another workbook, open the workbook that

    will receive the sheets.
    Switch to the workbook that contains the sheets you want to move or

    copy, and then select the sheets.


    When you enter or change data, the changes affect all selected sheets.

    These changes may replace data on the active sheet and other selected

    sheets.

    To select >Do this
    A single sheet> Click the sheet tab.


    If you don't see the tab you want, click the tab scrolling buttons to

    display the tab, and then click the tab.



    Two or more adjacent sheets> Click the tab for the first sheet, and then

    hold down SHIFT and click the tab for the last sheet.

    Two or more nonadjacent sheets> Click the tab for the first sheet, and

    then hold down CTRL and click the tabs for the other sheets.

    All sheets in a workbook> Right-click a sheet tab, and then click Select

    All Sheets on the shortcut menu.

    Note If sheet tabs have been color-coded, the sheet tab name will be

    underlined in a user-specified color when selected. If the sheet tab is

    displayed with a background color, the sheet has not been selected.

    Cancel a selection of multiple sheets>

    To cancel a selection of multiple sheets in a workbook, click any

    unselected sheet.

    If no unselected sheet is visible, right-click the tab of a selected sheet.

    Then click Ungroup Sheets on the shortcut menu.

    On the Edit menu, click Move or Copy Sheet.
    In the To book box, click the workbook to receive the sheets.

    To move or copy the selected sheets to a new workbook, click new

    book.

    In the Before sheet box, click the sheet before which you want to insert

    the moved or copied sheets.

    To copy the sheets instead of moving them, select the Create a copy

    check box.