I need the spreadsheet to calculate in more rows than i can get on one page is there a way to continue over one page and keep the formula to add up the two pages together. I need a spreadsheet for more calculations than its possiable to get on one page can you link over to pages so that it still basically one spreadsheet I hope i have explained myself
2006-12-17 22:40:55 · 6 answers · asked by noodles 1 in Computers & Internet ➔ Programming & Design
By 'Page' I assume you mean 'Sheet'?
Yes you can have formulas across a worksheet that refer to various sheets in the workbook.
Read here for more
http://einstein.cs.uri.edu/tutorials/csc101/pc/excel97/excel.html
///
2006-12-17 22:45:59 · answer #1 · answered by jan 7 · 2⤊ 0⤋
The spreadsheet behaves like one huge sheet and it doesn't matter if it goes over - you can calculate on columns or rows, you can even calculate on different worksheets if you want to. Take a look at the help files - they are really good.
2006-12-17 22:47:10 · answer #2 · answered by Lupee 4 · 1⤊ 0⤋
There are thousands of rows available in Excel. The number of pages the sheet appears in when printed is irrelevant, it is still just one spreadsheet.
2006-12-17 22:44:45 · answer #3 · answered by SteveT 7 · 1⤊ 0⤋
There are hundreds, if not thousands of rows & columns on one sheet - just scroll.
Or you can go to the next sheet and link the two, like MyBrainhurts says
2006-12-17 23:37:23 · answer #4 · answered by champer 7 · 0⤊ 0⤋
Yes,
Input values into 2nd sheet...then when you select the values you want to add into the equation just pick them off the second sheet.
Or manually type =Sheet1!A1+Sheet2!A1
Just use the Sheet#! command before the cell name to tell excel where to look for the value
Easy :)
2006-12-17 22:43:22 · answer #5 · answered by king_badger 3 · 0⤊ 0⤋
Yes, An example to link a cell in sheet 2 to a cell in sheet1.
=sheet1!a1, that is supposed to be an exclamation mark !!! before a1 (or whatever)
2006-12-17 22:44:57 · answer #6 · answered by ♣ My Brainhurts ♣ 5 · 0⤊ 0⤋