excel 2007 questions please

[Guest]

1. on a sheet i received to day - When date is typed into Cell D4 as 7/8/07 -
cells D11-D17 which appear blank (not 0's) populate the dates of 7/8/07 to
7/14/07. How to do this? I understand that D4= date and format cells to be
such. If I specify that D11=D4+1 etc on down the line I get all 0's until I
enter in D4 date. I just want to be able have a pristine blank sheet that
when I put in the start of the pay period it will populate the rest of the
time period.

2. How to black out all other cells not on the sheet, it is like everything
but the print area is black, how do you black out non pertinant oparts of the
sheet?

3. In excel 03 I could open more than one occurance of excel and place
sheets side by side. I did this in file associaltions - file types -
advanced and by adding /e "%1" to the open string. In 07 I can not do this?
How can I open more than one occurance of excel like word does? If I open
several excel docs they all open but in the same occurance of excel. I hope
this makes sense?????

The sheet I am asking about came pass protected and no one can remember the
PW so I can see for myself how this was done - so I am at odds in trying to
figure out how this is done so I can alter it for the office.

 

[Guest]

#1: in D11 put this formula
=IF(ISBLANK(D$4),"",D$4+1)
in D12 put this formula
=IF(ISBLANK(D$4),"",D11+1)
now you can fill that formula from D12 on down the sheet, all will remain
empty looking until you enter something in D4.

#2 - many ways to do that. The most obvious being to simply select the
known unused cells and change cell shading to black. If you mean they're
black until you enter something in them, I expect that they have conditional
formatting applied in some fashion. For example, in the range D1118 (where
I put formulas as above) I used conditional formatting that was set to Cell
Value and 'equal to' with
=""
as the equal to portion and then chose shading to be black. So, when
there's no date up in D4, all of those cells contain "" (zero length string)
and are black, but when I enter a date into D4, they not only show a date,
but they become not-black shaded!

If I wanted to do it for all cells on a sheet (or within a given area of the
sheet), I'd probably pick an empty cell somewhere and manually shade it
black, then set the rest of the cells to conditional formatting with Value
is equal to and point to that empty cell and set formatting to black shading
(with white text).

#3 - don't have 2007 on this machine to test.