0
You can refer to cells on another sheet in the same workbook by putting the sheet name, followed by an exclamation mark and the cell number. So if you are in Sheet1 you can refer to cell C5 on Sheet2 like this:
=Sheet2!C5
If you want to copy something from one sheet to another, and have it linking back to the first sheet, what you do is use the Paste Special option from the Edit menu, instead of Paste, and then click on Paste Link in the dialogue box that opens.
If you are linking two separate workbooks, you will have the name of the workbook in square brackets as part of the reference like this:
=[Book2]Sheet2!C5
See the related question below.
What else can I help you with?
What equals 83 plus 2 in Microsoft Excel?
=83+2
Which was first Lotus 1 2 3 or Excel?
Lotus 123 came before Microsoft Excel by about 2 years.
How do you type 2 raise to 3 in Microsoft Excel?
You would type in =2^3
What is the name used to describe the m 2 in Microsoft Word or Excel?
nobady
Microsoft Excel and lotus 1-2-3 are examples of what software?
Email Software
What has the author Rick Winter written?
Rick Winter has written: 'Microsoft Excel 2000' -- subject(s): Business, Computer programs, Electronic spreadsheets, Microsoft Excel (Computer file) 'Using Microsoft Office for Windows 95' -- subject(s): Business, Computer programs, Integrated software, Microsoft Excel (Computer file), Microsoft Office, Microsoft PowerPoint (Computer file), Microsoft Word, Word processing, Microsoft Excel (Computer program), Microsoft PowerPoint (Computer program), Microsoft Office (Computer program) 'Learning Access 2000' '1-2-3 Release 2.4 QuickStart' -- subject(s): Business, Computer programs, Electronic spreadsheets, Lotus 1-2-3 (Computer file) 'Using Microsoft Office 97, small business edition' -- subject(s): Business, Computer programs, Desktop publishing, Electronic spreadsheets, Maps, Microsoft Excel (Computer file), Microsoft Internet Explorer, Microsoft Office, Microsoft Outlook, Microsoft Publisher, Microsoft Word, Personal information management, Presentation graphics software, Roads, Time management, Word processing 'Microsoft Office 97 user manual' -- subject(s): Business, Computer programs, Electronic mail systems, Electronic spreadsheets, Microsoft Excel (Computer file), Microsoft Office, Microsoft Outlook, Microsoft PowerPoint (Computer file), Microsoft Word, Personal information management, Presentation graphics software, Time management, Word processing '1-2-3 for DOS release 2.3 QuickStart' -- subject(s): Business, Computer programs, Lotus 1-2-3 (Computer file)
What is the difference of Microsoft Excel from lotus 123?
One is a spreadsheet program made by Lotus the other is a spreadsheet program made by Microsoft. The main difference is the way in which formulas are entered - in Excel they are preceded by the = symbol and in 1-2-3 they are preceded by the + symbol.
How do you enter Pi in Microsoft Excel?
=PI()If you want to multiply PIr2 use the formula: =PI()*(r^2)
How do you insert a Microsoft office Excel chart into a document?
Numerous ways: 1. Insert, Chart/graph from excel 2. Copy on excel and paste into word 3. If all else fails print screen and paste into word
What is spreadsheet application?
Calc (LibreOffice) and Excel (Microsoft) Lotus 1-2-3 (IBM) are all spreadsheet applications.
What is the most popular spreadsheet application and why is it used?
Without doubt, Microsoft Excel is the most popular spreadsheet program, as it is used in most offices around the world. Excel's dominance has been decreasing however, as competition in this area has increased in recent years.
What is a formula in Microsoft Excel?
A formula in Microsoft excel is like a formula in real life, like a math equation or math problem (ie. 2+2=4). You write the Excel formula like this: =2+2Actually it is more like =A1+A2 Or =SUM(A1:D2)The SUM is a Function the A1 -> D2 is The RangeAnd the : is the argument. When you have =SUM(A1:D2)you are adding the cell from A1 -> D2 so you are adding them together
