Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2007 questions please
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. -- Thanks,, Kim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2007 questions please
#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 D11:D18 (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. "Kim K" wrote: 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. -- Thanks,, Kim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting Quickbooks 2007 to Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 vs. 2003 VBA Control Questions | Excel Discussion (Misc queries) | |||
Some questions about Excel 2007 Charts | Charts and Charting in Excel | |||
Toolbar questions in 2007 | Excel Discussion (Misc queries) | |||
Couple of Office 2007 questions | Excel Discussion (Misc queries) |