Pasting across worksheets

A

Andrew

How can I put the same text into the same cell in all worksheets in an Excel
file?

I want to take the text in C3 in worksheet 1 and put in in C3 in all
worksheets in the same file.
 
S

Sandy Mann

select the first sheet, press and hold the SHIFT key while you select the
last sheet with the mouse, this will select all sheets. Now anything that
you enter into any cell will be entered into all sheets.

To de-select the sheet again right-click on any sheet and select "Ungroup
Sheets"

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
T

Toppers

Two or more adjacent sheets:

Click the tab for the first sheet (Sheet2). Then hold down SHIFT while you
click the tab for the last sheet (Sheetn) that you want to select.

in C3 on first sheet (Sheet2), put =Sheet1!C3

OR

copy C3 in your Sheet1 and having selected all your other sheets, paste
(copy of)Sheet1 C3 into C3 of Sheet2.

HTH
 
Top