Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel I want to copy text from spreadsheet to spreadsheet
I have a 12 page worksheet. I would like to pull the TEXT from sheet one to
sheet two and so on. (like I do with my formulas) I can't figure out how to do this. Can anyone help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel I want to copy text from spreadsheet to spreadsheet
if i got u right :
Activate last sheet-tab where u want text hold down SHIFT-key activate all other sheet-tab u want the text Activate the cell u want text and press = Activate the sheet and cell where text u want to copy is Hit ENTER copy text to all activated sheets and selected cells |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel I want to copy text from spreadsheet to spreadsheet
if u dont want the link then:
copy ur text Activate all ur destination sheets activate destination cell paste |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel I want to copy text from spreadsheet to spreadsheet
Perfect!! Thank you
"excelent" wrote: if i got u right : Activate last sheet-tab where u want text hold down SHIFT-key activate all other sheet-tab u want the text Activate the cell u want text and press = Activate the sheet and cell where text u want to copy is Hit ENTER copy text to all activated sheets and selected cells |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect excel sheet and still copy text or object w/o unprotectin. | Excel Discussion (Misc queries) | |||
Copy data from one Excel spreadsheet to another | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel find text and copy rows | Excel Discussion (Misc queries) | |||
How do I edit, copy and paste text in excel cells? | New Users to Excel |