Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |