• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Excel Help

#1
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"
 

bush dogg

OSNN Senior Addict
Political User
#3
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
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.
 

bush dogg

OSNN Senior Addict
Political User
#5
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 posts

Latest profile posts

Electronic Punk wrote on Perris Calderon's profile.
All good still mate?
Hello, is there anybody in there? Just nod if you can hear me ...
Xie
What a long strange trip it's been. =)

Forum statistics

Threads
61,961
Messages
673,239
Members
89,014
Latest member
sanoravies