View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default On a Excell spreadsheet how do I imput a formala in certain cells

hi
if you just want to pull the value of one cell....
=sheetname!A1
or
=Sheet1!A1

you can put an equal sign in the cell you want the formula then click on the
sheet tab that has the data you want then click the cell that has the data
then hit enter. excel will write the fomula for you

regards
FSt1

"Bill Kaminska" wrote:

How do I imput a formala in a certain cell on my spreadsheet to total on the
last page. Each page has a total but I want to be able to total all those
totals from each page to a Grand Total on the last page?