0
If you just want to visually check them, you can open both of them and arrange them in a tiled format from the Window menu, by picking Arrange. You will be able to see both files on the screen.
If you want to do calculations across them, then you can refer to another workbook by having its name enclosed in square brackets, followed by the particular sheet name, all enclosed in single quotes and then having an exclamation mark and the cell reference in a formula on the first workbook. So if you wanted to refer to cell A3 on Sheet1 in a file called FirstFile.xls then you would put this in another file:
='[FirstFile.xls]Sheet1'!A3
You may also have to even include the full path to the file, so it could be like this:
='C:\My Documents\[FirstFile.xls]Sheet1'!A3
If you were doing a formula, say to add a value in cell C7 on the open file to the other, then the formula would be:
='C:\My Documents\[FirstFile.xls]Sheet1'!A3+C7
What else can I help you with?
How do you split multi-worksheet Excel files into single-worksheet ones?
Excel worksheet Separator is a powerful, friendly and easy-to-use Excel tool to split multi-sheet excel files into single sheet excel files with high speed. This excel tool can easy to find you excel files and change the complicated ,duplicate and boring excel works into easy ones.
How do you import contacts to groups in way2sms from excel sheet?
how we import contacts by files
How do you convert an Excel database to a Mysql database?
1. For every sheet you have in Excel, create a matching table in MySQL database 2. Export excel data to a CSV file 3. Load the CSV files into MySQL database using one of the following: 3.1 mysqlimport - Loads tables from text files in various formats 3.2 LOAD DATA INFILE command 3.3 Create the tables with CSV storage engine, replace the CSV file in the database directory
Can you sort files in ascending and descending orders?
no only data can be sort from the excel sheet.. not in the file
How do you make a result sheet in Excel?
how to create a excel sheet
What is the full form of PFA in Excel sheet?
Pfa the excel sheet
You are trying to integrate Excel 2007 files with SharePoint 2003 through ODBC connection but you are getting the error that This document contains no visible tables Kindly help you to reslove this is?
The error "This document contains no visible tables" often occurs when the Excel file does not have a defined table or range that SharePoint can recognize. Ensure that your Excel 2007 file has a named range or a designated table by selecting the data and using the "Insert Table" feature. Additionally, verify that the ODBC connection is correctly configured and that the data you want to access is properly formatted and visible in the Excel sheet. If problems persist, try saving the Excel file in an older format (like Excel 97-2003) and test the connection again.
What is the difference between Excel sheet and spread sheet?
They are the same thing, excel is Microsoft's spreadsheet programme.
How do you make a cover sheet in excel?
Add a sheet
How do you calculate Microsoft Excel sheet Debt-Service Coverage Ratio - DSCR?
Calculating DSCR in Excel sheet
How is a sheet made active on excel 2007?
Select the sheet.
How can you provide the cell protection in MS-Excel.?
open a new excel sheet and goto format option and then goto Protect Sheet,open a new dailog box having to many options/attributes and which you want protect check at these boxes protection will be implemented
