Question about Microsoft Office Standard for PC

1 Answer

Exel 2003 i have exel 2003 work book and i want copy this sheet and paste this sheet in another work book.and i want when im change anything in this sheet then same time im want to see this change in copy work sheet. how can this possible without cut & paste.

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert who has answered 20 questions.


    An expert that hasĀ over 10 points.


    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 48 Answers
Re: exel 2003

You can refer to cells that are on other worksheets by perpending the name of the worksheet followed by an exclamation point (!) to the cell reference. In the following example, the AVERAGE worksheet function calculates the average value for the range C1:C10 on the worksheet named Marketing in the same workbook.

default.aspx?assetid=za010939481033 Refers to the worksheet named Marketing default.aspx?assetid=za010939491033 Refers to the range of cells between C1 and C10, inclusively

  1. Click the cell in which you want to enter the formula.
  2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) default.aspx?assetid=za060515351033, type = (equal sign).
  3. Click the tab for the worksheet to be referenced.
  4. Select the cell or range of cells to be referenced.

Posted on Jan 01, 2008

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

2 Answers

How do you copy and paste one excel spreadsheet to another making sure the headers are lined up correctly.

right-click the sheet you want to copy, select "copy to", then either select the position within the current document, select annother document (needs to be open in the same excel instance) or select "new document". check the box "copy" to copy, leave unchecked to move.

Jan 01, 2016 | Microsoft Excel Business & Productivity...

1 Answer

Excel 2003 cell is highlighted, font color is selected, but the color on the screen remains black. When printing the color prints out correctly while showing black on the screen

to remove all formats....
open another workbook....
copy all data from the present sheet to the new work book....
present workbook
select data/edit/copy

new work book
select cell edit/paste special/values

now do the formating/color/font/size etc in the new workbook and check if they work here

Dec 14, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

How to sende information from a sheet to another?

You can link to the original sheet or copy and paste - Linking might be easier as you only have 10. - Can you not use worksheets rather than excel. If you want to make it more autonomous you can index or look up the first sheet so any changes you make will be reflected back in your employee sheets.

May 26, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Tools protect workbook& sheet

Open the protected sheet... Go to edit and click select all. Go back to edit and click on copy. Open a new excel sheet, go to edit and click on paste. Now you have the copy of the protected sheet without the protection.

Jan 23, 2009 | Steinberg Cubase Studio 4 Upgrade Version...

1 Answer

Cells copies post as bitmap

I think you are referring to 2003 onwards when this problem appears - in which case at the bottom right hand corner of any pasted item is a list of options and buttons which will refer to the table. cells or image being pasted.

Click on the table option to retain your formatting.

Jan 11, 2009 | Microsoft Excel for PC

1 Answer

Excel 2003 / 2007 vba code

A similiar thing happened to me once and I used the format
"Sheets("Lab Work Order Master").Copy(,ActiveSheet)" instead of
"Sheets("Lab Work Order Master").Copy After:=ActiveSheet"

You may also want to try using a sheet index instead of "ActiveSheet" to refer to your sheet.
P.S. Don't forget to rate me. Wish you the best.

Oct 17, 2008 | Microsoft Office Standard for PC

1 Answer

Exel 2007 not open in exel 2003

This is because 2007 excel uses a different type of file. You may follow the directions at the link below on how to save files in 2007 excel so that you can open it in 2003

Sep 25, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

EXEL 2007

This is because 2007 excel uses a different type of file. You may follow the directions at the link below on how to save files in 2007 excel so that you can open it in 2003

If there is anything else please do message me.

Sep 25, 2008 | Microsoft Office Professional 2007 Full...

5 Answers

Formula required

at first select the 1st page data and select data-subtotal from the upper menu list.
then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.


Dec 04, 2007 | Microsoft Excel for PC

2 Answers

Forgotten password

good day the only way to fix this little problem is to select all and copy into a whole new book( by opening start Excel doc, and past the copy into the new book. that is the salution I have BUT THE COPING MUST BE DONE ON THE SAME PC WHERE YOU 'VE DEVELOPE THE DOCUMENT

Sep 26, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

263 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides