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

  • monti_gi Jan 02, 2008

    exel size is to heavy as compare to data

×

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 48 Answers

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.

exel 2003 - default.aspx?assetid=za010939481033 Refers to the worksheet named Marketing 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.) , 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

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How can I copy and Paste teks from Face Book to Word or Exel


select it (double click a word, click and drag, or hold shift and use arrow keys)
screen shot works well too.

its different on a mac/pc/mobile device.

Aug 21, 2016 | Computers & Internet

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 Computers & Internet

1 Answer

If a calculation made in exel, 2003 work book, which command should be use to forward the value of result in other sheet?


write "=" in any cell of the new sheet, and then write .. eg. if in sheet 1 result is in B8 and you have to transfer the result in sheet2 in any cell. just write "=Sheet1!B8" in any cell of sheet2.
enjoy !! thank you for using fixya !!!

Nov 11, 2010 | Microsoft Computers & Internet

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....
i.e.
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

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


http://office.microsoft.com/en-us/excel/HA100141071033.aspx

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


http://office.microsoft.com/en-us/excel/HA100141071033.aspx

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.

thanks

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

276 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3015 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...