Excel 2007

[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!ec!B7)" when Summary sheet is moved it creates a cirucular
reference. Is there a way around it ?

thanks in advance,

Rick

 

[Dave Peterson]

#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).