Excel Help

Sinster

OSNN Senior Addict
Joined
8 Dec 2001
Messages
520
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"
 
for the 1st part, i dont know
for the 2nd part... maybe try using the $.
doesnt $ fix cells, rows, or pages?
 
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
 
bush dogg said:
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


How do I go about fixing the formula.
 
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.
 

Members online

No members online now.

Latest profile posts

Also Hi EP and people. I found this place again while looking through a oooollllllldddd backup. I have filled over 10TB and was looking at my collection of antiques. Any bids on the 500Mhz Win 95 fix?
Any of the SP crew still out there?
Xie wrote on Electronic Punk's profile.
Impressed you have kept this alive this long EP! So many sites have come and gone. :(

Just did some crude math and I apparently joined almost 18yrs ago, how is that possible???
hello peeps... is been some time since i last came here.
Electronic Punk wrote on Sazar's profile.
Rest in peace my friend, been trying to find you and finally did in the worst way imaginable.

Forum statistics

Threads
62,015
Messages
673,494
Members
5,621
Latest member
naeemsafi
Back