Excel 2007

  • Thread starter Thread starter RMP
  • Start date Start date
R

RMP

Questions of Excel 2007:
Is it possible to adjust the spacing within a cell with wrap text?
Is it possible to have the sheet name appear in the doc. besides being in
the header/footer?
When creating a formula on a "Summary" sheet that links other sheets
"=sum(Jan!:Dec!B7)" when Summary sheet is moved it creates a cirucular
reference. Is there a way around it ?

thanks in advance,

Rick
 
#1. Maybe you can add alt-enters to "double space" the text in the cell.

#2. You can use a formula. Visit Debra Dalgleish's site:
http://contextures.com/xlfaqFun.html#SheetName

#3. If the formula that causes the error is in the summary sheet, make sure you
move it outside that "sandwich" of worksheets (left of Jan or right of Dec).
 
Back
Top