LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 47
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting Quickbooks 2007 to Excel 2007 BShennum Excel Worksheet Functions 0 June 22nd 07 07:09 PM
Excel 2007 vs. 2003 VBA Control Questions Ondy2112 Excel Discussion (Misc queries) 3 May 29th 07 10:41 PM
Some questions about Excel 2007 Charts fujing1003 Charts and Charting in Excel 3 April 10th 07 03:40 PM
Toolbar questions in 2007 Anita Excel Discussion (Misc queries) 1 February 11th 07 05:48 PM
Couple of Office 2007 questions Karl Excel Discussion (Misc queries) 4 December 10th 06 11:46 AM


All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"